SawitDB v2.5.0

[repo-unx]

Release SawitDB v2.5.0

Major Performance Update

• Object Caching (Page-Level): Implemented a memory-resident Object Cache in Pager.js.
  • Zero-Copy Reads: Bypasses JSON.parse overhead for hot pages.
  • Performance: SELECT (Indexed) jumped from ~60k to ~247,000 TPS.
• Hash Join: Optimized JOIN operations from O(M*N) to O(M+N).
  • Faster Queries: Complex joins reduced from ~2900ms to ~40ms.
• Query Plan Caching: Implemented LRU Cache for parsed queries to reduce CPU overhead on repeated queries.

Added

• Async WAL (Write-Ahead Logging): Refactored for non-blocking stream-based writes.
• CLI Enhancements: Detailed help menus, SQL aliases, and database switching in local.js.
• New Tools: Added CLI Unit Tests (cli/test.js) and Performance Benchmark (cli/benchmark.js).

Bug Fixes

• Persistence: Fixed critical bug where Indexes were lost on restart (Added _indexes system table).
• File Locking: Fixed Windows EPERM issues during DROP DATABASE.
• Query Parser: Fixed Operator Precedence (AND > OR) and escaped quotes handling.

---

This discussion was created from the release SawitDB v2.5.0.