Skip to content

LionSQL v0.91.0

Choose a tag to compare

@MaroShim MaroShim released this 06 Nov 08:23
· 531 commits to main since this release

LionSQL v0.91.0 Release Notes (notes/RELEASE_NOTES_v0.91.0.md)

  • Initial Date: 2026-11-06
  • Release Version: v0.91.0 (Minor Release)
  • Milestone Theme: Embedded Single-Binary SPA Web Server Hosting (WEB-SPA-1), Total Regular Expression Elimination (GA-REGEX), Formal Compatibility Standards, and In-Memory OCC Flat Record Hardening

1. Release Highlights

LionSQL v0.91.0 is a significant milestone release that expands LionSQL beyond a high-performance relational database into a complete standalone application platform, while radically hardening the core query engine:

  • Embedded SPA Web App Hosting (WEB-SPA-1):
    • Direct hosting of single-page HTML files or production frontend SPA builds (React, Vue, Svelte) on port :8090 without Nginx, Caddy, or reverse proxies.
    • Zero-network-hop in-process bus for web queries, eliminating loopback TCP latency and CORS overhead.
    • OS kernel sendfile(2) zero-copy resource isolation protecting DB OLTP execution from noisy-neighbor web traffic.
    • Comprehensive operational guides published in doc/WEB_APP_HOSTING_GUIDE.ko.md and doc/WEB_APP_HOSTING_GUIDE.md.
  • Total Elimination of Regular Expressions (GA-REGEX):
    • Eradicated all regular expressions across Volcano CBO planner, VDBE runtime, execution LIKE filters, and PGWire dollar parameter binding ($N).
    • Standardized on zero-allocation deterministic tokenizers and state machines in pkg/sqlutil (MatchLike, ReplacePgParams, FindTopLevelKeyword), resolving context-free grammar Dyck language edge cases.
    • Hardened sqlutil.MatchLike with native T-SQL bracket wildcard support ([...], [^...], [_], [%]).
  • Root Compatibility Specifications:
    • Published formal standalone compatibility specifications (COMPATIBILITY.ko.md / COMPATIBILITY.md) standardizing on Microsoft SQL Server 2019 (v15.0) and PostgreSQL 14-16 wire protocols.
  • WiredTiger Power-Cut / SIGKILL Zero-Loss Durability Hardening:
    • Restored transaction_sync=(enabled=true,method=none) in WiredTiger configuration, guaranteeing user-space transaction logs flush to OS buffers on commit and survive abrupt kill -9 without data loss (bin/crashtest verified 100% PASS).
  • 6-Stage Golden Release Verification Gate Deployment (scripts/release.sh):
    • Permanently integrated Core Unit (100k TPS), 13-Domain Smoke, TPC-C (>700k tpmC), SQLLogicTest (410k queries), T-SQL 14-Suite Procedures, and SIGKILL Crash Oracles into the release pipeline, accompanied by an architectural whitepaper (notes/ARTICLE_HOW_RELEASE_GATES_ELEVATE_LIONSQL_VALUE.md).
  • In-Memory OCC Pointer-Free Flat Record Hardening (OCC-HYPER-2):
    • Pointer-free flat record layout codec delivering 67.5% memory reduction with zero GC overhead and verified sub-nanosecond $O(1)$ reads.
  • Engine Internals & Historical Archives Hub:
    • Indexed 7 core architectural specifications in doc/internal/ and established structured 6-tier architecture hubs in notes/ and notes/archive/.

2. Verification & Compliance

  1. 3-Stage Pipeline Verification ([RULE:PipelineVerification]):
    • Official release binaries compiled for macOS (darwin-arm64), Linux (linux-amd64), and Windows (windows-amd64.exe).
    • go test -tags wiredtiger -count=1 ./pkg/... 100% PASS across 23 core packages (0 data races).
  2. Ecosystem & Tool Introspection:
    • Validated against official SQL Server JDBC drivers, go-mssqldb, XORM, and DBeaver/SSMS discovery suites.

Detailed Changelog Delta

