0.9.0-next.0 preview release. Updated transaction APIs, primary key only tables, JS package move, perf updates, background sync

[tantaman]

JS

@vlcn.io/wa-crsqlite is now @vlcn.io/crsqlite-wasm

Repository Split

All JS code has been moved to the crsqlite-js repository. We'll see how this works -- it may just make its way back here again.

Updated Transaction APIs

For the browser, db.transaction has been renamed to db.tx. In addition, the callback to db.tx receives a transaction parameter. The callback must use this parameter for all subsequent queries within the transaction.

Prepared statements should also be run against the provided transaction parameter.

Example:

db.tx((tx) => {
  tx.exec(...);
  tx.exec(...);

  preparedStatement.run(tx);
});

React Hook Perf Improvements

useQuery has been updated to run all calls in the same render pass in a single read transaction. This is a ~10x improvement in read performance when you have dozens of concurrent reads.

Background Sync

The websocket-client will now sync changes in the background in a web-worker by default. You can change this behavior by passing worker: false to the websocket client on initialization.

Primary Key Only Tables

Tables that only have primary key columns may now be crrs. Note: modifying the value of a primary key column still has not been addressed.

Beyond 0.9.0:

• Further improvements to useQuery
• Rich text support
• Auto-migrations