# sqlite

> sqlite, a magmalake tin: An embedded SQL database: connections, prepared statements, typed columns and RAII transactions over libsqlite3. A fork of ehsanmok/sqlite, made dependency-free so it installs from the registry with no external git repos.

[magmalake](https://magmalake.dev/) [sqlite](https://magmalake.dev/s/sqlite)

An embedded SQL database: connections, prepared statements, typed columns and RAII transactions over libsqlite3\. A fork of ehsanmok/sqlite, made dependency-free so it installs from the registry with no external git repos.

Install

```
pixi shelf add sqlite-mojo
```

Version

`0.3.5` on mojoshelf

Source

[GitHub](https://github.com/magmalake/sqlite.mojo) [README](https://github.com/magmalake/sqlite.mojo#readme)

## Works today

- INTEGER, REAL and TEXT columns, with NULL distinct from empty; BLOB columns aren't exposed
- Prepared statements with positional parameters, explicit transactions
- libsqlite3 opened once per process, not per connection
- Backs the SQL catalog iceberg.mojo uses for PyIceberg parity

Checked against round-tripped against the sqlite3 shell in both directions

- [objectstore](https://magmalake.dev/s/objectstore) local · HTTP · S3 · GCS · Azure · concurrent reads
- [postgres](https://magmalake.dev/s/postgres) libpq · params · COPY
- [Every tin](https://magmalake.dev/tins)

[A magmalake project](https://magmalake.dev/)

Apache 2.0 · © 2026 Marius Seritan