SQLite Internals: Pages & B-trees

- Ben Johnson tl;dr: "Learning about the internals of our tools lets us feel comfortable with them and use them confidently. Hopefully low-level features like SQLite's PRAGMAs seem a little less opaque now." Ben guides us through SQLites internals through an "over-engineered" database that tracks sandwich he's consumed.

featured in #339

Consider SQLite

- Wesley Aptekar-Cassels tl;dr: "If you were creating a web app from scratch today, what database would you use? Probably the most frequent answer I see to this is Postgres", although common answers are MySQL, Microsoft SQL Server, MongoDB, etc..." Wesley makes a case for why you should consider SQLite. "As long as you don't expect to need tens of thousands of small writes per second, thousands of large writes, or long-lived write transactions, it's highly likely that SQLite will support your usecase. "

featured in #281

Towards Inserting One Billion Rows In SQLite Under A Minute

- Avinash Sajjanshetty tl;dr: Avinash discusses how far he's gotten in attempting to building a 4 column DB with a billion rows in under a minute using Python and Rust scripts, with the following compromises: (1) lack of durability i.e. crashing is fine. (2) Can use machine resources to the fullest. (3) Can use pseudo-random methods from stdlib.

featured in #238

Sharing SQLite Databases Across Containers Is Surprisingly Brilliant

- Rick Branson tl;dr: Backed into a corner, Rick came up with a creative solution of writing data to a local file read by dozens of containers using SQLite. Having seen success with this implementation, he believe there is room to innovate here. Bypass the paywall here by clicking the link in this tweet.

featured in #168

SQLite Is Really Easy To Compile

- Julia Evans tl;dr: Multiple attempts to upgrade SQLite leads lead Julia to be "reminded of how executables and shared libraries work".

featured in #159