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.