sqlite.zigSQLite Engine in Pure Zig

A fully native, zero-dependency SQLite-compatible database engine written entirely in Zig

🗄

Real On-Disk Format

Full implementation of the SQLite .db/.sqlite file format including 100-byte header, B-tree pages, record encoding, varints, and freelist pages.

📝

SQL Parser & VM

Hand-written SQL lexer, parser, and bytecode compiler/VM modeled on SQLite's own architecture. Supports CREATE, INSERT, SELECT, UPDATE, DELETE, JOINs, and more.

⚡

Typed DSL Query Builder

A comptime, type-safe Zig query builder that generates SQL under the hood, ensuring compile-time validation of table names, column names, and types.

🔄

WAL & Rollback Journal

Both Write-Ahead Logging (WAL) and traditional rollback-journal durability modes for concurrent read/write access.

🔗

Foreign Keys & Constraints

CASCADE DELETE/UPDATE, SET NULL, SET DEFAULT, composite foreign keys, composite PRIMARY KEY, and composite UNIQUE constraints.

🧩

Views, Triggers & CTEs

CREATE VIEW, CREATE TRIGGER, Common Table Expressions including recursive CTEs for hierarchical data traversal.

Quick Example

zig

const sqlite = @import("sqlite");

const User = sqlite.table("users", struct { id: i64, name: []const u8 });

pub fn main() !void {
    var db = try sqlite.open(std.heap.page_allocator, "my.db");
    defer db.close();

    try db.createTable(User, .{ .if_not_exists = true });

    var inserted = try db.from(User).insert(.{ .id = 1, .name = "Alice" });
    inserted.deinit();

    var result = try db.from(User).fetchAll();
    defer result.deinit();
}

NOTE

This project is in early, active development. Expect breaking changes between commits.