search

r-spatial / stars

Spatiotemporal Arrays, Raster and Vector Data Cubes
https://r-spatial.github.io/stars/
Apache License 2.0
563 stars 94 forks source link

SQL Support #500

Closed latot closed 2 years ago

latot commented 2 years ago

Hi hi, I would like to know how is the SQL support with stars.

Particularly, we know for SQL there is PostGIS, an extension for PostgreSQL for spatial data, but for spatiotemporal data like stars is other thing, when we move data to a SQL Server, one objective is, to the server execute all the queries and operations.

The only thing I found was: https://github.com/locationtech/geomesa

Maybe there is no support from stars, in that case, I would like to propose it.

Thx.

edzer commented 2 years ago

Maybe you want to look into array databases, there are several of them; stars is about an R interface to arrays, not an SQL interface.

latot commented 2 years ago

I was thinking like sf and dplyr have SQL support, or I'm confuse about something?.

edzer commented 2 years ago

I don't think that the languages for querying array databases are standardized the way they are for relational databases.

edzer commented 2 years ago

Please reopen this if you (or someone) can get more specific about which type of array SQL, database backend, and functionality one would like to support.