Elasticsearch is no different than any other data store: your application can add data by using the prescribed methods. Every data store has some sort of data input method. Elasticsearch allows river plugins, which mean that the Elasticsearch process can pull data instead of the standard push model. The pull model is usually employed when two data sources should be in sync (CouchDB, RDBMS).
I would stick to the standard push model. Have your client application index data via the PHP library. Cheers, Ivan On Fri, Sep 12, 2014 at 10:54 AM, Employ <m...@employ.com> wrote: > I must admit I'm new to this so I find some of the information hard to > understand. So sorry if I am asking stupid questions. > > On 12 Sep 2014, at 18:26, Ivan Brusic <i...@brusic.com> wrote: > > I would strongly prefer to maintain control of the indexing side and not > in Elasticsearch. In fact, the Elasticsearch team has talked about > deprecating river plugins. I do not have any numbers, but I would suspect > that the majority of users do not use a river plugin. And yes, the correct > term is the JDBC plugin, not driver. The wrong term confused many. :) > > -- > Ivan > > On Fri, Sep 12, 2014 at 3:24 AM, joergpra...@gmail.com < > joergpra...@gmail.com> wrote: > >> You can use either style, it is a matter of taste, or convenience. >> >> With the JDBC plugin, you can also push data instead of pull. >> >> Jörg >> >> On Fri, Sep 12, 2014 at 12:11 PM, James <m...@employ.com> wrote: >> >>> I want to close this issue but I still do not understand if I should be >>> pushing documents from my database using the PHP client or using the JDBC >>> river to pull them into elasticsearch from the SQL database. >>> >>> They can both achieve the same thing, but what is the usecase which >>> defines when is the right time to use each implementation. >>> >>> >>> >>> On Wednesday, September 10, 2014 10:59:18 AM UTC+1, James wrote: >>>> >>>> Hi, >>>> >>>> I'm setting up a system where I have a main SQL database which is >>>> synced with elasticsearch. My plan is to use the main PHP library for >>>> elasticsearch. >>>> >>>> I was going to have a cron run every thirty minuets to check for items >>>> in my database that not only have an "active" flag but that also do not >>>> have an "indexed" flag, that means I need to add them to the index. Then I >>>> was going to add that item to the index. Since I am using taking this path, >>>> it doesn't seem like I need the JDBC driver, as I can add items to >>>> elasticsearch using the PHP library. >>>> >>>> So, my question is, can I get away without using the JDBC driver? >>>> >>>> James >>>> >>>> >>>> -- >>> 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 elasticsearch+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/elasticsearch/6c244e00-1f89-447d-8eb5-114f0b5efcbd%40googlegroups.com >>> <https://groups.google.com/d/msgid/elasticsearch/6c244e00-1f89-447d-8eb5-114f0b5efcbd%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> 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 elasticsearch+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHT2DcMHJwMjxBZ0RsV4_eKJyB2KjBCiqB2ZTac8fzkTg%40mail.gmail.com >> <https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHT2DcMHJwMjxBZ0RsV4_eKJyB2KjBCiqB2ZTac8fzkTg%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/elasticsearch/0dzSMbARlks/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBvDga8q--Au8yWaX2RMGgcDTpYMhLu243tB9w7z0W0_A%40mail.gmail.com > <https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBvDga8q--Au8yWaX2RMGgcDTpYMhLu243tB9w7z0W0_A%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > -- > 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 elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/9EBFE31B-8DEA-4E05-8342-9E0013BC450B%40employ.com > <https://groups.google.com/d/msgid/elasticsearch/9EBFE31B-8DEA-4E05-8342-9E0013BC450B%40employ.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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 elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQCYY%2B5WegyBJAyn2abjZB9f6U5j%3D068UHDSsFusuA%2BAug%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.