After almost four months, here we are announcing the first beta of 1.2.0! This indicates that this version already reached its final shape, and from now on, no new features will be introduced. I will work exclusively on fixing bugs and polishing the features until the stable version is ready. Below, two interesting new features will be described. For the complete set of changes in this version, please see the CHANGELOG.md file.

Relationships' FK columns indexes

Now, relationships that automatically create foreign key columns can also create indexes over those columns, which can speed up the modeling process a bit more. To enable an index over a foreign key column generated by a relationship, just select the indexing mode (a.k.a access method) in the tab Settings on the relationship dialog. Once applying the settings, the index will be automatically generated (see below). Like relationships, the generated indexes are named after a specific pattern, and the user has total control over the generated names in the relationship editing form or by defining a global name pattern under relationship settings.

Quick create constraints, indexes, and relationships

This feature, introduced through an exclusive plugin in the paid version of the tool, allows the creation of constraints, indexes, and relationships based on the objects selected in the design view without the need to open a single editing form or fill out many fields. The objects created also support name patterns, which can be configured in the plugin's settings menu in the main window.

Miscellaneous

• When the export, import, and diff processes finish, the taskbar blinks when the window is not visible.
• Added support for the total number of rows in the table being handled in the data handling form.
• Set new icons for tree widgets' collapse and expand actions.
• Updates on icons-*.conf files.
• Minor layout adjustment in the data handling form.
• Minor adjustment in the layers configuration widget to accept Enter/Return to apply settings.
• Fixed some shortcut conflicts in the main window.
• Minor fix in the "Open relationship" action in the design view.
• Fixed the index catalog queries when using pgModeler in compatibility mode (PG 9.x).
• Minor fix in buttons' drop shadows in data handling form.

Let's support pgModeler?

If you like the work being done to create a quality database design tool, please become our sponsor on GitHub. Any open-source project needs financial support to keep the development alive, and this is not different with pgModeler. Go ahead, be a supporter in one of the offered sponsor tiers, and receive rewards for being a friend of an open-source project! :D

Please don't forget to help to improve this project by reporting bugs or requesting new features on GitHub. Also, follow pgModeler on (X, Mastodon, Bluesky) or telegram channel @pgmodeler to stay up-to-date with the project latest news!

Finally, since we have reached the beta stage of 1.2.0, I'll be completely focused on its stable version. Thus, I'll diminish my work on pgModeler 1.1.x, which means that I'll be releasing only one more version (1.1.7) with the last set of bug fixes for that series.

Until next time! ;)