Lessons Learned From SQLite

Abstract:
Measured by usage and deployment, SQLite is a wildly successful product. There are more instances of SQLite running today than all other database engines combined. Many observers, including the creator of SQLite, are astonished by this. What accounts for SQLite's ubiquity and world-wide acceptance? Though it is impossible to answer precisely, reflecting on that question helps to identify core principles of database systems that make
those systems useful for solving real-world problems. An understanding of these core principles is a effective heuristic in evaluating the merits of new data management systems, and a powerful guide toward the development of
new systems that achieve success by design, rather than by serendipity.

Bio:
D. Richard Hipp took a Masters of Electrical Engineering from Georgia Tech in 1984 and immediately began working at Western Electric (a.k.a. Bell Labs) where he was introduced to Unix and C. After three years in industry, he began studies at Duke University that lead to a Ph.D. in 1992 with a dissertation in natural language understanding. Ever the non-conformist, Hipp left the academic career path to start his own business solving hard technical problems. As part of that endeavor, Hipp wrote the SQLite database engine in the 2000. SQLite soon went viral, and Hipp's company pivoted toward providing ongoing enhancements and technical support for his database. In addition to SQLite, Hipp is also the original author and primary maintainer for the Fossil distributed version control system, and the Lemon LALR(1) parser generator. Hipp is a frequent lecturer at conferences and universities around the world, but spends most of his time writing and debugging code.

Co-Sponsored by Computer Science

Hosted by Professor Eugene Wu