Extension: PostGIS

[digoburigo]

Its possible to make postgre with the postgis extension in wasm?

[adilyoltay]

If this extension support is added, there will be great user interest.

[John-P]

I noticed on the homepage (https://pglite.dev/) that support for loading PostGIS is mentioned. However, I could not find any further information. Is there any information about setting this up and managing the required dependencies such as GEOS and GDAL? Has anyone managed to get this working? I wouldn't mind helping with testing or documentation, but it would be great to know what has been done already.

[samwillis]

Hey @John-P

We are very close, it wasn't quite read for lunch yesterday, but is looking like it could happen this week.

[John-P]

@samwillis Oh amazing work! 🚀 That is very exciting to hear.

[baffioso]

Can't wait to fiddle around with this extension. Amazing work ❤️

[PedroFMBranco]

Hi @samwillis, any update on this?

Nevertheless, this library was one of my best finds this year. Keep on the great work 💪

[timneedham]

Hi @samwillis , any feedback on this one please?

[samwillis]

Hey, PostGIS has proved a little complex to get working (it's a very late codebase with a lot of dependencies). Each time we think we've made progress another issue comes up. We know it's a much sought after extension, and so we keep pushing forward. I'm confident we will get it working, but I don't have an ETA.

[timneedham]

Hey, PostGIS has proved a little complex to get working (it's a very late codebase with a lot of dependencies). Each time we think we've made progress another issue comes up. We know it's a much sought after extension, and so we keep pushing forward. I'm confident we will get it working, but I don't have an ETA.

Thanks for the update @samwillis and for all the awesome work you guys are doing.

[bernatfortet]

Thank you so much @samwillis for the hard work.
I'm curious if there would be a way to release support for most common use cases. E.g. saving and loading geometry data.
Postgis has tons more functionality but I assume that being able to load, let's say, the point geometry of a table would unlock lots of us.

Or maybe I'm missing something and I can already load postgis point geometry data?

[stonetip]

We'd be happy with a few functions like ST_AsGeoJSON. Thanks for the hard work so far. Know what I do know about PostGIS and its dependency on GEOS, seems like a complicated task.