Richard Hipp

On today's show, I'm talking to Richard Hipp about surviving becoming core infrastructure for the world. SQLite is everywhere. It's in your web browser, it's in your phone, it's probably in your car, and it's definitely in commercial planes. It's where your iMessages and WhatsApp messages are stored, and if you do a find on your computer for *.db, you'll be amazed at how many SQLite databases you find. Today, Richard is going to share his story. It's the story of creating a small open source project and having it grow beyond your wildest ambitions. It's the story of following that success wherever it leads: From relationships with tech-giants to interesting testing procedures and more. Episode Page Subscribe To Podcast Newsletter  

Richard Hipp, the creator of SQLite, discusses the history and success of the database, its development funding, and why it is the most widely deployed engine in the world.

Richard Hipp, the creator of SQLite, shares his remarkable journey and insights in this engaging conversation. He discusses the history of SQLite, its widespread adoption, and the surprising ways it serves industries like aviation and finance. Hipp humorously reflects on its unique marketing and the misconceptions surrounding its use, especially in production. Financial stability and sustainable funding models for SQLite development are also highlighted, showcasing the balance between open-source principles and practical business needs.

Richard Hipp and his team rewrite SQLite's text-based JSON functions, Morris Brodersen builds a complex app in vanilla JS, and Kristoffer Dalby creates Headscale, a self-hosted implementation of Tailscale control server. Open source LLMs are proving to be on par with ChatGPT in certain tasks.

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.