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 TABLE extension 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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/tursodatabaselibsql.svg)](https://yunodb.com/tools/tursodatabaselibsql?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/tursodatabaselibsql?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/tursodatabaselibsql.svg" alt="Featured on YunoDB" height="20"></a>