divineomega/laravel-omega-search
Omega Search brings flexible, driver-based full-text search to Laravel. Make Eloquent models searchable, define indexed fields, and run ranked queries through a clean, unified API. Swap search backends without rewriting code—simple to configure, easy to extend, and built for real apps.
FIELD() ordering with a parameter-bound CASE removes a hard database dependency and should make staging/production parity easier across MySQL, SQLite, and other supported engines.CASE ordering is safer than raw FIELD() and uses bound parameters, but it can generate larger SQL statements when many IDs are ranked. The TPM should validate the maximum result-set size passed into Eloquent ordering, especially on SQLite where placeholder limits can be hit.CASE? Are lowest/current compatibility tests run against the exact Laravel, PHP, and database versions we operate?CASE is portable but less efficient than native database-specific ordering for very large ID lists. Keep search result limits bounded, monitor SQL size and latency, and avoid passing unbounded Omega Search result sets into Eloquent ordering.CASE expressions, misconfigured index/search credentials, and unexpected behavior on less-tested database engines. The empty-query change is a positive failure-mode improvement because no matches no longer degrade into a full-table exposure.How can I help you explore Laravel packages today?