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 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.
Learning from DuckDB
- Richard Hipp finds inspiration from other projects like DuckDB, a column store database, considering similar options for SQLite.
- He prioritizes backwards compatibility and a manageable library size for SQLite.
Creation of alt-httpd
- Richard Hipp created alt-httpd, a simple web server in C, due to concerns about the complexity and security of Apache.
- Designed for small websites, alt-httpd prioritizes simplicity and security over scalability.