Best of 2018

The blog posts Hacker News loved most in 2018. 265 posts.

Databases & Data
245

LMDB: Intel Optane SSD Microbenchmark

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…

248

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…

255

Text Matching Using Cosine Similarity

Recently I was working on a project where I have to cluster all the words which have a similar name. For a novice it looks a pretty simple job of using some Fuzzy string matching tools and get this done. However in reality this was a challenge because of multiple reasons starting from pre-processing of the data to…

262

Atomic Commit in SQLite (2007)

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…