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

Tags:

• google
• howto
• introduction
• sqlite

[coliban]

Nice lesson, thank you!

(But quality of this video could be better)

Regards

[gmvsea]

Thank Richard! I really enjoyed this. It is everything I wanted to know about SQLite but was afraid to ask. I didn't realize the integration from TCL to SQLite was so elegant.

[meerminman]

So 240p, we meet again!

[IcarusFlying]

charge the people who are getting support a ton of money and then use that money to create support for everyone.

[abrinin]

Thank you sir, you did it

[x3ICEx]

SQLite is awesome! And it is still only around 200 kb.

[Milind00New]

Nice presentation! thanks

SQLite does really provide great option while design applications

[grThetrojan01gr]

(I'm not a prof. programmer) I'm making a hotel reservations managment application... in the beginning I was thinking of making an XML file and store everything in it, then I should write my parser shit etc, thank god SQLite exists :-D