[Help wanted] PostGIS

[tdrz]

[HELP WANTED]

We are looking for help making PostGIS a reality for PGlite.

The bulk of the work has been done, the extension is built as part of the entire build process and there are even a few PostGIS test that pass! But some don't, see all of them in packages/pglite/tests/postgis.test.ts.

There are multiple issues:

1. ~Identify the missing exported functions that PostGIS is expecting from PGlite (they need to be added to postgres-pglite/pglite-wasm/included.pglite.imports).~ We think we have achieved this - more tests needed.
2. For the moment, we don't want to use threads in PGlite, so all dependencies and PostGIS itself need to explicitly be built without threads support. Some are already, see postgres-pglite/pglite-wasm/builder/Dockerfile but some are not because pthread required functions still sneak in.
3. Add more tests such that we are sure the PostGIS works as expected. Ideally we would run PostGIS tests against a PGlite instance (possibly using pglite-socket).
4. Manual test - if you have an app that uses Postgresql + PostGIS, please try it with PGlite + PostGIS (you can manually download the package that contains it from a CI run related to this PR).

Other: a. Although libgdal is present in the docker builder image, it is not currently used by the final extension. Something to look into. b. I've build all deps as static libs and now I am doubting that this is the right course of actions (mainly because of difficulties of also linking libgdal to the final extension).

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18247075503/artifacts/4182845488
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190501941/artifacts/4506965998
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190501941/artifacts/4506967395
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190501941/artifacts/4506968886
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190501941/artifacts/4506973803
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190501941/artifacts/4506974975
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190907478/artifacts/4507075479
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190907478/artifacts/4507076407
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190907478/artifacts/4507077580
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190907478/artifacts/4507081519
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19190907478/artifacts/4507083438
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19205879006/artifacts/4511132956
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19205879006/artifacts/4511133786
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19205879006/artifacts/4511134032
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19205879006/artifacts/4511135940
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19205879006/artifacts/4511136531
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19210068516/artifacts/4512272706
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19210068516/artifacts/4512273081
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19210068516/artifacts/4512276566
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19210068516/artifacts/4512277073
• PGlite: https://github.com/electric-sql/pglite/actions/runs/19210068516/artifacts/4512287554

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18247075503/artifacts/4182846400

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18247075503/artifacts/4182847920

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18247075503/artifacts/4182849219

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18247075503/artifacts/4182851702

[github-actions[bot]]

• Demos: https://github.com/electric-sql/pglite/actions/runs/18247075503/artifacts/4182865700

[github-actions[bot]]

🚀 Deployed on https://6910af6d824cac18c8c9c562--pglite.netlify.app

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18283383454/artifacts/4193180279

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18283383454/artifacts/4193184664

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18283383454/artifacts/4193191125

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18283383454/artifacts/4193194124

[github-actions[bot]]

• PGlite: https://github.com/electric-sql/pglite/actions/runs/18283383454/artifacts/4193197794

[github-actions[bot]]

• Demos: https://github.com/electric-sql/pglite/actions/runs/18283383454/artifacts/4193264451

[github-actions[bot]]

• Demos: https://github.com/electric-sql/pglite/actions/runs/19190501941/artifacts/4506990665

[github-actions[bot]]

• Demos: https://github.com/electric-sql/pglite/actions/runs/19190907478/artifacts/4507097958

[github-actions[bot]]

• Demos: https://github.com/electric-sql/pglite/actions/runs/19205879006/artifacts/4511153258

[github-actions[bot]]

• Demos: https://github.com/electric-sql/pglite/actions/runs/19210068516/artifacts/4512307456