O'Reilly Open Source Convention - August 1-5, 2005 - Portland, Oregon
 Convention Coverage


The Inner Workings of SQLite
D. Richard Hipp, Founder, Hipp, Wyrick & Company, Inc.

Track: Databases
Date: Monday, August 1st, 2005
Time: 1:30pm - 5:00pm
Location: E143-144

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

Diamond Sponsors

Computer Associates International Inc., (CA)
Hewlett Packard
Sun Microsystems

Platinum Sponsors

Novell, Inc.

Gold Sponsors


Silver Sponsors

Black Duck Software
Covalent Technologies
GroundWork Open Source Solutions
Intel Corporation
Mergere, Inc.
Yahoo! Inc.
Zend Technologies, Inc.

Media Sponsors

boing boing
C/C++ Users Journal
DevtownStation News
Digital ID World
Enterprise Open Source Journal
Free Software Magazine
InsideMac Radio
Integration Developer News
Linux Journal
Open Enterprise Trends
Software Association of Oregon
Version Tracker
Wi-Fi Technology Forum
Women's Technology Cluster

In-Kind Sponsors

Dell Inc.
Griffin Technology
Harman Multimedia


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

Conference News

Want to receive conference news? Sign up for our email newsletter.

O'Reilly Home | Privacy Policy

© 2005, O'Reilly Media, Inc.