PgHero VS DBeaver

PgHero Reviews

DBeaver Reviews

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 / 11 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: 12 months 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

DBeaver mentions (93)

• I Deployed My Own Cute Lil’ Private Internet (a.k.a. VPC)

  It’s cool to show a demo and talk about the infrastructure with cute diagrams, but I always want to prove, even if just to myself, that things work as expected. So I thought a good way to test it would be to try connecting directly to both databases using my database client, DBeaver. - Source: dev.to / about 1 month ago

• DBeaver – open-source Database client

  List of db clients I have bookmarked https://dbeaver.io/. - Source: Hacker News / about 2 months ago

• 15 open-source tools to elevate your software design workflow

  As a great alternative to DBeaver, DBGate provides a variety of tools to manage your databases. Besides in built-in support charts and a query builder, you can use Javascript to query data. It even supports NoSQL drivers and native script builders. Give it a try if your project demands simplicity over in-depth features for SQL databases. - Source: dev.to / 3 months ago

• Five Free Open-Source Database Managers for MySQL, PostgreSQL, and More

  This isn’t meant to be an exhaustive list. There are many other database management software packages out there, including MySQL Workbench, DBeaver, and pgAdmin. We’ve chosen these database tools because they cover the most common database systems and use cases, but if you find they aren’t meeting your needs, be sure to explore further or consider building your own database user interface — it’s easier than you... - Source: dev.to / 3 months ago

• From Good to Great: Scaling Applications with TypeORM Optimization

  Tools like TablePlus, DBeaver, or HeidiSQL provide visual query building interfaces. While not performance analysis tools per se, they can help you build and understand complex queries more easily. - Source: dev.to / 6 months ago