By Sibsankar Haldar
April 2007
Pages: 76
Series: Short Cut
Format: PDF
ISBN 10: 0-596-55006-5 |
ISBN 13: 9780596550066
(Average of 1 Customer Reviews)
SQLite is a small, zero-configuration, custom-tailored, embeddable, threadsafe, easily maintainable, transactionoriented, SQL-based, relational database management system. There is no separate install or setup procedure to initialize SQLite before using it. There is no configuration file.
SQLite is open source, and is available in the public domain (for more information on open source, visit http:// opensource.org). You can download SQLite source code from its homepage http://www.sqlite.org, compile it using your favorite C compiler, and start using the compiled library. SQLite runs on Linux, Windows, Mac OS X, and a few other operating systems. It has been widely used in low-to-medium tier database applications.
This Short Cut discusses design principles, engineering trade-offs, implementation issues, and operations of SQLite. It presents a comprehensive description of all important components of the SQLite engine.
Browse within this PDFFeatured customer reviews
An interesting voyage to a sea of SQLite, May 01 2008
I was searching the books about sqlite before, because I am too eager to know the inside of a database architecture and how to develop such one. I feel this book which integrates the theory and practice are the best one to read, pure theory makes me get lost, practical demo with related theory makes me feel good and enable me walk longer. This book is one of the pearls and gives me the effective and efficient way to learn deeper of a db internals.
With basic knowledge of relational db theory, then you could start to read this book. It's better read through the entire book because every chapter are closely cooperative with each other, although they are independent chapters.
This book introduces the major parts of a db which should involve and every chapter explains one important concept. This book actually has the same essence as SQLite itself, it's a compact book, but powerful.
One comment of the chapter 5(Table and Index Management), in order to get some clear concepts of B+ Tree application, I'd like to mention that there are 2 other books to read about the B+ structure. One is chapter 9(SQLite Internals) in the book "The Definitive Guide to SQLite" (Auther: Michael Owens), the other is chapte 3(Index Turnin) in the book "Database Tuning, Principals, Expriments, and Troubleshooting Techniques"(Author: Dennis Shasha, Philippe Bonnet).
It seems that there are many books about Postgresql, but books about SQLite are not as many as Postgresql. So far I found 2 books attract me, one is this book, the other is "The Definitive Guide to SQLite"
Here just my ideas to learn SQlite internal.
Read this book firstly, it's concise and gives you a bird-view of SQlite architecture, then read
"The Definitive Guide to SQLite", it's a little bigger book, finally read the source codes of SQLite, the comments in the codes are really an art work.
