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 controls | Create and select a database, save it, delete it after backend verification, inspect engine/database metadata, and check engine status. |
|---|---|
| SQL editor | Run 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 tables | Inspect 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 export | Import 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 awareness | Large 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.
| Feedback state | Indonesian label | English label | Japanese label | Meaning |
|---|---|---|---|---|
| Accepted | Asa Terima 😳 | Asa Approves 😳 | アサは受け入れました 😳 | The SQL form was accepted or completed successfully; the panel can show a friendly result message. |
| Rejected | Asa Tidak Suka! 😡 | Asa Doesn't Like That! 😡 | アサは気に入りません! 😡 | The command stopped because of an error, an unsafe form, missing information, or a backend issue. |
| Correction | Asa Mau Koreksi 🤔 | Asa Suggests a Fix 🤔 | アサから修正案 🤔 | The panel has a diagnostic or a small correction suggestion, for example a likely SQL typo or malformed input. |
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 ↗.
