Capabilities
Features
The main building blocks available in AsaDB, including the v1.4.0 Stable production-backup path.
Supported SQL Surface
AsaDB supports a practical local SQL surface for databases, tables, indexes, rows, metadata, joins, views, aggregates, basic transactions, and basic users/grants. In v1.4.0, compatibility fallback consults the MySQL 5.5 manifest so known unavailable statements receive a clear compatibility status instead of being indistinguishable from unknown SQL.
- CREATE / DROP / USE
- INSERT / SELECT / UPDATE / DELETE
- WHERE, LIKE, BETWEEN, IN, NULL
- ORDER BY and LIMIT
- GROUP BY and aggregates
- INNER / LEFT / RIGHT JOIN
- UNION, CASE WHEN, CONCAT
- Views and subqueries
- BEGIN, COMMIT, ROLLBACK
Local Persistent Storage
User rows live in 4 KB slotted heap pages. v1.4.0 regression coverage includes backup, paging, bounded result windows, restart persistence, and a 100,000-row storage scenario. Keep every .asa catalog together with its matching .asa.store directory when moving or manually preserving a database.
JOIN Planner
Simple qualified equality joins can use an AVL-backed lookup path. INNER, LEFT, and RIGHT joins share this optimized route when the predicate fits; complex predicates retain a compatible nested-loop path.
Reservoir Bridge
Reservoir provides bounded durable admission for write commands and large SQL payloads. It chunks, spools, fingerprints, queues, tracks, and passes work to the established executor.
v1.4.0 Production Backup & Restore
Production Export creates a backend-scanned AsaDB Backup (.asb) rather than reconstructing a database from the browser result window. The envelope records schema, rows, indexes, catalog objects, table and row totals, and SHA-256 integrity data. Restore verifies the payload and rebuilt totals before committing one transaction, and both create and restore refuse an already-active database transaction.
AsAPanel
AsAPanel is the local browser workspace for database creation, SQL execution, import/export, table inspection, language selection, and Reservoir progress. In v1.4.0, its production Export route requests the verified backend .asb backup path. It ships modern and Firefox-38-compatible interface bundles.
Asa Process Guardian
Guardian is an opt-in source-mirror and process-supervision companion. In v1.4.0 it can also validate and mirror complete .asb artifacts from a separate backup directory, while remaining isolated from SQL execution and database storage.