SQLite is a full-featured embedded SQL database engine, and the world's most widely deployed and used database engine. The design and implementation of SQLite is different from most other RDBMSes, since SQLite strives to solve a different problem. This talk describes the problem that SQLite solves and overviews the design choices and algorithms that SQLite uses in its unique role.
Richard Hipp is the creator and principal maintainer of SQLite. Richard first became involved with computers while in High School in the mid 1970s. After taking an MSEE from Georgia Tech in 1984, he began working for Western Electric/Bell Labs where he encountered and learned Unix and C. He returned to school at Duke University and took a PhD in 1992 with a dissertation in computational linguistics. Upon graduating, he founding Hipp, Wyrick & Company, Inc. (Hwaci), a consulting firm specializing in solving hard problems using bespoke software. Richard created SQLite in 2000 out of frustration in having to deal with a traditional client/server RDBMS. Richard and the staff at Hwaci have worked exclusively on enhancing and supporting SQLite since about 2006. Other open-source projects that Richard has started include the Fossil distributed version control system, and the Lemon LALR(1) parser generator.
Faculty Host: Andy Pavlo
Partially funded by Yahoo! Labs