{"repo":"jonaspauleta/scout-postgres","free":true,"listed":false,"github":"https://github.com/jonaspauleta/scout-postgres","clone":"git clone https://github.com/jonaspauleta/scout-postgres.git","description":"Native Postgres full-text search + pg_trgm engine for Laravel Scout. Drop-in replacement for Meilisearch/Algolia/Typesense when you already run Postgres.","language":"PHP","stars":21,"topics":["fts","full-text-search","fuzzy-search","laravel","laravel-cloud","laravel-scout","neon","pg-trgm","php","postgres"],"license":"MIT","category":"databases-storage","readme_excerpt":"scout-postgres A Postgres-native Laravel Scout engine for apps that want search without running Meilisearch, Algolia, or Typesense. Targets the common 80% case when you already run Postgres — no extra service, no sync queue, no separate index. See Should I use this?, Comparison, and Limitations for the cases it does not cover. Works on any Postgres 14+ where pg trgm and unaccent are available — managed (Neon, Laravel Cloud, RDS, Supabase, DigitalOcean) or self-managed. Why Most Laravel apps already have Postgres. Adding Meilisearch or Typesense means another service to deploy, secure, monitor, scale, and keep in sync. For mid-sized catalogs (millions of rows, sub-100ms p95) Postgres FTS combined with pg trgm similarity is good enough, cheaper, and stays consistent with your source of truth — there is no separate index to drift out of sync. Head-to-head vs Scout's database driver 500k rows, hot cache, p50 over 30 runs. The database driver uses LIKE %term% — it seq-scans the table when no index matches. query pgsql p50 database p50 pgsql hits database hits ------------------ ------------: ---------------: -----------: --------------: modern history 5.4 ms 2100 ms 20 0 philosphy 45 ms 1989 ms 0 0 qwxzqwxzqwxz 8 ms 2068 ms 0 0 The first row is the most telling: FTS bridges token gaps and returns 20 results; database seq-scans all 500k rows and returns nothing. Full methodology and reproducible harness in /benchmarks. Should I use this? Use it when: - You already run Postgres and ","default_branch":null,"files":null,"tree":[],"storefront":"/r/jonaspauleta","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jonaspauleta/scout-postgres/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}