search

electric-sql / pglite

Lightweight WASM Postgres with real-time, reactive bindings.
https://pglite.dev
Apache License 2.0
9.45k stars 204 forks source link

Extension: PostGIS #11

Open digoburigo opened 9 months ago

digoburigo commented 9 months ago

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

adilyoltay commented 8 months ago

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

John-P commented 3 months ago

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 commented 3 months ago

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 commented 3 months ago

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

baffioso commented 3 months ago

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

PedroFMBranco commented 2 months ago

Hi @samwillis, any update on this?

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

timneedham commented 1 month ago

Hi @samwillis , any feedback on this one please?

samwillis commented 1 month ago

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 commented 1 month ago

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 commented 1 month ago

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 commented 3 weeks ago

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.