Added

  • Embedded SPA Web Server Hosting (WEB-SPA-1): Serve single-page HTML files or flat frontend SPA builds (React, Vue, Svelte) alongside database APIs on port :8090 without Nginx/Caddy; zero-network-hop in-process bus with zero CORS overhead and kernel sendfile(2) resource isolation.
  • Root Compatibility Specifications: Publish formal standalone compatibility specifications (COMPATIBILITY.ko.md / COMPATIBILITY.md) standardizing on Microsoft SQL Server 2019 (15.0.2000.5) and PostgreSQL 14-16 wire protocols.
  • Embedded Web App Hosting Guide: Add comprehensive Korean and English operational guides (doc/WEB_APP_HOSTING_GUIDE.ko.md / doc/WEB_APP_HOSTING_GUIDE.md) detailing architecture, benchmarks (45k-65k RPS, <0.5ms latency), Flat Directory Invariants, and full-stack tutorials.
  • Core Engine Internals Indexing: Formally link and catalog doc/internal/ 7 core architectural specifications (VDBE bytecode ISA, CBO Volcano optimizer, Zero-Allocation memory pooling, Tuple binary codec) directly in the doc/ catalog.
  • Korean Historical Archive Index: Reorganize notes/archive/ into structured bilingual hubs with complete listings of completed execution plans and 107-defect bug resolution logs.
  • implement dynamic runtime configuration CLI commands (lionsql get and lionsql set) with sudo-style terminal password verification (FEAT-TOLERANT-DDL-1)
  • map non-existent index drop errors to standard PostgreSQL SQLSTATE 42704 (undefined_object) in wire protocol for migration framework compatibility (e.g., Knex/NocoDB)
  • unify ad-hoc duplicate table, index, column, constraint, and storage parameter DDL handling into single tolerant mode pipeline controlled strictly via dynamic CLI switch (lionsql set tolerant_ddl on/off)
  • add Materialized View Virtual Alias & Tolerant Refresh architecture plan for enterprise apps (FEAT-MATVIEW-ALIAS-1)
  • add pure-Go Vector Search (FEAT-VECTOR-1) and LSM Time-Series storage (FEAT-TIMESERIES-LSM-1) architecture plans for post-1.0
  • support server_version_num (150000) in SHOW dispatcher and current_setting for Go/Mattermost driver compatibility
  • support ALTER TABLE ... SET (...) storage parameter options as tolerant no-op for Mattermost migration compatibility
  • decouple sprint tool into shared core package (tools/sprint/core) and two dedicated binaries (bin/sprint for LionSQL dogfooding, bin/sprint-lite for standalone SQLite)
  • implement zero-allocation compact binary tuple serialization pipeline for memengine WAL (bf329d3)
  • add atomicity invariant test suite and formalize multi-step transaction boundaries in GEMINI.md (e78a0a6)
  • enforce deterministic ID sorting for diff-stability and add bidirectional restore command to sprint tool
  • formalize dual-sync invariant between TODO dashboard and persistent sprint tasks database

Changed & Refactored

  • Total Elimination of Regular Expressions (GA-REGEX): Completely eradicate regular expressions across CBO planner, VDBE runtime, LIKE execution filters, and PGWire dollar parameters ($N) in favor of zero-allocation deterministic tokenizers and state machines (sqlutil.ReplacePgParams, sqlutil.MatchLike).
  • T-SQL Bracket Wildcards in LIKE Operator: Harden sqlutil.MatchLike with native T-SQL bracket wildcards ([...], [^...], [_], [%]) and range evaluation for robust collation filtering and XORM introspection.
  • WiredTiger ACID Crash Durability Hardening: Restore transaction_sync=(enabled=true,method=none) in WiredTiger configuration, guaranteeing user-space transaction log buffers flush to OS on commit and survive abrupt kill -9 power-cuts without data loss (crashtest verified).
  • 6-Stage Golden Release Verification Gate: Permanently integrate 6 automated verification gates (Core Unit & 100k TPS Gate, 13-Domain Smoke Test, TPC-C >700k tpmC Saturation, SQLLogicTest 409k Queries, T-SQL 14-Suite Procedures, and SIGKILL Crash/Leak Sentinels) into scripts/release.sh, accompanied by bilingual engineering whitepapers (notes/ARTICLE_HOW_RELEASE_GATES_ELEVATE_LIONSQL_VALUE.ko.md / notes/ARTICLE_HOW_RELEASE_GATES_ELEVATE_LIONSQL_VALUE.md).
  • In-Memory OCC Pointer-Free Flat Record Hardening (OCC-HYPER-2): Introduce flat record layout codec with immutable layouts, achieving 67.5% memory reduction while maintaining stable A/B validation.
  • refactor virtual catalog interceptor to table-driven static route table, eliminating sequential IF-chain order sensitivity (REFACTOR-CATALOG-INTERCEPTOR-1)
  • format TASKS.md table sorted strictly by id ASC to eliminate git diff churn on status transitions
  • refactor TPC-C benchmark execution to run multi-statement procedures in single atomic transactions via RunInTx (5a285f1)
  • reorganize notes/ index into structured 6-tier architecture hub, separating active sprints, subsystem plans, verification reports, postmortems, and archives.