[Help Wanted] PostGIS extension

[tdrz]

Build postgis for pglite.

https://postgis.net/docs/postgis_installation.html#install_requirements

See branch https://github.com/electric-sql/pglite/tree/tdrz/frontend-try-postgis2

All necessary dependencies are built in that branch (see Dockerfile),and creating postgis.tar.gz is possible with some manual steps (see build-postgis.sh). There is a postgis.test.ts that contains a basic postgis test.

This is work in progress (ie not working)!

Update 2026.01.26

We are very close to having PostGIS in PGlite: #807
Have a look through the comments on that PR.

[tdrz]

Ideally the final binary will contain libstdc++ such that the MAIN_MODULE (ie to pglite.wasm) wouldn't need to contain it.

-Wl,--whole-archive -lstdc++ -Wl,--no-whole-archive

Is this possible with emscripten?

[tdrz]

You can now build the project the usual way pnpm build:all and run the tests.
You can also run only the postgis tests by cd packages/pglite and then vitest tests/postgis.test.ts. Currently they are failing with missing symbols. We need a reliable way of extracting the needed symbols as this seems to be one of the issues with this extension.

[papidb]

Hi @tdrz good morning, please how can I help move this forward, my team is contemplating writing some integration tests in JS, and trying to avoid the testcontainers route right now. Getting PostGIS in pglite would really come in clutch.

[tdrz]

Hey @papidb please have a look at the comments here: #807

We're very close to having PostGIS in PGlite, the only remaining issues is Chrome's 8MB wasm loading limit.

[tdrz]

Deployed pglite-postgis, compatible with PGlite v0.4.0. 🚀