AsaDB v1.0.2

AsaDB v1.0.2 Release Notes

Summary

v1.0.2 is a stability release for the Windows public package. The main goal is
to make real practice sessions smoother: large SQL imports, catalog refresh,
and multi-table visibility are now more reliable than v1.0.1.

Improvements From v1.0.1

• Added backend multipart upload endpoint: /api/import_upload.
• Import > Choose File sends SQL files to the Prolog backend when possible.
• Large selected .sql files no longer need to be fully loaded into browser memory.
• Backend imports still run statement-by-statement through the Prolog engine.
• Sidebar/table catalog refresh runs after backend execution more reliably.
• Added regression coverage for multiple tables in one active database.
• Fixed Windows data\... paths and first-run journal creation in release folders.
• Preserved duplicate rows in ORDER BY when sort values are equal.
• Improved numeric-aware filtering/sorting for numeric-looking text.

Audit Coverage

Checked for this release:

• SQL parser and executor core.
• ALTER TABLE.
• Joins, grouping, aggregates, subqueries, UNION, CASE, CONCAT.
• Auto increment with NULL and omitted values.
• Views in sidebar/catalog.
• Save/drop database actions.
• Backend large server-file import.
• Backend upload import from Choose File.
• Windows portable launcher path.
• Windows subfolder database path and journal creation.

Validation

swipl -q -s tests\run_tests.pl

HTTP upload import validation:

public_safety_archive_5500.sql
62 statements
0 errors
COUNT(*) = 5500

Package launcher validation:

AsaDB.exe cli data\package_feature.asa web\samples\feature-tour.sql
AsaDB.exe cli data\package_stress.asa "Stress Test\public_safety_archive_5500.sql"

Notes

AsaDB remains a local developer database, not a complete MySQL clone. Keep
backups of important .asa files before heavy imports or destructive SQL.