SQLite with D. Richard Hipp

drh

“Everybody that sees SQL thinks its ugly and dirty and they want to try and rewrite it to be better. There’s a bazillion attempts to do this – I’ve tried it several times myself. But somehow, everybody always comes back to SQL.”

SQLite is an SQL database engine that can be used in applications as a library for quick read-write operations. Unlike other database management systems, SQLite is not a client-server database designed to run in a data center.

D. Richard Hipp is the architect and primary author of SQLite and the Fossil SCM.

Questions

  • What is SQLite?
  • What inspired you to create SQLite?
  • What are the typical configuration issues associated with databases?
  • How does an application access an SQLite database?
  • When you created SQLite did you have any experience writing databases?
  • What is SQLite missing from the SQL Standard?
  • What is the bottleneck that applications trying to scale will hit when they’re using SQLite?

Links

Sponsors

Hired.com is the job marketplace for software engineers. Go to hired.com/softwareengineeringdaily to get a $600 bonus upon landing a job through Hired.

Digital Ocean is the simplest cloud hosting provider. Use promo code SEDAILY for $10 in free credit.

Software Daily

Software Daily

 
Subscribe to Software Daily, a curated newsletter featuring the best and newest from the software engineering community.