search

ramses-tech / nefertari

Nefertari is a REST API framework sitting on top of Pyramid and ElasticSearch
Apache License 2.0
53 stars 19 forks source link

Geospatial support #142

Open tibkiss opened 8 years ago

tibkiss commented 8 years ago

It would be a great value add if nefertari could support geospatial queries. MongoDB and ElasticSearch supports such queries by default, while an extension is needed for bot PostgreSQL (PostGIS) and SQLAlchemy (GEOAlchemy2).

It might be easier to offload the search capability therefore to Elastic Search directly.

If the team could provide some design guidance I'd be willing to spend some time to implement such feature.

Thanks, Tibor

jstoiko commented 8 years ago

If you look at how elasticsearch aggregations work in nefertari, it should give you some guidance on how to implement other types of elasticsearch queries.

In regards to other db engines, I agree that it would be easier to offload these queries to elasticsearch and since elasticsearch is used in most cases when complex requests are needed, I don't see a need to port this functionality to nefertari-(sqla|mongodb).

There has been some work around refactoring engines. The main reason being to be able to use elasticsearch as a standalone datastore, when that makes sense. The branch where this work-in-progress reside is named engine-refactor, in each repository. There is also a nefertari-elasticsearch repository that was created as a result of this work.