Skip to content
This repository has been archived by the owner on Apr 28, 2022. It is now read-only.

Better support for full-text searches #1

Open
dzhelezov opened this issue Oct 3, 2021 · 1 comment
Open

Better support for full-text searches #1

dzhelezov opened this issue Oct 3, 2021 · 1 comment

Comments

@dzhelezov
Copy link
Contributor

dzhelezov commented Oct 3, 2021

Current schema design of full-text search queries is not customizable to support different important uses-cases. Probably the field-level annotation should be replaced with an object-level (say @FullTextQuery) similar to how it is defined in TheGraph schémas. Then it should support

  • multiple queries with overlapping field (which may span multiple entities)
  • different languages
  • Strict/Partial/search-as-you-go queries (only strict node is activated atm)
  • support sorting by relevance (ts_rank)

All the options above (and more) are supported by Postgres out-of-the-box so we just need to figure out the right format of the schema definition and translate it into appropriate SQL queries

Related issue: Joystream/hydra#457

@dzhelezov
Copy link
Contributor Author

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant