From postgres to elastic for my website, which is running on php5.6

[shosek]

Hello,

is possible (or good idea) transition from postgresql to elastic for my website, which is running with php 5.6? Or Is there a way to have postgres database and use elastic only for searching products in my shop (faster?)? How is it work? I mean actualization of data in json elastic database.

Or am I totally out about elastic use?

Thank you very much for any reaction and help.

BR,

Stan.

[dadoonet (David Pilato)]

I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.