Features at a glance
Key features include support for isolated, atomic,durable and consistent transactions, SQL92 implementation, database files can be freely shared between computers, supports databases up to 2 terabytes, support for gigabyte-sized blobs and strings, small code footprint, as well as an easy-to-use and very simple API (Application Programming Interface).
Additionally, SQLite does not require initial configuration or further administration, allows developers to store a complete database in a single, cross-platform disk file, which is perfect for using application file formats, has no external dependencies, comes with built-in TCL (Tool Command Language) bindings, and comprehensive documentation.
Bindings for numerous other programming languages are available separately. Its source code is well-commented and it comes with a standalone CLI (Command-line Interface) client that has been designed from the offset to be used for the administration of SQLite databases.
What can I use it for?
The SQLite database engine can be used for any purpose, personal or commercial. Suggested uses for SQLite include database for gadgets, website database, stand-in for an enterprise RDBMS (Relational Database Management System), as well as application file format.
Under the hood and supported OSes
The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library. It is written entirely in the ANSI-C programming language.
Supported desktop operating systems include GNU/Linux, Mac OS X and Microsoft Windows. Supported mobile operating systems include Android and iOS. It has been successfully tested with both 32-bit and 64-bit hardware platforms, and it’s easily portable to other OSes.
Reviewed by Marius Nestor, last updated on December 9th, 2014
In a hurry? Add it to your Download Basket!
- This release fixes adds in a mutex that is required by the changes of the 18.104.22.168 patch but was accidently omitted. The mutex was not required by any of the internal SQLite tests, but Firefox crashes without it. Test cases have been added to ensure that mutex is never again missed.
Application descriptionSQLite is an open source library software that has been designed to help you implement a serverless, zero-configuratio...