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-wi...
Why SQLite succeeded as a database:    • Why SQLite succeeded as a database (Interv...  
^ Part 2:    • Richard Hipp returns (Interview)  
Interview:    • Richard Hipp, SQLite main author - Two Wee...  
SQLite How it Works:    • SQLite: How it works, by Richard Hipp  
Personal Website: https://www.hwaci.com/drh/

Why 100% test coverage matters: https://news.ycombinator.com/item?id=...
https://news.ycombinator.com/threads?...

https://fossil-scm.org/home/doc/tip/w...
https://fossil-scm.org/home/doc/tip/w...
https://www.sqlite.org/mostdeployed.html
https://www.sqlite.org/formatchng.html
https://www.sqlite.org/selfcontained....
https://www.sqlite.org/testing.html
https://www.sqlite.org/th3.html
https://www.sqlite.org/sqllogictest/d...
https://www.sqlite.org/testing.html#d...