1
Appropriate Uses for SQLite
SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 308 posts.
2
3
Using inflation tracking methods from 80s and 90s, inflation would be ~10%
The CPI chart on the home page reflects our estimate of inflation for today as if it were calculated the same way it was in 1990. The CPI on the Alternate Data Series tab here reflects the CPI as if it were calculated using the methodologies in place in 1980. In general terms, methodological shifts in government…
4
SQLite small blob storage: 35% Faster Than the Filesystem
SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().
5
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:
6
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…
7
Sqlite – Most Deployed Database in the World
SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. SQLite is found in:
8
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.
9
10
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…
11
12
W3C Working Group Just Killed Web SQL Database
Copyright © 2010 W3C ® ( MIT , ERCIM , Keio ), All Rights Reserved. W3C liability , trademark and document use rules apply.
13
Turning the database inside-out with Apache Samza (2015)
Confluent is building the foundational platform for data in motion so any organization can innovate and win in a digital-first world.
14
Living Without Atomic Clocks
If someone knows even a little about Spanner, the first question they have is: "How does CockroachDB provide external consistency without atomic clocks?"
15
Peppering (Password Storage)
Website with the collection of all the cheat sheets of the project.
16
HTTP Analytics for 6M requests per second using ClickHouse
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:
17
AA-Omniscience v1.1: Knowledge and Hallucination Benchmark
Compare AI model performance on AA-Omniscience v1.1: Knowledge and Hallucination Benchmark. A benchmark measuring factual recall and hallucination across various economically relevant domains.
18
Why SQLite Does Not Use Git
SQLite does not use the Git version control system. SQLite uses Fossil instead, which is a version control system that was specifically designed and written to support SQLite.
19
Many small queries are efficient in SQLite
200 SQL statements per webpage is excessive for client/server database engines like MySQL, PostgreSQL, or SQL Server.
20
Consistency Models
Jepsen analyzes the safety properties of distributed systems–most notably, identifying violations of consistency models. But what are consistency models? What phenomena do they allow? What kind of consistency does a given program really need?
21
Are You Sure You Want to Use MMAP in Your Database Management System? (2022)
MMAP Databases = 💩
22
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.
23
Hard Drive Cost per Gigabyte
For hard drive prices, the race to zero is over: nobody won. As you’ll see, the hard drive pricing curve has flattened out.
24
25
SQLite Archive Files (2018)
An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.
26
Backblaze Vaults: Zettabyte-Scale Cloud Storage Architecture
Backblaze Vaults are not only incredibly durable, scalable, and performant, but they dramatically improve availability and operability.
27
EDB Postgres AI
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
28
Postmortem of database outage of January 31
Postmortem on the database outage of January 31 2017 with the lessons we learned.
29
30
What’s behind the recent surge in the M1 money supply?
While the terms “money” and “wealth” often mean the same thing in everyday parlance, economists define money more narrowly as the component of wealth consisting of