Co-creator of Trek here. Trek generated migration files based on the diff between a pgModeler(1) schema definition and existing migration files. Trek also helps deploying those migrations. I’d be happy to respond to any questions here 🙂 1) https://pgmodeler.io/.
– Source: Hacker News
/
9 months ago
PgModeler is an open source tool that does diagramming as well as database management, including asking if you want to cascade when trying to drop tables. UI is a big quirky but once you get used to it, it’s very nice. I swear by it. https://pgmodeler.io.
Source:
about 2 years ago
Here is the one I have used in the past, https://pgmodeler.io/.
Source:
over 2 years ago
Is there free and open-source database/data modeling tools available? I am looking for a tool that covers both OLTP (normalized schema) and OLAP (dimensional/STAR schema) modeling. I only found https://pgmodeler.io but it is not fully free (a little fee is required to download).
Source:
over 2 years ago
Once you compile it for the first time and start using it, you’ll keep doing it again with each new version. I haven’t found a better Postgres tool yet. [0]: https://pgmodeler.io/.
– Source: Hacker News
/
almost 3 years ago
And maybe a tool to keep track of your data model, such as pgModeler – PostgreSQL Database Modeler or dbdiagram.io – Database Relationship Diagrams Design Tool.
Source:
over 3 years ago