Toll free (US) : +1 (888) 838-3532 | NYC: +1 (646) 491-6866

We might have heard about a lot many gems which let us implement search functionality in our rails application; for example: searchkick, elasticsearch-rails, ransack and finally, sunspot to work with solr search engine. All these gems have their own advantages. Both searchkick and elasticsearch use redis to search the data as well as need to perform a ‘reindex’ while inserting new data. In one of my recent projects, I happened to use a gem called as Textacular. It’s simple and very easy to use.

Textacular Gem:

It is a gem that provides full text search capabilities for PostgreSQL Database. It basically caters to extend the scope of the work performed by activerecord, in a rather friendly manner. It works on heroku as well.
This gem works only on PostgreSQL
For working with it, let’s first grab the latest textacular gem from and add it to the gemfile.

Textacular gem provides us with quite a few methods to search the data. So, all our models have the access to use those methods.



Basic_search: It searches based on the input text.

Advanced_search: Here, we can use postgres syntaxes like !, & and | (and, or and, not) and then, some others based on the requirement. It converts user’s search DSL into Pg syntax. For this, we need to make sure that the necessary exceptions should be used to handle the syntax errors.

These searches can be chainable as shown below:

We need to install pg_trgm module to work with fuzzy_search. Run the command below to install this module. It searches for partial appearance of your text in the DB.

Now, we are ready to use fuzzy_search.

By default, fuzzy search, searches for the records which are 30% of the search text matches with respect to the entire content. We can set this threshold limit by using the command below.

So, it expects 60% of search text to match with the original content.
We can use OR condition to search on multiple columns. Need to pass a hash with columns with input text as param one and pass second param as a false. It takes AND, if you miss second param or if it True.

By default, the Textacular searches in all text and string columns. We can alter its default behaviour by overriding the searchable_columns method in the model.

We can override self.searchable_language in the model to set proper dictionary settings.

Please check gem official documents for global search and more.


Pin It on Pinterest

Share This