SQLite is an embedded relational database engine that operates directly within an application rather than using a separate database server. Applications access databases through a library, making SQLite particularly suitable for local data storage.
A database can contain multiple tables, indexes, views and triggers in a single file. The file format is portable, allowing database files to be transferred between systems without conversion.
SQLite requires no database administrator or server configuration. Its transactional design and compact footprint make it appropriate for desktop applications, mobile software, embedded systems and application caches.
This is free and open source software.
Key Features
- Supports ACID transactions with rollback journals and write-ahead logging.
- Stores complete databases in portable, single-file containers.
- Provides SQL joins, subqueries, common table expressions and window functions.
- Includes indexes, triggers, views, foreign key constraints and generated columns.
- Supports JSON functions and operators for structured document data.
- Offers full-text search through the FTS5 extension.
- Provides R-tree indexes for spatial and range queries.
- Includes an application programming interface for prepared statements and parameter binding.
- Supports dynamic typing and optional STRICT tables.
- Provides online backup facilities and database integrity checking.
- Includes a command-line shell for SQL queries, imports and exports.
- Cross-platform support – runs on Linux, macOS, and Windows.
Website: sqlite.org
Support:
Developer: SQLite Development Team
License: Public Domain
SQLite is written in C. Learn C with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | High compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| TiDB | Cloud-native, distributed SQL database |
| DuckDB | In-process SQL OLAP database management system |
| Turso | In-process relational database engine |
| YugabyteDB | PostgreSQL-compatible distributed SQL database |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Dolt | Version-controlled SQL database |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Apache Cloudberry | Massively parallel processing database |
| Virtuoso | Data Management with Web Application Server and Web Services |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.