Full Text Search (FTS) support

xtens-suite / xtens-app

A digital repository for biomedical data based on a flexible JSON data model

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

2 stars 0 forks source link

Open gicaz opened 6 years ago

gicaz commented 6 years ago

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

gicaz commented 6 years ago

@gicaz: possible implementations are

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/
Full-fledged text engine (ElasticSearch, SOLR)
- Pros: more flexibility and features, higher scalability
- Cons: additional backend, need to sync it with Postgres