Blog
Stay tuned with all pgModeler news
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.
The first release officially under the umbrella of Nullptr Labs.
The release of pgModeler 2.0.0-alpha1 marks an important evolution in the project’s history, signaling its official move under the professional banner of Nullptr Labs. This transition from a solo endeavor to a dedicated startup ensures the long-term sustainability of the tool we love, allowing for faster innovation and professional-grade support without losing our community-driven spirit. At the heart of this milestone is a complete modernization of the user experience. Every single object editing form has been redesigned with a clean, tabbed interface that simplifies complex database design, complemented by a brand-new code preview engine and an intuitive object associations viewer. Beyond the aesthetics, this version prioritizes workflow efficiency with smart keyboard navigation and a more robust command-line interface for modern DevOps pipelines. As we march toward the stable 2.0 release, we are also unveiling an ambitious roadmap for pgModeler Plus, which will soon feature native Git integration and AI-powered management tools. Our long-term vision is to introduce a dedicated AI modeling assistant, elevating pgModeler from a design tool to an intelligent engineering partner. This alpha release is more than just an update; it is an invitation to join us in this new chapter. Download the alpha, explore the changes, and let’s build the future of pgModeler together!
The beggining of a new era for the project.
The pgModeler 2.0.0-alpha release introduces significant improvements aimed at enhancing usability, flexibility, and maintainability. One of the most notable changes is the migration of the build system from qmake to CMake. The user interface has also received a major update. While still a work in progress, this alpha version introduces a refreshed logo, updated icon colors with a flatter and more colorful style, and the integration of the configuration form and core tools — diff, import, export, and fix — directly into the main window. The diff tool has been enhanced with a new model-to-model comparison mode, allowing offline comparisons between two loaded database models and generating the corresponding SQL diff for later application. Import and export tools have undergone similar refinements. Components have been reorganized for a cleaner interface, allowing users to freely choose which models to operate on, rather than being restricted to the active model. This ensures a smoother and more intuitive experience across all data handling operations. For more details, please read the full post; don't skip it!
Another round of UI improvements and a major codebase change.
Since the main focus of this release was to improve even more the UI, we had to work on the refactoring of the codebase to use Qt 6 which has lots of enhancements compared to the previous major version. So, after 2 months of work, pgModeler is now completely ported to Qt 6. So, attending to some requests, pgModeler received the ability to change the icon sizes to fit different screens in a better way. Still in the responsiveness subject and using the Qt 6 improved high DPI screens support, pgModeler allows the use of custom UI scale factors which adjust the entire user-interface rendering depending on the screen that the tool is running. Another enhancement that is worth mentioning here is that the columns/constraints propagation mechanism was completely rewritten which resulted in a noticeable performance gain and now solves an old problem of columns/constraints created by identifier relationships not being added or even disappearing in certain circumstances. More details on the full post.
The beginning of a new phase in the project's development
After four long months of working, we finally have the first alpha release of pgModeler 1.0! The main goal of this version was to boot up a series of deep improvements in the UI adding visual comfort while using the software. So that was done, this one brings redesigned UI elements and colors, a completely new icon set, and officially introduces the new project logo. As promised, pgModeler 1.0.0-alpha brings a responsive UI adapting the widget sizes and icons according to the screen's resolution. Also, we now have the support for color themes which can be toggled on-the-fly in the appearance settings. I'll explain more about what's new in the full post, don't miss it!