full text
Please sorry because I'm newbie of PGSQL
I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between?
Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
www.dellapasqua.com<http://www.dellapasqua.com>
Roberto,
I would look at ZomboDB: https://www.zombodb.com/ . Which is exactly what
you suggest.
JD
On Wed, Apr 8, 2020 at 10:28 AM Roberto Della Pasqua <
roberto.dellapasqua@live.com> wrote:
Show quoted text
Please sorry because I’m newbie of PGSQL
I need the best performing and overall quality full-text search, can be
possible to have the data stored in pgsql and the index to elasticsearch?
Can be in sync between?Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
www.dellapasqua.com
i dont know how to do with elastic-search
according to programcreek you can create an index from a <Seldon|Postgres> jdbc source
https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.java
CreateLuceneIndexFromDb Java Source Code <https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.java>
This page provides Java source code for CreateLuceneIndexFromDb.
www.programcreek.com
its up to you to determine the jdbc connection attributes from Postgres
Buona Fortuna!
martini
________________________________
From: Roberto Della Pasqua <roberto.dellapasqua@live.com>
Sent: Wednesday, April 8, 2020 1:28 PM
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: full text
Please sorry because I’m newbie of PGSQL
I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between?
Thank you
Btw. Do you suggest another engine than elastic?
Roberto Della Pasqua
www.dellapasqua.com<http://www.dellapasqua.com>
Greetings,
* Roberto Della Pasqua (roberto.dellapasqua@live.com) wrote:
Please sorry because I'm newbie of PGSQL
We all were, once upon a time. :)
I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between?
[...]
Btw. Do you suggest another engine than elastic?
PG's got some rather good built-in full-text search capabilities, you
really should consider them before you look to something outside of PG,
since you'd then have, as you say, to deal with sync'ing things between
the database and something external, not to mention having to run an
additional service on top of already running PG.
https://www.postgresql.org/docs/current/textsearch.html
Thanks,
Stephen