Rails Erd VS Blazer

I've been using a simpler version of this https://github.com/voormedia/rails-erd but it seems neat that this comes with a web app and a query language.

Graphviz

Use the rails-erd gem to generate an ERD: http://voormedia.github.io/rails-erd/

Entity Relationship Diagrams (ERDs) are super useful for visualizing databases. For an ERD example, or to see how to make one, see this gem. Though note that gem is only for rails 3-5.

You should take a look at rails-erd, it is really easy to set up and works quite well

At my work we've got a 10-year-old Rails app (originally started as Rails 3), rake stats says we're now over 100kloc (non-test). We've got a huge amount of complexity and cross-dependencies (not to mention, probably-dead code), and the majority of our test suite runtime (about 40h non-parallelized) is in cucumber because developers can't get a clear view of the level of the app they're dealing with, and I suppose don't feel they can trust the lower layers of the application. Running rails-erd on it generates the very definition of spaghetti, it's gross.

This PR fix the build

I try to avoid these tools wherever possible, given the choice I'd always go for tools like Blazer.

https://github.com/ankane/blazer

No such luck in my current role, Looker and PowerBI are both in use by different bits of the org and nobody has the ability to delve into the underlying figures.

As u/jaxn said you could use Blazer for this kind of thing. I would also look into materialized views or custom tables and a scheduled job that calculates the metrics they care about. That will take you a long way. Eventually you can use something like Metabase but I would put that off for as long as possible as it's really expensive and pretty involved.

And it's Open Source: https://github.com/evidence-dev/evidence

I'd also highly recommend Blazer https://github.com/ankane/blazer if you are into the Ruby on Rails world. It's super solid, and it's been an indispensable tool integrated to all my projects.

I use Ahoy too, but I don't have very good visibility into the data. I should spend more time building queries and creating charts. I should probably set up blazer as well: https://github.com/ankane/blazer

blazer

The Blazer gem provides a nice way to analyze the results easily. It is simple to install and allows SQL queries to run against tables. The query here shows that the candidate implementation is significantly faster than the original.