Popularity

9.5

Growing

Activity

0.0

Stars 7,136

Watchers 91

Forks 414

Last Commit 16 days ago

Description

PgHero is a ruby gem that gives you insights of your PostgreSQL database. Out of the box it provides info about stuff like cache hit rate, which queries are too slow, which tables need indexes, and more.

Code Quality Rank: L4

Monthly Downloads: 226,912

Programming language: Ruby

License: MIT License

Tags: Database Tools Projects

Latest version: v3.0.0

PgHero alternatives and similar gems

Based on the "Database Tools" category.
Alternatively, view PgHero alternatives based on common mentions on social networks and blogs.

Blazer

8.8 0.0 PgHero VS Blazer

Business intelligence made simple
Database Cleaner

8.5 0.0 L5 PgHero VS Database Cleaner

Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.

Updating dependencies is time-consuming.

Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.

Promo blog.mergify.com

Scenic

8.4 5.3 L5 PgHero VS Scenic

Versioned database views for Rails
Large Hadron Migrator

7.8 0.0 L5 PgHero VS Large Hadron Migrator

Online MySQL schema migrations
Seed dump

7.0 0.0 L5 PgHero VS Seed dump

Rails 4/5 task to dump your data to db/seeds.rb
Rails DB

6.7 0.0 L5 PgHero VS Rails DB

Rails Database Viewer and SQL Query Runner
Lol DBA

6.6 0.0 L5 PgHero VS 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.
Foreigner

6.5 0.0 L5 PgHero VS Foreigner

Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
Active Record Doctor

6.5 0.0 PgHero VS Active Record Doctor

Identify database issues before they hit production.
Squasher

6.4 0.0 PgHero VS Squasher

Squasher - squash your old migrations in a single command
Seed Fu

6.4 0.0 L5 PgHero VS Seed Fu

Advanced seed data handling for Rails, combining the best practices of several methods together.
Seedbank

6.2 0.0 L5 PgHero VS Seedbank

Seedbank gives your seed data a little structure. Create seeds for each environment, share seeds between environments and specify dependencies to load your seeds in order. All nicely integrated with simple rake tasks.
BatchLoader

5.7 0.0 PgHero VS BatchLoader

:zap: Powerful tool for avoiding N+1 DB or HTTP queries
DatabaseConsistency

5.5 0.0 PgHero VS DatabaseConsistency

The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
SchemaPlus

5.3 0.0 L4 PgHero VS SchemaPlus

SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
Polo

5.3 0.0 L5 PgHero VS Polo

Polo travels through your database and creates sample snapshots so you can work with real world data in development.
Upsert

5.1 0.0 L5 PgHero VS Upsert

Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
DatabaseValidations

5.1 0.0 PgHero VS DatabaseValidations

Database validations for ActiveRecord
SecondBase

4.2 0.0 L5 PgHero VS SecondBase

Seamless second database integration for Rails.
OnlineMigrations

4.1 0.0 PgHero VS OnlineMigrations

Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).
FastPage

3.3 0.0 PgHero VS FastPage

Blazing fast pagination for ActiveRecord with deferred joins ⚡️
QueryTrack

3.2 0.0 PgHero VS QueryTrack

Find time-consuming database queries for ActiveRecord-based Rails Apps
Shiba

3.1 0.0 PgHero VS Shiba

Catch bad SQL queries before they cause problems in production
Redis Dashboard

2.5 0.0 PgHero VS Redis Dashboard

Sinatra app to monitor Redis servers.
Ruby Whatsapp SDK

2.3 0.0 PgHero VS Ruby Whatsapp SDK

Empower your communication with Whatsapp using our Ruby-based Cloud API and SDK. With our easy-to-use Whatsapp API, you can quickly create custom bots and streamline messaging. Get started today and see the difference in your communication process.
Ruby PG Extras

2.2 0.0 PgHero VS Ruby PG Extras

Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
Nullalign

1.5 0.0 PgHero VS Nullalign

Finds missing non-null constraints
PgDriveBackup

1.3 0.0 PgHero VS PgDriveBackup

Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API
Slack Smart Bot

1.1 10.0 PgHero VS Slack Smart Bot

Create a Slack bot that is smart and so easy to expand, create new bots on demand, run ruby code on chat, create shortcuts... The main scope of this gem is to be used internally in the company so teams can create team channels with their own bot to help them on their daily work, almost everything is suitable to be automated!! slack-smart-bot can create bots on demand, create shortcuts, run ruby code... just on a chat channel. You can access it just from your mobile phone if you want and run those tests you forgot to run, get the results, restart a server... no limits.
ActiveRecord Setops

1.0 0.0 PgHero VS ActiveRecord Setops

Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
Perfect Shape

1.0 0.0 PgHero VS Perfect Shape

Perfect Shape is a collection of geometric algorithms that are mostly useful for GUI manipulation like checking containment of a point in popular geometric shapes such as rectangle, square, arc, circle, polygon, and paths containing lines, quadratic bézier curves, and cubic bezier curves. Also, some general math algorithms like IEEE-754 Remainder.
ocran

1.0 10.0 PgHero VS ocran

One-Click Ruby Application Builder
PgDice

0.8 0.0 PgHero VS PgDice

Postgres partitioning built on top of https://github.com/ankane/pgslice
ActiveRecord::DataIntegrity

0.7 0.0 PgHero VS ActiveRecord::DataIntegrity

Check data integrity for your ActiveRecord models
Rapidity

0.6 0.0 PgHero VS Rapidity

Simple but fast Redis-backed distributed rate limiter. Allows you to specify time interval and count within to limit distributed operations.
SlackHook

0.6 0.0 PgHero VS SlackHook

A Simple Interface to Slack Incoming Webhooks Integrations
bundler-download

0.4 0.0 PgHero VS bundler-download

Bundler plugin for auto-downloading specified extra files after gem install