a0f72fe5c6
Avoid ordering just by a timestamp
...
Try to also employ an id when possible.
Involves reworking some of the indices.
2021-07-16 19:44:41 +01:00
86826a1a68
[SEARCH][PostgreSQL] Make LIKE search case-insensitive
2021-07-16 19:44:40 +01:00
c11629035b
[SEARCH][MariaDB] Change user-facing fulltext search syntax
...
Now analogous to the simple and safe PostgreSQL's websearch_to_tsquery syntax.
MariaDB's full-text boolean search queries will fail on input such as "@user"
(unquoted) which is particularly noticeable to the user.
2021-07-16 19:44:40 +01:00
2d6e4e3912
[SEARCH] Exclude message scope
2021-07-16 19:44:40 +01:00
974404bcfd
[DATABASE][PostgreSQL] Add fulltext search support
2021-07-16 19:44:40 +01:00
16b5ddd230
[DATABASE] Re-introduce PostgreSQL support
2021-07-16 19:44:35 +01:00
e807e3bf08
[DATABASE] Use "<>" as an SQL non-equality sign
...
"!=" is not SQL compliant.
2021-07-16 19:44:35 +01:00
6095a6de64
[DATABASE] Only use single quotation marks for SQL strings
...
Double quotation marks are only used for identifiers in the SQL standard.
2021-07-16 19:44:35 +01:00
ab3e8ce21d
[LIB_REFACTOR] Fix requires
2021-07-16 19:44:34 +01:00
2ab2e22a36
[LIB_REFACTOR] Moving files into separate semantic categories
2021-07-16 19:44:34 +01:00
Alexei Sorokin
Miguel Dantas