In One Minute : SQLite

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

SQLite is a relational database management system contained in a small (~350 KB) C programming library. In contrast to other database management systems, SQLite is not a separate process that is accessed from the client application, but an integral part of it.

SQLite is ACID-compliant and implements most of the SQL standard, using a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.

Mobile Apps

SQlite is commonly used to store data on Android, iOS, and Windows Phone apps since it has a simple implementation, easy to adapt, and quite fast.

Design

Unlike client-server database management systems, the SQLite engine has no standalone processes with which the application program communicates. Instead, the SQLite library is linked in and thus becomes an integral part of the application program.

The application program uses SQLite's functionality through simple function calls, which reduce latency in database access: function calls within a single process are more efficient than inter-process communication. SQLite stores the entire database as a single cross-platform file on a host machine.

References

• SQLite Homepage
• SQLite Wikipedia Article
• Official SQLite FAQ
• SQLite Documentation
• SQLite In 5 Minutes Or Less
• SQLite4 Documentation
• SQLite4 LSM User Manual
• SQLite4 LSM API Reference
• The advantages of an LSM vs a B-Tree

Books

• Getting Started with SQL: A Hands-On Approach for Beginners
• The Definitive Guide to SQLite 2nd Edition
• Using SQLite
• Introducing SQLite for Mobile Developers
• Learning SQLite for iOS
• Android SQLite Essentials