Add support for GeoSpatial queries in Cloudflare D1 (e.g. R*tree or Geopoly)

[johnswarbrick]

Describe the solution

Having a GeoSpatial plugin for Cloudflare D1 would fill a quite significant capability gap vs a cloud-hosted PostgreSQL or even SQLite database.

It would also allow customers using GeoSpatial features to migrate workflows from other providers to Cloudflare D1.

Running GeoSpatial queries "on the edge" using D1 will always be more efficient and offer less latency than trying to do it through a centralised database from another managed database provider.

There are existing GeoSpatial extensions for SQLite such as R*tree and Geopoly Extension would could be enabled.

[a-eid]

updated ?

[smashah]

yes please!

[a7md0]

Would really be nice to have, please consider SpatiaLite as well

[joeblew999]

Also suggest spatialite as a good standard one

it’s just an extension with extra specialised tables

[TetianaKremnova]

need that too!

[a-eid]

updates ?

[magick93]

Please 🙏