Is there an extensible SQL like query language that is safe for exposing via a public API?
Posted
by Lokkju
on Stack Overflow
See other posts from Stack Overflow
or by Lokkju
Published on 2010-03-24T20:24:12Z
Indexed on
2010/03/30
22:23 UTC
Read the original article
Hit count: 440
I want to expose some spatial (and a few non-spatial) datasets via a public API. The backend store will either be PostgreSQL/PostGIS, sqlite/spatialite, or CouchDB/GeoCouch.
My goal is to find a some, preferably standard, way to allow people to make complex spatial queries against the data. I would like it to be a simple GET based request. The idea is to allow safe SQL type queries, without allowing unsafe ones. I would rather modify something that is off the shelf than doing the entire thing myself. I specifically want to support requesting specific fields from a table; joining results; and spatial functions that are already implemented by the underlying datastore.
Ideas anyone?
© Stack Overflow or respective owner
