georgolden commented 2 years ago

Is your feature request related to a problem? Please describe.

We need to create a simple way to create full text search indexes and handle search queries within the fields.

Solution

We can start by simple implementation of GIN index. https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX

To-Do

clone this repo, run a container or standalone Postgres instance, setup database
```
git clone git@github.com:metarhia/metasql.git
cd metasql
npm ci
cd db
```

optional

sh docker.sh

sh setup.sh npm t



- implement tests and queries for text-search use cases

This issue is a general, we need to contribute more to this issue as well. @nechaido @tshemsedinov

georgolden commented 2 years ago

https://www.postgresql.org/docs/current/textsearch.html

tshemsedinov commented 2 years ago

@vmkul Please accept invitation to assign for this issue

metarhia / metasql

Full text search support out of box #246

optional