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 on October 17th, 2014
In a hurry? Add it to your Download Basket!
- The primary reason for this bug-fix release is to address a problem with updating the value of fields at the end of a table that were added using ALTER TABLE ADD COLUMN. This problem 1 first appeared in the 3.8.7 release.
- Another minor annoyance in the 3.8.7 release was the fact that the Android build tried to use the strchrnul() function from the standard C library but that function is not available on Android. Android builds had to add -DHAVE_STRCHRNUL=0 to work around the problem. This patch fixes that so that Android builds should now work without any changes.
- The operation of PRAGMA journal_mode=TRUNCATE has been enhanced so that it invokes fsync() after truncating the journal file when PRAGMA synchronous=FULL. This helps to preserve transaction durability in the case of a power loss occurring shortly after commit.
- Finally, a couple of long-standing and obscure problems associated with run UPDATE and DELETE on VIEWs were fixed.
Application descriptionSQLite is an open source library software that has been designed to help you implement a serverless, zero-configuratio...