SQLite is an open source, multiplatform, free and small C library that implements a self-contained, embeddable, transactional, serverless and zero-configuration SQL database engine. It is the world’s most used SQL database engine.

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.

What’s new in SQLite 3.28.0:

  • This release fixes an obscure security issue. Applications using older versions of SQLite may be vulnerable if
  • SQLite is compiled with certain optional extensions enabled, and
  • the attacker is able to inject arbitrary SQL.

Read the full changelog

Filed under

SQL engine Embeddable SQL engine SQL database SQLite Engine SQL Embeddable