libSQL is a fork of SQLite that extends the embedded relational database engine with additional functionality for distributed applications and remote database access.
Developed by Turso, libSQL retains compatibility with SQLite while introducing capabilities such as embedded replicas and a server component. Applications can continue using an embedded database model or connect to a remotely hosted database using libSQL interfaces.
The project retains SQLite’s familiar database format and much of its existing application programming interface. It also provides extensions to database functionality, including additional schema modification operations and facilities for custom database behaviour.
libSQL should be distinguished from the separate Turso database engine, which is a new implementation rather than a fork of SQLite.
This is free and open source software.
Key Features
- SQLite-compatible relational database engine with additional database functionality.
- Embedded operation allows applications to access databases without running a separate server process.
- Embedded replicas provide locally accessible copies of remotely maintained databases.
- libSQL server enables remote SQL database access over a network.
- SQLite file format compatibility allows existing database files to be used with libSQL.
- SQLite C API compatibility helps existing applications adopt the database engine.
- Extended ALTER TABLE functionality supports additional column and constraint modifications.
- Randomised ROWID support provides an alternative to conventional sequential row identifiers.
- WebAssembly user-defined functions allow custom database operations.
- Virtual write-ahead log interfaces provide additional control over database logging behaviour.
- Client interfaces support integration with applications using Rust, JavaScript, Go and other languages.
Website: github.com/tursodatabase/libsql
Support:
Developer: Turso
License: MIT License
libSQL 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.