Based on our record, Flyway should be more popular than PgHero. It has been mentiond 57 times since March 2021. 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 / 12 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
Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows: https://flywaydb.org/ (Though I don't think it is "complete" or "perfect", either.) EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's... - Source: Hacker News / 11 days ago
When software starts using a database, it's advisable to have version control, just as we have Github to control our source code. This is all to be sure about what was executed for that specific version. For Java and Spring boot, we have the Flyway framework that aims to resolve this situation, free of charge. - Source: dev.to / 4 months ago
If you're looking for tools, like https://www.liquibase.com/ or https://flywaydb.org/, which are database-state-based schema migration toolkits - it might be relatively straightforward to build similar ones using Databricks SQL drivers. Source: 10 months ago
This is a 4th option, which should play nice with ArgoCD. The following example runs flyway as a k8s job. The desired migration changes are recorded as files within the chart. This helm chart can be integrated with your application (Using hooks to determine when the migration job is run) or run manually. Source: 11 months ago
By using an opinionated framework within the app/service (like Flyway, Migrate, Diesel, etc). Schema migrations happen on app/service start-up. Source: 11 months 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.
Liquibase - Database schema change management and release automation solution.
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.
Sequel Pro - MySQL database management for Mac OS X