/SQLite

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