Skip to main content

Blog

Stay tuned with all pgModeler news

pgModeler 2.0.0: The biggest release in the history of the project

Multi-scene, orthogonal relationships, a complete Git client and a whole new look

It took more than a year, one alpha, one alpha1, one beta, and one beta1, but pgModeler 2.0.0 is finally stable. This is the biggest release the project has ever had, with more than 850 commits since 1.2.3 alone, and this post tells the whole story from 1.2.3 to today. The headline feature is multi-scene support: a model can now split its canvas into scenes, by schema or by number of objects, so databases with thousands of tables stay fast to browse and edit. Relationships can now be drawn with orthogonal lines routed around the tables, the new default. The whole application was redesigned, from the logo and icons to a new theming engine, new fonts, and completely rebuilt editing forms, and the interface can finally be translated, shipping with 34 languages including Brazilian Portuguese. Import, Diff, Export, and Fix are now views of the main window. Diff can compare two models with no database at all. The SQL tool is more capable, PostgreSQL 18 temporal keys are supported, and SQL/XML generation is 50-70% faster on real-world models. A long list of crashes and memory leaks is gone, saved connection and SSH tunnel passwords are now encrypted, and a completely revisited user manual covers everyone from first-time users to plugin developers. pgModeler now comes in two editions: Community stays free and open-source, and Plus adds import, diff, the SQL tool, data handling, the database explorer, a complete Git client built right into the app, and a redesigned SSH tunnel plugin. There are a couple of things to know before upgrading, like the new foreign key naming pattern. Grab a coffee; this one is long, and I am proud of every line of it.

pgModeler 2.0.0-beta is here!

A new phase for PostgreSQL modeling

After months of development and refinement, we are proud to announce the release of pgModeler 2.0.0-beta — the most polished and mature pre-release version of the next generation of pgModeler so far. This release represents much more than a regular update. It marks an important milestone in the evolution of the platform, bringing significant usability improvements, better stability, a refreshed visual identity, and the beginning of a cleaner product structure built around the new Community and Plus editions. While version 2.0 continues to focus on PostgreSQL-first modeling and professional database workflows, this beta release puts special emphasis on something equally important: improving the day-to-day experience of developers, DBAs, architects, and teams that rely on pgModeler in real production environments.