Skip to content

AsaDB v1.2.0

Choose a tag to compare

@kocoygroup-id kocoygroup-id released this 07 Jul 21:21
f909285

AsaDB v1.2.0 Release Notes

Summary

v1.2.0 is a UX polish release on top of the v1.0.2 stability base. The database
engine remains Prolog-backed; this release focuses on the SQL command flow,
quick-action icons, and safer packaging.

Improvements From v1.0.2

  • Added random query sounds for the SQL command Run button.
  • Added four success variants from assets/Effect/Berhasil.
  • Added four failure variants from assets/Effect/Gagal.
  • Success/failure sound selection avoids repeating the same variant when possible.
  • Sound playback is isolated from execution, so blocked audio cannot break a query.
  • Replaced CSS-drawn save/drop quick-action icons with the provided PNG assets.
  • Fixed static backend routes for the new PNG and MP3 assets.
  • Added explicit media-src 'self' CSP permission for local audio playback.
  • Query sounds are primed from the Run SQL pointer event before async backend work.
  • Rebuilt the Windows package with the new assets included.

Stability Base Kept From v1.0.2

  • Backend multipart upload endpoint for Import > Choose File.
  • Large selected .sql files stream through the Prolog backend.
  • Catalog/sidebar refresh after backend execution.
  • Multi-table catalog regression coverage.
  • Windows data\... paths and first-run journal creation.
  • Duplicate rows preserved in ORDER BY when sort values are equal.
  • Numeric-aware filtering/sorting for numeric-looking text.

Audit Coverage

Checked for this release:

  • Prolog web backend load.
  • Core SQL regression suite.
  • Package asset references for sounds and icons.
  • Runtime package contains all eight MP3 files.
  • Runtime package contains both PNG quick-action icons.
  • Package content does not include source/dev folders.

Validation

swipl -q -g "['src/asadb_web.pl'],halt."
swipl -q -s tests\run_tests.pl

JavaScript node --check was not run because Node.js is not installed on this
machine. The packaged JS asset references were still verified inside the final
release folder.

Notes

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

Logo 1 2 0