Towards Inserting One Billion Rows In SQLite Under A Minute
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
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
tl;dr: Multiple attempts to upgrade SQLite leads lead Julia to be "reminded of how executables and shared libraries work".
featured in #159