tickets: 3254
This data as json
| id | created | changetime | last_pulled_from_trac | stage | status | component | type | severity | version | resolution | summary | description | owner | reporter | keywords | easy | has_patch | needs_better_patch | needs_tests | needs_docs | ui_ux |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3254 | 2007-01-08 19:12:47 | 2021-11-16 08:54:39 | 2022-03-06 03:28:14.095030 | Accepted | new | Database layer (models, ORM) | New feature | Normal | full text search support for postgres, oracle and mssql | I didn't like it was missing. oracle, mssql : add a !FulltextIndex for the Fields postgresql: for each !FulltextField add a extra tsvector Field named like `"%(fieldname)_tsv"` Problems with sqlite fts: * they stated a match statement may only be used once in a query * it needs a very specific syntax to search multiple fields * i have no idea how to get that into the ORM | Ronny Pfannschmidt | oracle fulltext search postgresql postgres mysql | 0 | 0 | 0 | 0 | 0 | 0 |