Casecommons/pg_search

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

1575 stars · 381 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pg_search is a Ruby gem that adds ActiveRecord named scopes leveraging PostgreSQL's built-in full text search, including tsearch, trigram, and metaphone features. It also offers a multisearchable global index for searching across multiple models, letting Rails applications implement search without an external engine like Elasticsearch.

Use cases

• add full text search to a Rails ActiveRecord model
• search across multiple models with one global query
• implement trigram similarity search in PostgreSQL
• rank and weight search results across model columns
• avoid running Elasticsearch or Solr for app search
• add fuzzy name matching with metaphone or trigrams

When to choose

• your app uses Ruby on Rails or ActiveRecord with a PostgreSQL database
• you want search scoped naturally into ActiveRecord query chains
• you prefer keeping search inside PostgreSQL instead of operating a separate search server
• you need multi-model search via a single indexed table

When to avoid

• your database is MySQL, SQLite, or anything other than PostgreSQL
• your project is not Ruby or does not use ActiveRecord
• you need massive-scale distributed search, faceting, or advanced analytics better served by Elasticsearch or Solr
• you need language features or typo tolerance beyond what PostgreSQL full text search and trigrams provide

Facets

library · maturity active

search-engine orm database databases backend web-development ruby postgresql full-text-search activerecord rails trigram tsearch metaphone multisearch ruby-gem search

Member repositories

For agents

markdown · JSON · MCP: product_card(name="Casecommons/pg_search")