Many web applications include tables or grids of data that can be searched, sorted, filtered and paginated. There are some patterns and tools we have found useful when implementing data grids. Ransack helps create advanced search forms using predicates and search matchers which can be encoded directly into URL params. With some front-end interactivity, it's possible to build a multi-model, multi-attribute, filterable search.
Data grids include pagination and for that we have found Kaminari to work. Another gem for full text search in PostgreSQL is pg_search.
When dealing with nested associations or other complex joins, a database view makes implementing data grids easier. Scenic makes it possible to create SQL views and update them using migrations.
All of these tools work well with each other so we mix and match as needed.
Encoding search params in URLs allows discoverability, shareability, and extensibility.
🟥 Bad
<%= search_form_for @q, html: { method: :post } do |f| %>🟩 Good
<%= search_form_for @q do |f| %>Note that there is an advanced mode that may require use of HTTP POST because queries could exceed the character limits of URLs.