The Changelog: Software Development, Open Source Richard Hipp returns (Interview)
Aug 19, 2021
Richard Hipp, the mastermind behind SQLite, Althttpd, and Fossil SCM, shares his insights on the latest SQLite advancements and the importance of balancing innovation with stability. He discusses the challenges of maintaining a minimal library size while introducing new features and reflects on creating Althttpd as a simplified web server. The conversation highlights Fossil's unique advantages in version control, including its intuitive web interface, and emphasizes choosing the right tools for effective software development.
AI Snips
Chapters
Transcript
Episode notes
SQLite's Pervasiveness and Code Churn
- SQLite is used on Mars and in almost every electronic device, including cars and phones.
- OpenBSD dropped SQLite due to its high rate of code churn, exceeding their auditing capacity.
SQLite Business Model
- Richard Hipp's business model prioritizes support contracts, incentivizing robust software to minimize support needs.
- Some SQLite test code is proprietary, providing a competitive advantage and stemming from an earlier plan to sell SQLite.
SQLite Use Cases
- SQLite, initially designed for edge devices, now powers entire organizations like Bloomberg (using a customized version) and Expensify.
- Expensify uses Bedrock, a wrapper around SQLite, achieving impressive transaction speeds.