Our great sponsors
Intelligent search made easy
I run a large scale production application that does something along these lines. If the data needs to be close to real-time, I'd say use `searchkick` + Elasticsearch, and use `searchkick`'s async feature to "stream" the data from your table to the ES index. Your dashboard will then just query from the ES index via searchkick.
Versioned database views for Rails
If the data doesn't need to be close to real-time, and if your DB can handle a bit of load, I'd use a "batch" approach. To do this, I'd create a materialized view in your relational DB that you'd then refresh periodically. The easiest way to do this is with the `scenic` gem. Once you've done this, you can simply create a new model and set the `table_name` to the name of the materialized view, and then treat it as a regular model.
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
Full-text Search with Elasticsearch in Rails
9 projects | dev.to | 17 Aug 2022
Full Text Searching in a MySQL database via rails.
2 projects | /r/rails | 14 Mar 2022
Anyone using elasticsearch-rails? contingency plans?
1 project | /r/rails | 9 Aug 2021
Uniqueness validation does not work since the beginning of Ruby on Rails.
3 projects | dev.to | 4 Feb 2023
Database Views & Rails Active Record: defining new Model classes out of views
2 projects | dev.to | 23 Jan 2023