Currently we use RLIKE to allow users search with regular expressions. However, nor SQLite nor Postgre support RLIKE operator. Although we have bigger problems with those 2, we still need to make some changes to the search with regexps.
Related Gerrit Patches:
|mediawiki/extensions/AbuseFilter : master||Use PHP regexps instead of SQL to filter results on Special:AbuseFilter|
|mediawiki/extensions/AbuseFilter : master||Use PHP regexps instead of SQL to filter on Special:AbuseFilter|
|mediawiki/extensions/AbuseFilter : master||Make patterns searching compatible with Postgres and SQLite|
|Open||None||T33279 Installer: extensions improvements: descriptions, alternatives, multiselection, configuration (tracking)|
|Open||None||T178349 Expand the set of bundled extensions and skins to achieve a default MediaWiki experience that's comparable to Wikimedia sites|
|Open||None||T232854 Expand the set of bundled extensions and skins in MediaWiki 1.35|
|Open||None||T191740 Bundle AbuseFilter extension with MediaWiki|
|Open||None||T199544 Make AbuseFilter work on PostgreSQL and SQLite (tracking)|
|Resolved||Daimona||T193068 Add support for SQLite and postgre when searching patterns|
@CPT I'd like to go with this one. The other AF patch should probably be abandoned, while I think the depends-on in core may still be valuable (I'm gonna open separate tasks for them if that's the case).