Skip to content

v0.1.5

Choose a tag to compare

View all tags
@edadma edadma released this 21 Feb 02:48
· 433 commits to dev since this release
v0.1.5
0ea9992

What's New (since v0.1.4)

JS/npm

  • Fix ConnectSQL JS wrapper to handle CreateIndexResult and TruncateResult (was throwing MatchError)
  • Add TypeScript types for all result variants: CreateIndexResult, TruncateTableResult, PrepareResult, DeallocateResult, BeginResult, CommitResult, RollbackResult
  • Updated npm README with full SQL feature documentation

CLI

  • rdb mydb.rdb now opens the REPL directly (no need to type run subcommand)
  • rdb with no args opens an in-memory REPL

Build

  • Fix publishTo for cross-project monorepo (moved into engine settings)
  • Pin cross_platform 0.1.3 to resolve bptree/stow version conflict

Full feature list (from v0.1.4)

  • SQL compatibility: case-insensitive keywords, unquoted identifier folding, double-quoted identifiers, <> operator, CAST(expr AS type), doubled single-quote escaping
  • New statements: TRUNCATE TABLE, CREATE TABLE IF NOT EXISTS, INSERT INTO ... SELECT, UPDATE ... FROM
  • Prepared statements: PREPARE, EXECUTE with $N parameters, DEALLOCATE
  • Query features: LATERAL joins, column aliases on FROM sources, OVERLAPS, = ANY(...)
  • Foreign keys: ON DELETE / ON UPDATE with CASCADE, SET NULL, SET DEFAULT, RESTRICT
  • Index improvements: composite index scans, IN/ANY index scans
  • Functions: starts_with, ends_with, variance, var_samp, var_pop, stddev, stddev_samp, stddev_pop
Assets 2
Loading