Full Text Search (FTS) support

biolab-unige / xtens-app

A digital repository for biomedical data based on a flexible JSON data model ( The project has been moved to a new address https://github.com/xtens-suite/xtens-app.git )

http://www.xtens.org

BSD 3-Clause "New" or "Revised" License

6 stars 1 forks source link

Full Text Search (FTS) support #28

Open gicaz opened 7 years ago

gicaz commented 7 years ago

Add full text search feature like Google. Add a check box to every attribute ( researchable true false) or entire datatype researchable?

Zigur commented 7 years ago

@gicaz: possible implementations are

1) PostgreSQL FTS: https://www.postgresql.org/docs/current/static/textsearch.html

Pros: no separate backend required
- Cons: not as performant and flexible as dedicated text engine As an example see: http://rachbelaid.com/postgres-full-text-search-is-good-enough/

2) Full-fledged text engine (ElasticSearch, SOLR)

Pros: more flexibility and features, higher scalability
Cons: additional backend, need to sync it with Postgres