libsql
libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
What is libsql?
libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
Overview of libsql
What it is
libSQL is an open source fork of SQLite, created and maintained by Turso. It extends SQLite with additional features while maintaining compatibility with the SQLite file format and API. The project aims to be a community-driven alternative to SQLite, accepting external contributions and adhering to a code of conduct.
Key features
- Embedded replicas that allow replicated databases inside your application
- libSQL server for remote SQLite access, similar to PostgreSQL or MySQL
- Supports Rust, JavaScript, Python, Go, and more
ALTER TABLEextension for modifying column types and constraints- Randomized ROWID
- WebAssembly User Defined Functions
Use cases
- Applications that require SQLite compatibility but need embedded replication or remote access
- Projects that need to modify column types or constraints using
ALTER TABLE - Scenarios where WebAssembly user-defined functions are beneficial
- Use cases that benefit from a community-driven, open contribution database fork
Getting started
To build the SQLite-compatible C library and tools, run:
cargo xtask build
To run the SQL shell, launch the libsql program:
$ cd libsql-sqlite3 && ./libsql
libSQL version 0.2.1 (based on SQLite version 3.43.0) 2023-05-23 11:47:56
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
libsql>
License and pricing
libSQL is licensed under the MIT open source license. It is free to use.
Based on the project's public README and repository metadata.