Out-of-the-box Laravel Scout provides a database driver, but it is very limited. If you want to truly be able to search any data in MySQL or PostgreSQL then you'll need a search index table.
This package introduces an Eloquent model called SearchIndex. It will index the information set to be searched using Laravel Scout and there is no limitation, E.g. you could happily index and search on aggregate data.
composer require lunarphp/scout-database-engine
php artisan migrate- Eloquent model & migration
- GitHub Actions https://kirschbaumdevelopment.com/insights/laravel-github-actions
- Indexing
- Searching
- Pagination
- Where clauses
- Soft deletes
- Customisation
- Database table in config
- MySQL & PostgreSQL specific config