Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.

The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide.

You'll learn about SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl.

The book thoroughly covers SQLite internals to help you take full advantage of its features while minimally impacting resource consumption.

Author Mike Owens is the original creator of Pysqlite, the popular Python extension for SQLite.

GrantcAllen具备20多年的IT工作经验,1做过软件开发公司的首席技术官（CTO）和Google的数据架构师.a他的工作横跨多个行业,1有政府部门和学术部门,1大型系统设计、开发、性能、创新以及破坏性改变的咨询.aGrant也是学术会议和行业会议的常客,1他经常做一些关于数据挖掘、协作技术、关系数据库以及技术业务的报告.aGrant在高新技术公司领导破坏性创新理论项目的业余时间取得了他的博士学位

MikecOwens是德克萨斯州沃斯堡一家大型房地产公司的IT主管,2他负责开发和管理公司的核心系统.a之前他在橡树岭国家实验室（该实验室是美国能源部所属的一个大型国家实验室）担任流程设计工程师,2在Nova信息系统公司当过C++程序员.a他是PySQLite的最初创建者,2PySQLite是SQLite的Python扩展.aMike毕业于田纳西大学诺克斯维尔分校,2获得化学工程学士学位

Mike喜欢慢跑、弹吉他、滑雪,3以及与同伴们一起在德克萨斯州狭长的地带上打猎.a他与妻子、两个女儿以及两只小猎狗在德克萨斯州沃斯堡生活.a