AsaDB — Local-first Prolog SQL Engine

Skip to content

Menu

Kocoy Group open-source project

A local SQL engine built with logic

AsaDB combines a SWI-Prolog SQL engine, durable local storage, and a localhost browser workspace.

Current release: AsaDB v1.4.0 Stable. It adds backend-produced, integrity-verified .asb backups and transaction-guarded restore. The validated Linux source package targets x86_64 and requires a compatible SWI-Prolog runtime installed on the host.

Read the quick start<br>View GitHub releases<br>Browse source code

Supported SQL<br>DDL, DML, metadata, transactions, joins, views, aggregates, and a practical compatibility surface.

Persistent storage<br>4 KB slotted pages, typed heap records, a bounded buffer pool, and persistent B+Tree indexes.

Reservoir bridge<br>Bounded durable admission for large SQL payloads and write work, without making the browser carry the queue.

Local operations<br>AsAPanel, runtime checks, source mirroring, and opt-in Process Guardian supervision.

AsAPanel screenshots

AsaDB in action

A local workspace for importing data, running SQL, inspecting results, and checking engine state.

Import locally Use a local file or a server-side sample.<br>Run and inspect SQL Query and review paged results in one panel.

Official source: Find code, issues, release artifacts, checksums, and governance at github.com/kocoygroup-id/AsaDB.

Community comments

Questions and feedback are welcome