PgHero might be a bit more popular than Liquibase. We know about 7 links to it since March 2021 and only 5 links to Liquibase. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / 9 days ago
I use either PgHero or Rails PG Extras on every project. Source: 10 months ago
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
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
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
As far as keeping track of domain changes you can store DDL files in version control like you mention or use tools like Flyway (https://flywaydb.org) or Liquidbase (https://liquibase.org) which takes care of database migrations. Source: about 2 years ago
I just use SQL directly (or something like JOOQ). For database migrations I use Liquibase. Source: about 2 years ago
Regarding the migrations, there are tools such as https://liquibase.org/ or FlyAway that handle this. Heck, you can even use an ORM that has a migration baked-in but that defeats the purpose of having the migrations in a separate project. Source: about 2 years ago
I've trialled schemachange and liquibase which are change script based tools. I've ruled out a whole load of other tools that are either change script based tools or don't support Snowflake, including the following:. Source: about 2 years ago
Nowadays I prefer to automate database updates and deployment, using Liquibase and its relational database vendor agnostic syntax for that. Especially on production systems. But on local dev environments, I can still use the occasional SQL in a pinch. Source: over 2 years ago
pgDash - pgDash is a comprehensive monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
Flyway - Flyway is a database migration tool.
pganalyze - PostgreSQL performance monitoring installed within minutes
Slick - A jquery plugin for creating slideshows and carousels into your webpage.
Postgres Monitor - A better way to monitor and debug your Postgres database. Real-time health dashboards, query insights, dynamic recommendations and more.
Sqitch - Sqitch is a standalone database change management application without opinions about your database engine, development environment, or application framework.