Skip to content

v0.1.4 - SQLite Compatibility & Parallel Execution

Choose a tag to compare

@rjwalters rjwalters released this 19 Jan 06:01
· 1083 commits to main since this release

This release focuses on SQLite compatibility and morsel-driven parallel execution. With 878 commits since v0.1.3, highlights include 100% TCL test pass rate on Priority 1 tests, memory-bounded operators with spill-to-disk, UPDATE FROM syntax, and CHECK constraint enforcement.

Highlights

🎯 100% TCL Test Pass Rate (Priority 1)

Complete SQLite compatibility for core SQL operations: SELECT, WHERE, JOIN, aggregate functions, and more.

⚡ Morsel-Driven Parallel Execution (Phase 10)

  • Work-stealing parallel dispatcher with adaptive morsel sizing
  • Parallel GROUP BY, hash join (build + probe), sort, and nested loop joins
  • Per-operation morsel sizes tuned for each operation type

💾 Memory-Bounded Operators

  • External sort with spill-to-disk for datasets larger than memory
  • Memory-bounded aggregation and hash join with configurable limits

🔄 SQLite Compatibility

  • UPDATE FROM - Multi-table UPDATE syntax
  • DELETE with ORDER BY LIMIT - Ordered deletion
  • CHECK constraint enforcement - Runtime validation
  • Row value comparisons - Tuple expressions
  • DEFERRABLE constraints - Foreign key deferral
  • ON CONFLICT DO NOTHING/UPDATE - Upsert support
  • json() function, RTRIM collation, and more

🛠️ CLI Improvements

  • SQLite-style .tables, .schema, .help dot-commands
  • Positional database argument: vibesql mydb.vbsql
  • Automatic database file format detection

🐛 488 Bug Fixes

Extensive fixes for NATURAL/USING JOINs, window functions, type affinity, LIKE/GLOB patterns, triggers, and more.


📖 Full changelog: CHANGELOG.md
🌐 Live demo: https://rjwalters.github.io/vibesql/