blazer

The fabulous blazer gem includes a feature for #2: https://github.com/ankane/blazer?tab=readme-ov-file#checks - it’s limited to checks that can be expressed as SQL queries, but that can get you quite a way

He's also done a ton outside the AI space: https://github.com/ankane/pretender makes it super easy to impersonate a different user in a rails app https://github.com/ankane/ahoy is first party analytics for rails https://github.com/ankane/blazer is BI built into rails https://github.com/ankane/field_test is A/B testing This kind of stuff is why rails is so productive for a normal web app. Sure, there are better vendor and point solutions for each of these, but the ability to drop in a gem, do some configuration and have a 80% solution lets you ship so. damn. fast.

And blazer[0], the closest thing to a perfect BI tool. It has a SQL editor/runner, saved queries, audit history, dashboards, alerts and user access control; all in a rails engine you can mount with minimal configuration. [0]https://github.com/ankane/blazer

I did some digging for you, I am not the best at Rails but from my understanding, it seems to throw the queries into ActiveRecords QueryAttribute using bind parameters [1]. So I'd say enough safe from sqli [2]. [1] https://github.com/ankane/blazer/blob/bd06aab33052783e84672b... [2] https://blog.saeloun.com/2019/10/28/bind-parameters-in-activ...

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.

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 It would be really nice if Ahoy came with a web UI that covered all the basics.

Blazer is my go-to for this kind of thing: https://github.com/ankane/blazer Pretty easy to set up and share queries, dashboards, whatever

Seems nice. And, if you are in the Ruby (on Rails) ecosystem, I can highly recommend Blazer https://github.com/ankane/blazer

If your app is already built with Rails, adding https://github.com/ankane/ahoy is pretty simple. Combine with https://github.com/ankane/blazer and you can build a reasonable set of reports as well. It's pretty simple to extend too: I've added basic client-side (JavaScript) error reporting on top of it, and I'm thinking about using it for Content Security Policy reporting too.

For those on Rails, do yourself a favor and add this great engine: https://github.com/ankane/blazer Life-changing!

Just to share for anyone interested in the Rails gems I'm using. An asynchronous worker manager is helpful for handling cron jobs, mail tasks, and various batch processes that can be loaded into memory (mostly Redis) but processed later. I use the gem Sidekiq which, as is, provides a UI and API that I rely heavily on. I might just not know the best practices, but I definitely find this valuable. The BI tools are not something found in most ecosystems. Not to mention dead simple setup. I use two gems, Ahoy and Blazer, which together provide a simple API for event tracking and saving database queries. [1]: https://sidekiq.org/ [2]: https://github.com/ankane/ahoy [3]: https://github.com/ankane/blazer

I'd add Blazer to your list too. Used it with great success and it meets your 4 criteria. https://github.com/ankane/blazer