1
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:
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 30 posts.
2
How to Corrupt a SQLite Database File
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully…
3
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.
4
Peppering (Password Storage)
Website with the collection of all the cheat sheets of the project.
5
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.
6
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.
7
Amazon S3 Update – Strong Read-After-Write Consistency
When we launched S3 back in 2006, I discussed its virtually unlimited capacity (“…easily store any number of blocks…”), the fact that it was designed to provide 99.99% availability, and that it offered durable storage, with data transparently stored in multiple locations. Since that launch, our customers have used S3…
8
Scaling Datastores at Slack with Vitess
From the very beginning of Slack, MySQL was used as the storage engine for all our data. Slack operated MySQL servers in an active-active configuration. This is the story of how we changed our data storage architecture from the active-active clusters over to Vitess — a horizontal scaling system for MySQL. Vitess is…
9
Demonstrations and Political Violence in America: New Data for Summer 2020
The report covers 2020 trends in political violence and demonstrations in the US, focusing on the BLM movement.
10
US Federal Agricultural Farm Subsidies: How Much Farmers Get By Year
Federal farm subsidies make up an average of 13.5% of net farm income.
11
SQLite Is Serverless
Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the…
12
13
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…
14
What can 6,000 electric vehicles tell us about EV battery health?
Analysis of electric vehicle battery health of 22K+ EVs reveals a 2.3% average battery degradation rate. High-power DC fast charging is the top risk factor.
15
Pebble: A RocksDB Inspired Key-Value Store Written in Go
Today we’re introducing Pebble, a RocksDB-inspired and RocksDB compatible key-value store written in Go that brings greater stability to CockroachDB.
16
Jepsen: Etcd 3.4.3
The etcd key-value store is a distributed system intended for use as a coordination primitive. Like Zookeeper and Consul , etcd stores a small volume of infrequently-updated state ( by default, up to 8 GB ) in a key-value map, and offers strict-serializable reads, writes and micro-transactions across the entire…
17
18
SQLite 3.33
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 .
19
TimescaleDB 2.0 released, now distributed multi-node
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.
20
Common color mistakes and how to avoid them
Choosing good colors for your charts is hard. This article tries to make it easier.
21
Three bugs in the Go MySQL driver
Check out what we learned from shipping our busiest Go service in production—we found 3 bugs in the Go MySQL driver.
22
Backblaze Hard Drive Stats Q1 2020
We take a look at the Q1 2020 and lifetime performance of 129,764 hard drives used in the Backblaze data centers.
23
A Short Story About SQL’s Biggest Rival
A short story about SQL's better rival: Michael Stonebraker's storied query language, QUEL.
24
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…
25
Why CockroachDB and PostgreSQL Are Compatible
CockroachDB is PostgreSQL compatible in order to be accessible to an ecosystem of drivers, existing code, and developer knowledge.
26
Improving Postgres Connection Scalability: Snapshots
Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.
27
Analyzing the Limits of Connection Scalability in Postgres
Why it’s important to improve Postgres connection scalability, plus an analysis on the limits of connection scalability today.
28
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...
29
How Netflix uses Druid for realtime insights
By Ben Sykes
30
DBLog: A Change-Data-Capture Framework
Andreas Andreakis, Ioannis Papapanagiotou