Skip to content

Releases: vlcn-io/cr-sqlite

v0.16.3: 0.16.3 release -- fix wasm oom, fix potentially missing functions

17 Jan 17:42
Compare
Choose a tag to compare

v0.16.2

06 Jan 12:14
Compare
Choose a tag to compare
  • Expose commit sha that the release was built from SELECT crsql_sha()
  • Fix window installation issues for npm users

v0.16.1

16 Dec 12:02
Compare
Choose a tag to compare

The biggest changes:
site_id is required and no longer nullable in crsql_changes

This means that for selecting local only changes you need to do SELECT * FROM crsql_changes WHERE db_version > ? AND site_id = crsql_site_id() rather than site_id IS NULL

Primary key columns may no longer be nullable. This was always the case but now it is explicitly enforced


  • We now throw an error if any primary key columns are set to be nullable.
    • Null primary keys are not allowed in any DB except SQLite.
    • SQLite doesn't enforce uniqueness when a primary key is set to null. I.e., you can have many duplicate rows with a null value in the primary key column.
    • This latter problem completely breaks any attempts at merging
  • ✅ 10x improvement in perf when migrating crr tables
  • ❌ 15% reduction in perf when writing to crr tables :(
  • ✅ 5x reduction in CRDT metadata (at the cost of the above write perf)
  • Compilable under libsql
  • site id is now a required column in crsql_changes
  • release artifacts are zip files containing the properly named loadable extension. This removes the need for a rename step #385

v0.16.0

16 Dec 11:24
Compare
Choose a tag to compare
v0.16.0 official

v0.16.0-next.2

01 Dec 03:14
Compare
Choose a tag to compare
v0.16.0-next.2

v0.16.0-next.1

29 Nov 16:30
Compare
Choose a tag to compare
  • Fixed a bug where npm install would not use pre-build binaries

v0.16.0-next.0

27 Nov 23:11
Compare
Choose a tag to compare
  • We now throw an error if any primary key columns are set to be nullable.
    • Null primary keys are not allowed in any DB except SQLite.
    • SQLite doesn't enforce uniqueness when a primary key is set to null. I.e., you can have many duplicate rows with a null value in the primary key column.
    • This latter problem completely breaks any attempts at merging
  • ✅ 10x improvement in perf when migrating crr tables
  • ❌ 15% reduction in perf when writing to crr tables :(
  • ✅ 5x reduction in CRDT metadata (at the cost of the above write perf)
  • Compilable under libsql
  • site id is now a required column in crsql_changes
  • release artifacts are zip files containing the properly named loadable extension. This removes the need for a rename step #385

v0.16.0-preview

12 Oct 17:27
Compare
Choose a tag to compare
v0.16.0-preview Pre-release
Pre-release
  • Moves all code for tracking local writes out of triggers
  • Decreases CRDT metadata weight by no longer retaining a copy of the primary key of a row for each cell
  • Zips extensions so users do not need to rename them. See #296
  • Uses Rust nightly compiler from October 04 2023
  • Requires that primary keys for CRDT tables are not null

This change is network compatible with v0.15.0 but not source compatible. I.e., v0.16.0 DBs can talk to v0.15.0 DBs but v0.16.0 extensions cannot be loaded into v0.15.0 DB connections.

prebuild-test.win9

11 Oct 16:42
Compare
Choose a tag to compare
prebuild-test.win9 Pre-release
Pre-release
install mingw

v0.15.1

12 Sep 10:48
Compare
Choose a tag to compare
publish automigrate and fractional index fix