PgHero
Blazer
PgHero | Blazer | |
---|---|---|
15 | 17 | |
8,410 | 4,648 | |
0.7% | 0.7% | |
7.3 | 8.9 | |
9 days ago | 9 days ago | |
Ruby | Ruby | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
PgHero
- PgAssistant: OSS tool to help devs understand and optimize PG performance
- PgHero: A Performance Dashboard for Postgres
-
How to Get the Most Out of Postgres Memory Settings
For our production PGSQL databases, we use a combination of PGTuner[0] to help estimate RAM requirements and PGHero[1] to get a live view of the running DB. Furthermore, we use ZFS with the built-in compression to save disk space. Together, these three utilities help keep our DBs running very well.
[0] https://pgtune.leopard.in.ua
[1] https://github.com/ankane/pghero
- PGHero: A Performance Dashboard for Postgres
-
Show HN: PostgreSQL Index Advisor
I am using https://github.com/ankane/pghero/ and this is one of its features with GUI
-
What are your favourite approaches to keeping on top of Postgres health?
I use either PgHero or Rails PG Extras on every project
-
Slow query. Should add indexes?
There are tools available which can look at your Postgres logs and tell you if you need to add indexes, I've used https://github.com/ankane/pghero before and it seems decent.
-
Is there something like sentry.io, for checking how long rails queries and functions take to execute?
https://github.com/ankane/pghero (open source equivalent to pganalyze)
-
railstart-niceadmin support more features
- [pghero](https://github.com/ankane/pghero)
-
railstart-niceadmin release now!Backend management system based on Bootstrap 5 and NiceAdmin and Rails 7
pghero
Blazer
- Blazer: Business Intelligence Made Simple
-
Is Tableau Dead?
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.
-
BI vs custom queries in app
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.
-
Evidence – Business Intelligence as Code
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.
-
Italian watchdog bans use of Google Analytics
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
-
My project: railstart app
blazer
- dashboard framework
-
Using Scientist to Refactor Critical Ruby on Rails Code
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.
- A Ruby-Powered Business Intelligence Tool
- Out of the Box CRUD Management Framework
What are some alternatives?
Database Cleaner - Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
Rails DB - Rails Database Viewer and SQL Query Runner
Scenic - Versioned database views for Rails
Foreigner - Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
Lol DBA - lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
Redis Dashboard - Sinatra app to monitor Redis servers.