SQLite is a the most widely deployed database in the world with very many applications which includes very many high-profile projects. It implements a self-contained, server less, zero configuration and transactional SQL database engine.
• Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
•Zero-configuration - no setup or administration needed.
•Full-featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, and common table expressions. (Omitted features)
•A complete database is stored in a single cross-platform disk file. Great for use as an application file format.
Small (<50 employees), medium (50 to 1000 enterprise (>1001 employees)
•Supports terabyte-sized databases and gigabyte-sized strings and blobs. (See limits.html.)
•Small code footprint: less than 500KiB fully configured or much less with optional features omitted.
•Simple, easy to use API.
•Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
•Well-commented source code with 100% branch test coverage.
•Available as a single ANSI-C source-code file that is easy to compile and hence is easy to add into a larger project.
•Self-contained: no external dependencies.
• Simple to install.
• It can run on any modern PC or smartphone as no additional programs are required for it to run.
• It’s portable and very simple to share databases, all that needs to be done is to just copy one file.
• It’s not owned by any company, so the code is free for all to change and use.
• It’s shared freely.
SQLite is a the most widely deployed database in the world with very many applications which includes very many high-profile projects. It implements a self-contained, server less, zero configuration and transactional SQL database engine. It’s free to use for any purpose, commercial or private. SQLite is embedded into the end program. It’s not a client-server database engine. SQLite stores its entire database as a single cross-platform file on a host machine. It’s an SQL database engine that is embedded. It doesn’t have a separate server process. It reads and writes to ordinary disk files directly. A complete SQL database with multiple tables, indices, triggers and views, is contained in a single disk file. A database between 32-bit and 64-bit systems can be freely copied as the database file format is cross platform. SQLite is a compact library. With SQLite, the more memory you give it the faster it runs. SQLite is very reliable and its very carefully tested before its released. SQLite is perfect when it comes to responding gracefully to memory allocation failures and disk I/O errors. SQLite provides bugs lists and minute-by-minute chronologies of code changes. It’s open and honest about all bugs. Its source code is available for free to anybody who wants it although professional support is also available. It’s ideal for making good products that are fast, reliable, and simple to use.