/Avinash Sajjanshetty

Collection Of Insane And Fun Facts About SQLite tl;dr: (1) SQLite is the most deployed and most used database. There are over one trillion SQLite databases in active use. It is maintained by three people. They don’t allow outside contributions. (2) SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. It’s everywhere. (3) It is also probably one of the top five most deployed software modules.

featured in #579


I Ended Up Adding Duplicate Records On A Unique Index In MongoDB tl;dr: "The intention of this post is not to shit on MongoDB. They specifically forbid the steps I am about to explain. This post is a chronicle of my curiosity, exploration, and fun learning experience."

featured in #320


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