v0.2.0-alpha.3

Alpha of version 0.2, this marks a large step forward with a new build architecture and better stability.

What's Changed

• PGlite Next by @pmp-p in #112
  • Now based on Postgres version 16.3
  • Support for dynamic loading of extensions, with the first being pgvector
  • A new dumpDataDir method to dump a tarball of the database, and a loadDataDir option when starting to load a database
  • Fixes issues with TOAST values and materialised views.
• Fix web worker syntax for webpack static analysis by @gregnr in #103
• Support for adding or receiving a blob for use with COPY FROM/TO by @samwillis in #106
• Support for pg_notify by @samwillis in #102
• Extension API by @samwillis in #99
• Fix extension loading when server sends content-encoding: gzip header by @samwillis in #124
• Live Query API by @samwillis in #104
• New method execProtocolRaw() by @gregnr in #127

New Contributors

• @gregnr made their first contribution in #103

Full Changelog: v0.1.5...v0.2.0-alpha.3

v0.2.0-alpha.2

What's Changed

• Fix extension loading when server sends content-encoding: gzip header by @samwillis in #124
• Fix pl/pgsql by @pmp-p in #125
• Live Query API by @samwillis in #104

Full Changelog: v0.2.0-alpha.0...v0.2.0-alpha.2

v0.2.0-alpha.0

First Alpha of version 0.2, this marks a large step forward with a new build architecture and better stability.

What's Changed

• PGlite Next by @pmp-p in #112
  • Now based on Postgres version 16.3
  • Support for dynamic loading of extensions, with the first being pgvector
  • A new dumpDataDir method to dump a tarball of the database, and a loadDataDir option when starting to load a database
  • Fixes issues with TOAST values and materialised views.
• Fix web worker syntax for webpack static analysis by @gregnr in #103
• Support for adding or receiving a blob for use with COPY FROM/TO by @samwillis in #106
• Support for pg_notify by @samwillis in #102
• Extension API by @samwillis in #99

New Contributors

• @gregnr made their first contribution in #103

Full Changelog: v0.1.5...v0.2.0-alpha.0

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.