Topics /
The most popular blog posts about databases & data on Hacker News. 170 posts.
PostgreSQL has a rich collection of extensions and nearly 100 different data types, each with their own tuned indexing or specialized functions. You probably already use integers and text, and today we're going to explore a few less-used but incredibly powerful PostgreSQL data types.
Window functions in PostgreSQL are valuable when you want to compare & contrast data between rows. And window functions are key in analytics use cases. This post covers the basic structure of window functions as well as some of the more interesting things you can do with them.
Install TimescaleDB on Linux, macOS, Windows, Docker, Kubernetes, or from source
Since the point of these tests is to explore the performance of the Optane SSDs, the tests are configured much like the previous ondisk benchmark, using a database approximately 5x larger than RAM, to minimize the impact of caching in RAM and force the storage devices to be exercised. However, there are some twists to…
CockroachDB 2.1 is 50x more scalable than Amazon Aurora at less than 2% of the price per tpmC. Read on to see performance benchmarks of CockroachDB 2.1, including the latest TPC-C results.
January 31, 2025: Post updated to clarify the reduced on-demand pricing and workloads recommendations. Just a few years ago, creating a database that could support your business at any scale while providing consistent low latency was a daunting task. That changed for me in 2012 while reading Werner Vogels’ blog post…
More than a billion people now use Facebook Messenger to instantly share text, photos, video, and more. As we have evolved the product and added new functionality, the underlying technologies that …
Spotify's direct listing IPO filing reveals how monthly churn fell from 7.7% to 5.5% as personalization and family plans drove subscriber retention at scale.
Now that MySQL 8 and PostgreSQL 10 are out, it's a good time to revisit how the two major open source relational databases compete against each other. Before these versions, the general perception has been that while Postgres is superior in feature sets and its pedigree, MySQL is more battle
Take a closer look into why—and where—top programming languages are popular.
If you’ve had the chance to read our GDPR white paper or our previous GDPR primer blog post, you’ve, no doubt, seen the word "pseudonymization" used extensively to describe one technical measure that ...
An important feature of transactional databases like SQLite is "atomic commit". Atomic commit means that either all database changes within a single transaction occur or none of them occur. With atomic commit, it is as if many different writes to different sections of the database file occur instantaneously and…
One of our large scale data infrastructure challenges here at Cloudflare is around providing HTTP traffic analytics to our customers. HTTP Analytics is available to all our customers via two options:
Back in the early 1980s, Dr. David DeWitt – who you might know from past PASS Summit keynotes, formerly of Microsoft (LinkedIn) – was working on measuring database performance. His team wrote a benchmark, ran it against Oracle, and Oracle didn’t fare well in the results. Oracle reacted as one would expect – they were…
