2011
How Does Sqlite Work? (2014)
How does SQLite work? Part 1: pages!
New
The latest blog posts to take off on Hacker News. 4,224 posts.
2012
2013
The largest city in each 10x10 degree latitude/longitude box
From the highly eclectic blog of Mark Dominus
2014
Jepsen: Redis-Raft 1b3fbf6
Redis is a fast single-threaded data structure server, commonly used as a cache, scratchpad, queue, or coordination mechanism between distributed applications. It offers operations over a broad array of datatypes , including binary blobs, lists, sets, sorted sets, maps, geohashes, counters, channels, streams, and…
2015
Vector tiles in QGIS 3.14
The new QGIS 3.14 version adds support for the native loading of vector tiles. The easiest way to load them is via the recently released plugin.
2016
Linear Regression
From zero to linear regression
2017
2018
Nested Transactions in CockroachDB 20.1
What do nested transactions look like in an ACID environment? We explore the journey of a nested SQL transaction in CockroachDB in this post.
2019
2020
2021
Recently minted database technologies that I find intriguing
I’m a huge fan of databases, so much so that I’ve written a book on so-called “NoSQL” databases, I spent some of my most fruitful years in tech working on the highly influential distributed database Riak , and I even built a database called Purple last year just for fun.
2022
SQLite as an Application File Format (2014)
An SQLite database file with a defined schema often makes an excellent application file format. Here are a dozen reasons why this is so:
2023
Jepsen: PostgreSQL 12.3
PostgreSQL is a major open-source relational database with a 23-year history and a broad range of features. While Jepsen’s work has traditionally focused on distributed systems, our tooling is readily applicable to traditional, single-node databases. In this report, we present the results of applying Jepsen’s…
2024
2025
2026
2027
Researcher questions years of his own work with a reexamination of fMRI data
Hundreds of published studies over the last decade have claimed it's possible to predict an individual’s patterns of thoughts and feelings by scanning their brain in an MRI machine as they perform some mental tasks.
2028
Clang-11.0.0 Miscompiled SQLite
It appears that the clang-11.0.0 compiler mis-compiles sqlite3.c version 3.32.1. I have checked in a change to SQLite that appears to work around the problem. But there might be other bugs. Therefore, use clang-11.0.0 with caution and test your applications carefully!
2029
Running Awk in parallel to process 256M records
TL;DR Awk crunches massive data; a High Performance Computing (HPC) script calls hundreds of Awk concurrently. Fast and scalable in-memory solution on a fat machine.
2030
Oracle vs. PostgreSQL – A Comment
I know, this list is not for this, but I just couldn't resist. Please forgive me.
2031
2032
Introduction to Apache Airflow
Airflow is a platform to programmatically author, schedule, and monitor workflows. In this blog we will underestand the basics of airflow
2033
Sizing Up Twitter Users
Twitter users are younger, more likely to identify as Democrats, more highly educated and have higher incomes than U.S. adults overall.
2034
How to build your own feature store for ML
We have many conversations with companies and organizations who are deciding between building their own feature store and buying one....
2035
2036
Scaling SQLite to 4M QPS on a Single Server (EC2 vs. Bare Metal)
Discover how Expensify achieved remarkable scaling: 4M QPS on one server! Dive into optimizing SQLite for impressive performance gains.
2037
Jepsen: MongoDB 4.2.6
2020-05-26: MongoDB identified a bug in the transaction retry mechanism which they believe was responsible for the anomalies observed in this report; a patch is scheduled for 4.2.8.
2038
Immutable Databases
Like blockchain but without blockchain.
2039
SQLite 3.32
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
2040
Multi-node TimescaleDB is now free
Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.