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

Tutorial

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
SpikeSource
Sun Microsystems

Platinum Sponsors

Novell, Inc.

Gold Sponsors

ActiveState
IBM
Ticketmaster

Silver Sponsors

ActiveGrid
Alfresco
Black Duck Software
CollabNet
Covalent Technologies
Google
GroundWork Open Source Solutions
Intel Corporation
Mergere, Inc.
Microsoft
Oracle
Palamida
SourceLabs
SugarCRM
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
LinuxQuestions.org
Open Enterprise Trends
Queue
SDForum
Software Association of Oregon
Version Tracker
Wi-Fi Technology Forum
Women's Technology Cluster
WorldWIT

In-Kind Sponsors

Dell Inc.
Gibson
Griffin Technology
Harman Multimedia
Smugmug

Sponsors

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.