Geo data support

[Ashraf-Ali-aa]

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]

VAX-1824 Geo data support

[samwillis]

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]

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]

Also would PGlite support react native?