search

electric-sql / electric

Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.
https://electric-sql.com
Apache License 2.0
5.46k stars 125 forks source link

Geo data support #1227

Open Ashraf-Ali-aa opened 2 months ago

Ashraf-Ali-aa commented 2 months ago

Hi does electric sql support geo data, I am currently looking into PostgreSQL + PostGIS but I am unsure if the SQLlite supports the geo data I did find a fork of SQLlite that seems to support geo data

https://www.gaia-gis.it/fossil/libspatialite/index

linear[bot] commented 2 months ago

VAX-1824 Geo data support

samwillis commented 2 months ago

Hey @Ashraf-Ali-aa

we don't have geo data type support yet, but very much plan to. If you let us know the use case there are some work arounds that you could use at the moment though.

If you are looking for full postgis support on the client we are planning to make it available as an extension to PGlite (a WASM build of Postgres we're building). Electric support for PGlite is imminent (ETA early next week), and Postgres extension support for PGlite is being actively worked on. We hope to have it working in the next few months.

Ashraf-Ali-aa commented 2 months ago

thanks for the update, I wanted a way to query location data while offline, I was planning on storing the data in geojson format, but if you are planning on adding PostGIS to PGlite this would be brilliant.

Ashraf-Ali-aa commented 2 months ago

Also would PGlite support react native?