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 #97
- REPL loading state by @samwillis in #100
- 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
- PGlite Next - Based on Postgres 16.x by @pmp-p in #112
- 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
- New method
execProtocolRaw()
by @gregnr in #127 - Multi-tab worker by @samwillis in #120
- OPFS access handle pool VFS by @samwillis in #130
- Postgres contrib extensions by @samwillis in #131
- contrib folder auto builder by @pmp-p in #129
- Fix close and add support for new stage 3 ECMAScript explicit resource management by @samwillis in #133
- Format and export the release dir from the package by @samwillis in #137
- Fix bundling for Next.js by @samwillis in #140
- contrib/uuid_ossp by @samwillis in #136
- Fix closing of the IndexedDB when closing an idb backed pglite by @samwillis in #141
- Format the examples by @samwillis in #145
- Add a "browser" field to package.json to hint to bundlers what is not required in the browser by @samwillis in #143
- CJS support by @samwillis in #144
- Benchmark improvements by @samwillis in #146
- Enable setting a user when connecting to PGlite by @pmp-p in #147
- feat: React hooks by @msfstef in #150
- Enable swapping database by @samwillis in #148
- Fix live query params by @samwillis in #151
- chore: Common monorepo setup for linting, formatting, typechecking by @msfstef in #152
- Docs site by @samwillis in #121
- ElectricSQL sync by @samwillis in #122
- chore: React hook docs by @samwillis in #156
- chore: Add plausible to docs by @samwillis in #157
- Fix pg-protocol types by forcing tsc to bundle pg-protocol by @samwillis in #158
- Impliment llseek for the /dev/blob device enabling loading larger files by @samwillis in #159
- Fix OPFS AHP state WAL loading by @samwillis in #160
- Fix /dev/blob typo in error message by @samwillis in #165
- Lower initial memory, with runtime config to set higher by @samwillis in #164
- REPL Playground by @samwillis in #162
- feat: New CI workflows by @msfstef in #155
- fix: Reuse the pglite build for changeset release by @msfstef in #168
- fix: Even more CI fixes by @msfstef in #169
- Update readme by @samwillis in #167
- fix: Remove linked packages by @msfstef in #170
- chore: Update package version and release settings by @msfstef in #171
New Contributors
Full Changelog: https://github.com/electric-sql/pglite/compare/v0.1.5...@electric-sql/pglite@0.2.0