On Thu, Apr 09, 2015 at 01:07:43PM -0700, Fabio Ebner wrote: > It's possible to connect the elastic 1.5.1 with my postgresql?? in 1.3.1 I > do this with river plugin, > but in 1.5.1 I read that river are deprecated.
I'm hoping someone will implement a Postgres Foreign Data Wrapper for Elasticsearch. (I'd do it myself by my time is taken elsewhere.) There are many wrappers already, including interfaces to a number of "NoSQL" databases like Cassandra, CouchDB, MongoDB, RethinkDB etc: https://wiki.postgresql.org/wiki/Foreign_data_wrappers The Multicorn project http://multicorn.org is a PostgreSQL extension to make Foreign Data Wrapper development easy by allowing the programmer to use the Python programming language. It ought to be simple to implement a PostgreSQL FDW for Elasticsearch using Multicorn and the Elasticsearch Python API. The end result would be that Elasticsearch data would appear as tables in your Postgres database. You could then insert, delete, update and select Elasticsearch data from within Postgres. Here are the slides for "Write a Foreign Data Wrapper in 15 minutes": https://wiki.postgresql.org/images/7/7e/Conferences-write_a_foreign_data_wrapper_in_15_minutes-presentation.pdf Tim. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/20150413103358.GI1536%40timac-2.local. For more options, visit https://groups.google.com/d/optout.
