AsaDB logo markAsaDB

Prolog Language SQL Engine

Local-first database software

Official Home Page

Local browser workspace

AsAPanel Reference

The localhost interface for creating databases, writing SQL, moving data, and inspecting the local engine.

AsAPanel is served by src/asadb_web.pl on 127.0.0.1. It is a local workspace, not a public web console; it uses a per-run local panel token for API calls.

Workspace features

Database controlsCreate and select a database, save it, delete it after backend verification, inspect engine/database metadata, and check engine status.
SQL editorRun SQL, clear or load a sample, view live diagnostics, SQL coloring, virtualized line numbers, and lightweight schema-aware completion for keywords, types, functions, local objects, aliases, and columns. Use Ctrl+Space to open completion on demand.
Results and tablesInspect paged query results, filter the table list, create/alter/drop tables, view structure and indexes, and inspect table data without a fixed 500-row dead end.
Import and exportImport local files or a server-side sample path, choose handling options, monitor progress, cancel active work, and review a summary. The file picker accepts AsaDB, JSON, CSV, Excel, SQL, PostgreSQL/MySQL-style, and gzip-related extensions. In v1.4.0, production Export creates a backend-scanned .asb backup with schema, rows, indexes, catalog objects, and SHA-256 integrity records; restore validates it before commit.
Reservoir awarenessLarge uploads can enter the Reservoir path. The panel shows active progress, percentage, cancellation, resumed monitoring after reload, and live database metadata for queue pressure.

Language and Asa feedback

AsAPanel exposes Indonesian (ID), Japanese (JP), and English (EN) controls beside Save and Delete. The selected language is stored in browser local storage under asadb-language, so choosing EN persists for later loads. This public documentation site itself is English by default. The current upstream panel source uses Indonesian as its first-run fallback when no preference is saved.

Local startup

# Linux or POSIX source package
./scripts/run_panel.sh data.asa 8088

# Windows source-launcher package
scripts\run_panel.bat data.asa 8088

Open http://127.0.0.1:8088/. See Windows Releases & Setup for package requirements and Reservoir Bridge for the durable queue model.

The upstream panel contains the same support link: Buy Me a Noodles on Saweria ↗.