PgHero VS HeidiSQL

PgHero Reviews

HeidiSQL Reviews

1. Mark-Mercer    

   self emloyed dba at Shatz | over 2 years ago
   very good and handy tool

   There was a need to work with the MS SQL database, but I did not want to install and understand the complex SQL Management Studio program, and this product turned out to be very easy to install and use. For more then 2 month i've used the tool haven't came across any issues.

   🏁 Competitors: SQL Server Management Studio

   👍 Pros:    Lightweight|Simple yet powerful and efficient tool|Many built-in features

   👎 Cons:    Nothing, so far

PgHero mentions (7)

• Show HN: PostgreSQL Index Advisor

  I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / 21 days ago

• What are your favourite approaches to keeping on top of Postgres health?

  I use either PgHero or Rails PG Extras on every project. Source: 10 months ago

• 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. Source: about 1 year ago

• How and why Relational Model works for databases

  I'm a huge supporter of PGhero (https://github.com/ankane/pghero) for this reason. Sometimes a single index is all that's required, but if DB design isn't your forte it's hard to know where to put it. - Source: Hacker News / over 2 years ago

• Check why Django app is slow in production

  If you are using PostgreSQL you can enable logging of slow queries and connect to the server with pghero (https://github.com/ankane/pghero) and check top queries by the number of requests and total usage time. Also, you can just enable logging of queries in Django, and on each request, you will have a list of queries on development, sometimes it's just a missing select_related of prefetch_related to increase... Source: over 2 years ago

HeidiSQL mentions (0)