An Introduction to SQLite

Google TechTalks
May 31, 2006

Richard Hipp

ABSTRACT
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. SQLite implements a large subset of SQL-92 and stores a complete database in a single disk file. The library footprint is less than 250 KB making is suitable for use in embedded devices and applications where memory space is scarce.

This talk provides a quick overview of SQLite, its history, its strengths and weaknesses, and describes situations where it is much more useful than a traditional client/server database. The talk concludes with a discussion of the lessons learned from the development of SQLite and how those lessons...

• Category

  Howto & Style

[Donald Griggs]

Since this presentation was given, Dr. Hipp and his contributors have added full support for foreign keys, incremental blob reads, full text search (fts), etc.

[ITWorksSoftware]

Good information, too bad the resolution is so,low we can't read the screen.

[VV0lfdalE]

Huh, google-google, 240p,...