postgres icon indicating copy to clipboard operation
postgres copied to clipboard

Add h3 extension to the extensions list

Open kav opened this issue 3 years ago • 0 comments

Feature request

We'd love to use h3 for some simple distance calculations using H3 https://h3geo.org/ . For a primer on how this differs from other Geospatial libraries see the introductory blog post here: https://eng.uber.com/h3/

Is your feature request related to a problem? Please describe.

Describe the solution you'd like

I'd love https://github.com/bytesandbrains/h3-pg added to the extensions list so I could turn it on or off at will

Describe alternatives you've considered

Our three alternatives are to off-load h3 processing to a secondary function for filtering and sorting post-postgres or self-host supabase and install the extension there or just use postgis which works but is a fair bit more complex and a bit difficult to master for our use case.

Additional context

H3 is pretty dang cool and something I suspect anyone doing location focused apps on Supabase would really appreciate having it. Even seeing it in the extensions lists and googling it could be pretty awesome for folks just getting started.

More on h3: https://foursquare.com/article/all-about-h3-your-questions-answered/ https://foursquare.com/article/how-to-use-h3-for-geospatial-analytics/

Thanks for taking the time!

kav avatar Jul 21 '22 15:07 kav