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_catalogandinformation_schematables 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.