SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is an embedded SQL database engine, it does not have a separate server process. It reads and writes directly to ordinary disk files. The disk file contains the database with tables, indices, triggers, and views.
- Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
- The code for SQLite is in the public domain, so that anyone can use it as free for either commercial or private purpose.
- The dbase file format is cross-platform, so you can freely copy a database between operating systems and 32-bit and 64-bit systems.
- No setup or administration needed.
- Simple and easy to use API.
- SQLite is written in ANSI-C.
- It's an excellent choice for gadgets like cellphones, PDAs, MP3 Players, set-top boxes, etc.
- SQLite is often used as a surrogate for an enterprise RDBMS for demonstration purposes or for testing.
