v0.1.5

What's Changed

• fix: Handle undefined as though it's a null when serializing by @samwillis in #84

Full Changelog: v0.1.4...v0.1.5

v0.1.4

What's Changed

• Add a relaxed durability mode for use with the idb vfs by @samwillis in #79

Full Changelog: v0.1.3...v0.1.4

v0.1.3

What's Changed

• Improve efficiency of syncToFs by @samwillis in #77
• Fixed unhandled promise rejection in close() call by @samwillis in #78

Full Changelog: v0.1.2...v0.1.3

v0.1.2

What's Changed

• Fix invalid storage in webworker by @JfrAziz in #67
• Fix for importing createRequire in some environments #71 by @samwillis in #73
• Resolve bug preventing affectedRows count for mutation queries by @pmooney-socraticworks in #72

Contributors

• @JfrAziz made their first contribution in #67
• @pmooney-socraticworks made their first contribution in #72
• Thanks to @jgoux suggestion in #71

Full Changelog: v0.1.1...v0.1.2

v0.1.1

Patch release including:

• Improvements to Postgres type parsing and serialisation.
• Adds support for Postgres array types.

v0.1.0

Whats new in V0.1

Version 0.1 (up from 0.0.2) includes significant changes to the Postgres build - it's about 1/3 smaller at 2.6mb gzipped, and up to 2-3 times faster. We have also found a way to statically compile Postgres extensions into the build - the first of these is pl/pgsql with more coming soon.

Key changes in this release are:

• Support for parameterised queries #39
• An interactive transaction API #39
• pl/pgsql support #48
• Additional query options #51
• Run PGlite in a Web Workers #49
• Fix for running on Windows #54
• Fix for missing pg_catalog and information_schema tables and view #41

We have also published some benchmarks in comparison to a WASM SQLite build, and both native Postgres and SQLite. While PGlite is currently a little slower than WASM SQLite we have plans for further optimisations, including OPFS support and removing some the the Emscripten options that can add overhead.