- …
Original video by Tom Delalande:
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