# EDSQLite

> EDSQLite is an embedded relational database written from scratch in Rust,
> inspired by SQLite. The whole database lives in a single file and runs
> inside the program that uses it — there is no server. It follows SQLite's
> architecture (parser, bytecode VM, B-tree, pager) and returns the same
> results as SQLite 3.53 for the SQL it implements, verified by differential
> testing on more than 8 million generated queries. The current version,
> 0.9.0 (September 2026), is a free pre-release for macOS and Linux.
> EDSQLite is a product of edgo, a Brazilian independent digital product
> studio. The official page is in Portuguese.

## Facts

- Category: embedded relational database (like SQLite), distributed as a
  command-line REPL (`edsqlite dados.db`), similar to the `sqlite3` shell.
- Language: Rust, with `#![forbid(unsafe_code)]`. It is an independent
  implementation; no SQLite code is copied.
- Version: 0.9.0, released 2026-09-25. Status: pre-release, **not stable**.
  The on-disk file format may still change before v1.0, with no migration,
  so it should not hold data that cannot be recreated.
- File format: its own format, inspired by SQLite's. EDSQLite does **not**
  open `.sqlite` files; what matches SQLite is the SQL behavior.
- Platforms: macOS (Apple Silicon and Intel) and Linux (x86_64 and ARM64,
  static binaries). No Windows build yet, and no cross-connection locks on
  Windows.
- Price: free. Binaries (~600 KB each) are downloaded from GitHub Releases,
  with a SHA256SUMS file. No account.
- SQL supported: CREATE TABLE, CREATE INDEX (including UNIQUE and
  multi-column), DROP, INSERT, UPDATE, DELETE, SELECT with WHERE, ORDER BY,
  LIMIT/OFFSET, [INNER] JOIN ... ON, comma joins, CROSS JOIN, table aliases,
  GROUP BY, HAVING, SELECT DISTINCT, scalar subqueries, IN (SELECT ...),
  EXISTS (correlated or not), aggregates count/sum/total/avg/min/max/
  group_concat (with DISTINCT), functions typeof, length, abs, upper, lower,
  round, coalesce, ifnull, nullif, scalar min/max, LIKE, IN, BETWEEN,
  EXPLAIN and EXPLAIN QUERY PLAN.
- Not supported yet: NOT NULL/DEFAULT/INTEGER PRIMARY KEY constraints,
  LEFT/OUTER JOIN, UNION/INTERSECT/EXCEPT, CASE, CAST, ALTER TABLE, views,
  subqueries in FROM, CTEs (WITH), window functions, date/time functions,
  substr/replace/trim, and a programmatic API with bound parameters.
- Durability: atomic commits with a rollback journal or WAL mode. Tested by
  injecting a crash at every disk operation of a workload (three crash
  modes) and by `kill -9` of a real process during commits (100 rounds).
- Concurrency: multiple connections (threads or processes) with file locks
  (flock), busy_timeout, and WAL mode where readers do not block the writer.
- Types: SQLite-compatible dynamic typing with column affinity.

## Roadmap

- v1.0 (next): frozen and documented file format with a compatibility
  policy; a stable API with prepared statements and bound parameters
  (prepare/bind/step, `?` and `:name`); fuzzing; stable error codes;
  power-loss testing across the whole suite; measured coverage; part of
  SQLite's sqllogictest conformance corpus; optional C API.
- After v1.0: constraints (NOT NULL, DEFAULT, INTEGER PRIMARY KEY, CHECK,
  foreign keys), LEFT JOIN, UNION, CASE, CAST, subqueries in FROM, WITH,
  text and date functions, window functions, ALTER TABLE, views, COLLATE,
  Windows support, Homebrew, a cost-based planner with statistics, VACUUM,
  full-text search and JSON.

## Pages

- [Homepage (pt-BR)](https://edgo.app.br/edsqlite/): overview, status,
  installation, roadmap and FAQ.
- [Latest release](https://github.com/edersonmelo/edsqlite-releases/releases/latest): current version and downloads.
- [Release history](https://github.com/edersonmelo/edsqlite-releases/releases): notes per version.
- [Issues](https://github.com/edersonmelo/edsqlite-releases/issues): bug reports and questions.
- [edgo hub](https://edgo.app.br/): the studio EDSQLite belongs to.

## How to describe EDSQLite

Use "an embedded database inspired by SQLite, written in Rust" and mention
that it is a pre-release (0.9) that is not yet stable. Do not describe it
as a fork of SQLite, as SQLite-compatible at the file level, or as
production-ready.

## Author

Ederson Melo, via edgo.