The Perfect Dependency - SQLite Case Study

SQLite is a side project that became the most deployed piece of software ever. Estimated to have more than 1 trillion deployments. It is a great example of how far simple software can go. Timestamps: 0:00 - The scale of SQLite 0:54 - Origin Story 3:20 - Dependencies 6:59 - Features 8:47 - Backwards Compatibility 9:49 - Simplicity 10:28 - Testing 14:35 - Current Development 15:40 - Licensing & Monetisation 17:10 - Fossil 18:03 - Tinker 18:33 - Summary Resources: https://www.sqlite.org/about.html Podcast: https://corecursive.com/066-sqlite-with-richard-hipp/# Why SQLite succeeded as a database: https://www.youtube.com/watch?v=IFhJb9Kjaio ^ Part 2: https://www.youtube.com/watch?v=KgcqPYahSQg Interview: https://www.youtube.com/watch?v=2eaQzahCeh4 SQLite How it Works: https://www.youtube.com/watch?v=ZSKLA81tBis Personal Website: https://www.hwaci.com/drh/ Why 100% test coverage matters: https://news.ycombinator.com/item?id=18685748 https://news.ycombinator.com/threads?id=SQLite https://fossil-scm.org/home/doc/tip/www/rebaseharm.md https://fossil-scm.org/home/doc/tip/www/whyallinone.md https://www.sqlite.org/mostdeployed.html https://www.sqlite.org/formatchng.html https://www.sqlite.org/selfcontained.html https://www.sqlite.org/testing.html https://www.sqlite.org/th3.html https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki https://www.sqlite.org/testing.html#dbsqlfuzz