PgHero
pgDash
pganalyze
Postgres Monitor
Font Awesome
BoxIcons
NewRelic
GetLoaf.io
Sqitch
Flyway
Liquibase
InterBase
Slick
DBmaestro
Redgate Deploy
DB Change Manager
PgHero SqitchNo Sqitch videos yet. You could help us improve this page by suggesting one.
Based on our record, Sqitch should be more popular than PgHero. It has been mentiond 17 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 / 20 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: about 1 year 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
We use https://sqitch.org/ and we’re fairly happy with it. Sqitch manages the files to deploy which are applied fits to a local database. We use GitHub actions for deployment and database migrations are just one step of the pipeline. The step invokes sqitch deploy which runs all the pending migration files. Then, all the approval process is standard for the environment. We require approvals in pull requests... - Source: Hacker News / 19 days ago
I'm experimenting with it right now using Squitch [1] to make maintenance easier. It still feels like a hack and I also still have my doubts about the viability of this for real-world use. It's fun though and I'm learning about all kinds of advanced Postgres features. [1] https://sqitch.org/. - Source: Hacker News / 5 months ago
How does it compare with other SQL-based migration tools like Sqitch? Source: about 1 year ago
Yup, same. Last time I set this up I used Sqitch¹ for migrations, which encourages you to write tests for each migration; caught a lot of bugs early that way, all in a local-first dev environment. Worked especially well for Postgres since plpgsql makes it easy to write tests more imperatively. ¹: https://sqitch.org/. - Source: Hacker News / over 1 year ago
Sqitch. DB migrations for multiple data stores without a proprietary syntax for DB updates. Git-aware. Integrated unit testing. Https://sqitch.org/ Https://youtu.be/wF4PEe8HD7k. Source: over 1 year 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
Liquibase - Database schema change management and release automation solution.
Postgres Monitor - A better way to monitor and debug your Postgres database. Real-time health dashboards, query insights, dynamic recommendations and more.
InterBase - InterBase is an ultra-fast, innovative, embeddable SQL database with commercial-grade data security, change synchronization, and disaster recovery options.
