mgdigital 6358b27bc6 Search query string rework (#96) ...

- `search_string` field is removed
- text search vector for `content` and `torrent_contents` is generated in code with improvements in normalisation and tokenisation
- the slow `LIKE` query is removed from text search
- a query DSL is implemented which translates the input search string to a Postgres tsquery
- a CLI command (`reindex`) is provided for updating the tsv for pre-existing records
- the unused `tsv` and `search_string` fields are removed from the `torrents` table

See https://github.com/bitmagnet-io/bitmagnet/issues/89

2024-01-07 11:51:40 +00:00

..

00001_init.sql

Initial commit (#1)

2023-10-04 21:04:26 +01:00

00002_files_status.sql

Add files_status field and dht_crawler.files_threshold configuration parameter (#9)

2023-10-05 15:17:16 +01:00

00003_tags.sql

Torrent tagging (#60)

2023-11-24 07:28:50 +00:00

00004_indexes.sql

Add indexes (#74)

2023-11-24 12:20:38 +00:00

00005_bloom_filters.sql

Deletion (#75)

2023-11-28 17:54:49 +00:00

00006_tsv.sql

Search query string rework (#96)

2024-01-07 11:51:40 +00:00

migrations.go

Initial commit (#1)

2023-10-04 21:04:26 +01:00