The Inner Workings of SQLite
D. Richard Hipp, Founder, Hipp, Wyrick & Company, Inc.
Date: Monday, August 1st, 2005
Time: 1:30pm - 5:00pm
This session provides a guided tour through the source code and internal workings of the SQLite embedded database engine. The aim is to make attendees comfortable enough with the SQLite code base that they will know immediately where in the code to look for answer to questions about how the database operates and can confidently make any desired customizations and enhancements.
The material is intended for:
- Programmers at companies that use SQLite in their products and that want to support SQLite internally rather than relying on external support contracts or free support from the open-source community.
- System architects who are considering the use of SQLite and who want a detailed under-the-hood look at SQLite to help them make an informed decision about whether SQLite is appropriate for their designs.
- System programmers who want to be able to use SQLite more effectively by understanding what it does behind the scenes.
- Developers of other database engines looking for ideas to help improve their own products.
- Anyone who is just curious about how SQL databases engines work.
Some of the topics that will be covered are:
- The six major subsystems within SQLite, what each does, and how they interact
- The SQLite database file format
- How SQLite insures that transactions are atomic, consistent, isolated, and durable
- The operation of the Virtual Machine inside of SQLite
- How SQL statements are translated into programs for the Virtual Machine
- The assumptions and design principles behind SQLite's query optimizer
- Guidelines for extending, enhancing, modifying and troubleshooting SQLite
- Strategies for porting SQLite to new platforms and operating systems
- The purpose and role of each of the 60 primary source files in SQLite
- Techniques for doing custom builds of SQLite
OSCON 2005 Sponsor Opportunities — Email us at
Download the OSCON 05 Sponsor/Exhibitor Prospectus
OSCON 2005 Media Sponsor Opportunities — Call Margi Levin at 707-827-7184 or email at
Press and Media
For media-related inquiries, contact Suzanne Axtell at
Want to receive conference news? Sign up for our email newsletter.