CHAPTER 1Introducing SQLite

SQLite is an open source embedded relational database. Originally released in 2000, it was designed to provide a convenient way for applications to manage data without the overhead that often comes with dedicated relational database management systems. SQLite has a reputation for being highly portable, easy to use, compact, efficient, and reliable.

An Embedded Database

SQLite is an embedded database. Rather than running independently as a standalone process, it symbiotically coexists inside the application it serves—within its process space. Its code is intertwined, or embedded, as a part of the program that hosts it. To an outside observer, it would never be apparent that such a program had a relational database ...

Get The Definitive Guide to SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.