search

pmatseykanets / laravel-scout-postgres

PostgreSQL Full Text Search Engine for Laravel Scout
MIT License
159 stars 36 forks source link

[WIP] Support Scout 9 and Laravel 9 #49

Open pmatseykanets opened 2 years ago

jaulz commented 2 years ago

@pmatseykanets any chance to merge this or https://github.com/pmatseykanets/laravel-scout-postgres/pull/47? 😊

RobertHR commented 2 years ago

@pmatseykanets any chance to merge this or #47? 😊

+1

BARNZ commented 2 years ago

I have just upgraded to scout 9 and it looks like it supports postgres straight out of the box. Seems this package is not needed anymore?

devNoiseConsulting commented 2 years ago

I have just upgraded to scout 9 and it looks like it supports postgres straight out of the box. Seems this package is not needed anymore?

From the Laravel Scout docs:

The database engine will use "where like" clauses and full text indexes when filtering results from your existing database to determine the applicable search results for your query.

The Scout 9 database support Is just creating some fancy SQL to find records in the model/table. I think using the new database driver is a good first step for searching in your app. This package allows you to make use of PostgreSQL's full text search which is a step up from the "where like" clauses. But you need to create a tsvector column and index it for your search. I need to search on multi million row tables and would prefer this package to the database driver.