Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
Starting with v2.0, scheduled for fall 2026, DuckDB will support asynchronous reads of Parquet and CSV files. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, as is typical in EC2/S3 compute-storage setups.
Caches help reduce latency, scale read-heavy workloads, and save cost. They are literally everywhere. Caches run on your phone and in your browser. For example, CDNs and DNS are essentially geo-rep…
Dive into Backblaze's analysis of storage server performance, exploring Drive Stats, Storage Pods, and insights on drive failure rates since 2009.
Neki, sharded Postgres by PlanetScale, is now available in platform preview.
AWS S3 Vectors aims for 90% cost savings for vector storage. But will it kill vectordbs like Milvus? A deep dive into costs, limits, and the future of tiered storage.
Update June 1, 2021 – Amazon Location Service is now generally available and includes routing and raster (satellite) maps. You can easily and securely add maps, geocoding, routing, tracking, and geofencing to your applications. Read more about the new features in our new blog post here or try it now in the console. We…
[M]ortgages were acknowledged to be the most mathematically complex securities in the marketplace. The complexity arose entirely out of the option the homeowner has to prepay his loan; it was poetic …
Visualizing the exponential growth of COVID-19 across the world.
61,590 hard drives were used in our data center during Q1, 2016. We take a deep dive into the usage to see what we can learn about their performance.
PlanetScale is the first database designed for developer workflows on top of the technology of the hyperscalers.
SQLite WAL has checksums, but on corruption it drops all the data and does not raise error
First released with Zstandard 1.3.2 in 2017, the --long range match finder increases the compressor’s search window to at least 128MiB, improving deduplication inside large files. This optional feature had substantial performance overheads at launch, but various optimisations have since brought its performance within…
Access to this page requires authorization. You can try signing in or changing directories .
You don't need Elasticsearch for most projects. I built a simple search engine from scratch that tokenizes everything, stores it in your existing database, and scores results by relevance. Dead simple to understand and maintain.
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for Auto-Regressive and MA stands for Moving Average
Berkeley Haas research finds there may be a dark side to the rise of “alternative data” in capital markets While Assoc. Prof. Panos Patatoukas was discussing Walmart in his Financial Information Analysis course last year, a student brought up the story of how company founder Sam Walton used to count cars in store…
Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with...
ClickHouse Cloud has entered public beta. Get your free trial now!
SQL:2023 has been wrapped. The final text has been submitted by the working group to ISO Central Secretariat, and it’s now up to the ISO gods when it will be published. Based on past experience, it could be between a few weeks and a few months.
I'm currently working on a logging project that was initially implemented using AWS Elasticsearch. Having worked with large-scale mainline Elasticsearch clusters for several years, I'm absolutely stunned at how poor Amazon's implementation is and I can't fathom why they're unable to fix or at least improve it. I…
The 2022 Cloud Report is the only cloud performance report to compare AWS, Azure, and GCP on benchmarks that reflect critical applications and workloads.
Among open-source relational databases, PostgreSQL is one of the most popular—and the most sought-after by Google Cloud Platform (GCP) users. Today, we’re thrilled to announce that PostgreSQL is now generally available and fully supported for all customers on our Cloud SQL fully-managed database service.
Introducing KSQL, a streaming SQL engine for Apache Kafka. KSQL provides a simple and completely interactive SQL interface for processing data in Kafka.
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
This post walks through a conversion funnel analysis that wouldn’t be possible in PostgreSQL 9.2
An analysis and infographic of 10,000 porn stars and adult films, revealing what the average adult performer looks like and does on film.
