magmalake sqlite

Tins · Storage & databases

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 README

What it does

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

Correctness

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

Also in Storage & databases