Version 0.2 of PGlite with support for extensions (including pgvector!), a reactive live query API, and initial support for Electric/next sync.

This is the big release we have been working towards for the last few months, and I'm very happy we can now share it with you all. We have squashed a lot of bugs and hit a very long list of features to get this ready.

• https://pglite.dev - our new site for PGlite with docs, a REPL, extensions catalog and benchmarks.
• https://github.com/electric-sql/pglite/ - the GitHub
• https://pglite.dev/docs/sync - Sync using Electric/next

What's Changed

• PGlite REPL by @samwillis in https://github.com/electric-sql/pglite/pull/97
• REPL loading state by @samwillis in https://github.com/electric-sql/pglite/pull/100
• Fix web worker syntax for webpack static analysis by @gregnr in https://github.com/electric-sql/pglite/pull/103
• Support for adding or receiving a blob for use with COPY FROM/TO by @samwillis in https://github.com/electric-sql/pglite/pull/106
• Support for pg_notify by @samwillis in https://github.com/electric-sql/pglite/pull/102
• Extension API by @samwillis in https://github.com/electric-sql/pglite/pull/99
• PGlite Next - Based on Postgres 16.x by @pmp-p in https://github.com/electric-sql/pglite/pull/112
• Fix extension loading when server sends content-encoding: gzip header by @samwillis in https://github.com/electric-sql/pglite/pull/124
• Fix pl/pgsql by @pmp-p in https://github.com/electric-sql/pglite/pull/125
• Live Query API by @samwillis in https://github.com/electric-sql/pglite/pull/104
• New method execProtocolRaw() by @gregnr in https://github.com/electric-sql/pglite/pull/127
• Multi-tab worker by @samwillis in https://github.com/electric-sql/pglite/pull/120
• OPFS access handle pool VFS by @samwillis in https://github.com/electric-sql/pglite/pull/130
• Postgres contrib extensions by @samwillis in https://github.com/electric-sql/pglite/pull/131
• contrib folder auto builder by @pmp-p in https://github.com/electric-sql/pglite/pull/129
• Fix close and add support for new stage 3 ECMAScript explicit resource management by @samwillis in https://github.com/electric-sql/pglite/pull/133
• Format and export the release dir from the package by @samwillis in https://github.com/electric-sql/pglite/pull/137
• Fix bundling for Next.js by @samwillis in https://github.com/electric-sql/pglite/pull/140
• contrib/uuid_ossp by @samwillis in https://github.com/electric-sql/pglite/pull/136
• Fix closing of the IndexedDB when closing an idb backed pglite by @samwillis in https://github.com/electric-sql/pglite/pull/141
• Format the examples by @samwillis in https://github.com/electric-sql/pglite/pull/145
• Add a "browser" field to package.json to hint to bundlers what is not required in the browser by @samwillis in https://github.com/electric-sql/pglite/pull/143
• CJS support by @samwillis in https://github.com/electric-sql/pglite/pull/144
• Benchmark improvements by @samwillis in https://github.com/electric-sql/pglite/pull/146
• Enable setting a user when connecting to PGlite by @pmp-p in https://github.com/electric-sql/pglite/pull/147
• feat: React hooks by @msfstef in https://github.com/electric-sql/pglite/pull/150
• Enable swapping database by @samwillis in https://github.com/electric-sql/pglite/pull/148
• Fix live query params by @samwillis in https://github.com/electric-sql/pglite/pull/151
• chore: Common monorepo setup for linting, formatting, typechecking by @msfstef in https://github.com/electric-sql/pglite/pull/152
• Docs site by @samwillis in https://github.com/electric-sql/pglite/pull/121
• ElectricSQL sync by @samwillis in https://github.com/electric-sql/pglite/pull/122
• chore: React hook docs by @samwillis in https://github.com/electric-sql/pglite/pull/156
• chore: Add plausible to docs by @samwillis in https://github.com/electric-sql/pglite/pull/157
• Fix pg-protocol types by forcing tsc to bundle pg-protocol by @samwillis in https://github.com/electric-sql/pglite/pull/158
• Impliment llseek for the /dev/blob device enabling loading larger files by @samwillis in https://github.com/electric-sql/pglite/pull/159
• Fix OPFS AHP state WAL loading by @samwillis in https://github.com/electric-sql/pglite/pull/160
• Fix /dev/blob typo in error message by @samwillis in https://github.com/electric-sql/pglite/pull/165
• Lower initial memory, with runtime config to set higher by @samwillis in https://github.com/electric-sql/pglite/pull/164
• REPL Playground by @samwillis in https://github.com/electric-sql/pglite/pull/162
• feat: New CI workflows by @msfstef in https://github.com/electric-sql/pglite/pull/155
• fix: Reuse the pglite build for changeset release by @msfstef in https://github.com/electric-sql/pglite/pull/168
• fix: Even more CI fixes by @msfstef in https://github.com/electric-sql/pglite/pull/169
• Update readme by @samwillis in https://github.com/electric-sql/pglite/pull/167
• fix: Remove linked packages by @msfstef in https://github.com/electric-sql/pglite/pull/170
• chore: Update package version and release settings by @msfstef in https://github.com/electric-sql/pglite/pull/171

New Contributors

• @gregnr made their first contribution in https://github.com/electric-sql/pglite/pull/103

Full Changelog: https://github.com/electric-sql/pglite/compare/v0.1.5...@electric-sql/pglite@0.2.0