541
Hermitage: Testing the “I” in ACID
tl;dr: I have created a test suite for comparing the transaction isolation levels in different databases. I did this as background research for my book . This post explains why.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 561 posts.
542
ScaNN: Efficient Vector Similarity Search
Posted by Philip Sun, Software Engineer, Google Research Suppose one wants to search through a large dataset of literary works using queries that r...
543
R programming for those coming from other languages
Things a programmer coming from another language needs to know about R, especially those things that might be most surprising
544
DeWitt Clause, or can you benchmark %database% and get away with it
The DeWitt clause lets database vendors forbid publishing benchmarks. What the clause is, which vendors still use it, and what you can legally publish.
545
IBash Notebook
Did you know that there's a Bash kernel for IPython Notebook? It even displays inline images. Could it ever be a convenient environment for doing data science? Would it be worthwhile to publish my book Data Science at the Command Line as a collection of notebooks?
546
Roshi: a CRDT system for timestamped events
Let’s talk about the stream. The SoundCloud stream represents stuff that’s relevant to you primarily via your social graph, arranged in time order, newest-first. The atom of that data model, an event, is a simple enough thing. Timestamp User who did the thing Identifier of the thing that was done For example, At…
547
Semantic Search with SQLite
txtai is an all-in-one open-source AI framework for semantic search, LLM orchestration and language model workflows
548
549
Amazon DynamoDB On Demand
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…
550
Progress in performance and scalability with CockroachDB
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.
551
Apache Hudi vs. Delta Lake vs. Apache Iceberg Lakehouse Feature Comparison
A thorough comparison of the Apache Hudi™, Delta Lake, and Apache Iceberg™ data lakehouse projects across features, community, and performance benchmarks. This includes a focus on common use cases such as change data capture (CDC) and data ingestion.
552
How Netflix uses Druid for realtime insights
By Ben Sykes
553
Why Did So Many Startups Choose MongoDB?
NoSQL databases were the future. MongoDB was the database for “modern” web engineers and used by countless startups. What happened?
554
DBLog: A Change-Data-Capture Framework
Andreas Andreakis, Ioannis Papapanagiotou
555
One way to fix your rubbish password database
Suppose for a moment that you are running a web site that has a poorly implemented password database that stores password hashes using some...
556
20x faster than pgvector: HNSW index in Postgres with pg_embedding
We’re excited to announce the release of our pg_embedding extension for Postgres and LangChain! The new pg_embedding extension brings 20x the speed for 99% accuracy to graph-based approximate nearest neighbor search to your Postgres databases. While the pgvector extension with IVFFlat indexing has been a popular…
557
The CAP theorem. The Bad, the Bad, & the Ugly
The CAP theorem is too simplistic and too widely misunderstood to be of much use for characterizing systems.
558
Faster DISTINCT queries on PostgreSQL
Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.
559
Six Months of HackerNews Front Page Data
Back in September 2009 I launched a small web app called HNTrends.com, a tool for visualizing the movement of stories on HackerNews’s front page over time. I haven’t worked on the site …
560
NoSQL, Heroku, and You
Why NoSQL Matters “NoSQL” is a label which encompasses a wave of innovation now happening in the database space. The NoSQL movement has sparked a whirlwind
561