DBDB.io The Encyclopedia of Database Systems · Est. 2017
Login
Database of Databases

Database Entry

libSQL

Forked Code

libSQL is a hard fork of SQLite.

Website
https://libsql.org[01]
Source Code
https://github.com/tursodatabase/libsql[02]
Tech Docs
https://docs.turso.tech/libsql[03]
Developer
Country of Origin
US
Start Year
2022
Project Types
Commercial, Open Source
Written in
C
Derived From
SQLite
Compatible With
SQLite
Operating System
Linux
License
MIT License
Twitter
@libsqlhq[04]

Database Entry

libSQL

Forked Code

libSQL is a hard fork of SQLite.

History

The libSQL project started in 2022 due to concerns that SQLite does not accept external contributors and does not adhere to a code of conduct.

Checkpoints

Non-Blocking Blocking

Same as SQLite

Concurrency Control

Two-Phase Locking (Deadlock Prevention) Two-Phase Locking (Deadlock Detection)

Same as SQLite

Data Model

Relational

Same as SQLite

Foreign Keys

Supported

Same as SQLite

Indexes

B+Tree

Same as SQLite

Isolation Levels

Read Uncommitted Serializable Snapshot Isolation

Same as SQLite

Joins

Nested Loop Join

Same as SQLite

Logging

Physical Logging

Same as SQLite

Query Compilation

Code Generation

Same as SQLite

Query Execution

Tuple-at-a-Time Model

Same as SQLite

Query Interface

Custom API SQL

Same as SQLite

Storage Architecture

Disk-oriented

Same as SQLite

Storage Model

N-ary Storage Model (Row/Record)

Same as SQLite

Stored Procedures

Not Supported

Same as SQLite

System Architecture

Shared-Disk Embedded

Same as SQLite

Views

Virtual Views

Same as SQLite

People Also Viewed
RexDB RexDB DQ Dqlite DuckDB DuckDB PocketBase PocketBase

Citations

4 sources
  1. Turso - Databases Everywhere libsql.org
  2. GitHub - tursodatabase/libsql: libSQL is a fork of SQLite that is both Open Source, and Open Contributions. · GitHub github.com
  3. libSQL - Turso turso.tech
  4. https://twitter.com/libsqlhq twitter.com
Revision #4 Last Updated: