Download pgModeler
Distributed in many flavours just pick yours
Distributed in many flavours just pick yours
pgModeler is open-source software, and you can get its source code anytime if you want to compile it by yourself. As a convenience, we provide compiled binary packages at a really fair price. Also, if you're interested in evaluating a binary package, you can get a demo copy before proceeding with the purchase. Since this is an independent project and without sponsorship, by buying any binary package you'll help keep the development active and at full speed!
Stable: 0.9.3
December 30, 2020
Changes since: v0.9.3-beta1
Summary: this was a long year of challenges, struggles, and concerns. Inevitably, the happenings during 2020 affected the development of pgModeler 0.9.3 but, fortunately, I've managed to deliver the stable release still in 2020 as I have promised months ago.
This last release of 0.9.3, as usual, brings only fixes for what was developed during the alpha and beta stages with minor new features.
The minor features introduced by this version is the inclusion of tables' check constraints in the data dictionaries generated by the exporting process. Another new functionality is the ability to select multiple relationships connected to a table by simply right clicking it and activating the "Select relationships" action.
The object finder was improved in such a way to allow to search objects in the database model using additional searching fields. Now it's possible to search relationships by the involved tables and foreign keys that represent them and constraints by their related columns.
The diff feature was properly patched and now can produce more precise results during partial diffs done from the database model's changelog.
There were other important fixes in several parts of the software. Some of them are related to crashes during the importing process or during object selection in database designing.
The data dictionary generation was also fixed in such a way to include default values of columns associated with sequences.
The command-line interface was not working properly in 0.9.3-beta1 by rejecting a certain combination of valid parameters. The bug was fixed and now it is running as expected.
The whole set of changes of this release (considering the alpha and beta stages) has 242 entries being 61 new features, 102 changes/improvements, and 79 bug fixes. Below, all the changes since 0.9.3-beta1, for the complete list of changes on the entire development timeline, please, take a look into the CHANGELOG.md.
* [New] Added support to deterministic and provider attributes in collations. * [New] Added missing check constraints in the data dictionary. * [New] Added support to selecting all relationships of a table at once via right-click on a table > select relationships. * [New] Added extra search fields in ObjectFinderWidget. Now it's possible to search relationships by the involved tables (source and destination table), constraints by their columns (source and referenced columns), and relationships by the foreign keys related to them. * [Change] The warning message about the unchecked option related to drop missing objects now pops up only when there are partial diff filters configured. * [Change] Improved the extended fade in/out options for tables/views/foreign tables. * [Change] The partial diff filters generated from changelog will ignore table children objects in order to avoid the wrong generation of diff code. * [Change] Minor refactoring in DatabaseModel::addChangelogEntry in order to use new attributes to define changelog operations. * [Fix] Fixed a crash when trying to select children objects of a schema that has no rectangle defined. * [Fix] Fixed a crash during the importing of domain objects. * [Fix] Fixed a crash during the importing of objects into the current model in very specific cases when the model had some tables/views referencing columns added by relationship. * [Fix] Fixed the full diff switching when there are no filtered objects in ModelDatabaseDiffForm. * [Fix] Fixed a bug in DatabaseModel::addChangelogEntry that was causing the registration of empty signature for some objects. * [Fix] Fixed a bug in CLI that was not accepting the use of --list-conns parameter * [Fix] Fixed the data dictionary generation in such a way to include nextval(sequence) calls in the "default value" column. * [Fix] Fixed a bug when configuring spatial data types during reverse engineering/diff. * [Fix] Fixed a bug in Catalog::parseDefaultValues that was causing ARRAY[] values to be wrongly split. * [Fix] Fixed a bug that was causing infinite validation of imported sequences.
Summary: this was a long year of challenges, struggles, and concerns. Inevitably, the happenings during 2020 affected the development of pgModeler 0.9.3 but, fortunately, I've managed to deliver the stable release still in 2020 as I have promised months ago.
This last release of 0.9.3, as usual, brings only fixes for what was developed during the alpha and beta stages with minor new features.
The minor features introduced by this version is the inclusion of tables' check constraints in the data dictionaries generated by the exporting process. Another new functionality is the ability to select multiple relationships connected to a table by simply right clicking it and activating the "Select relationships" action.
The object finder was improved in such a way to allow to search objects in the database model using additional searching fields. Now it's possible to search relationships by the involved tables and foreign keys that represent them and constraints by their related columns.
The diff feature was properly patched and now can produce more precise results during partial diffs done from the database model's changelog.
There were other important fixes in several parts of the software. Some of them are related to crashes during the importing process or during object selection in database designing.
The data dictionary generation was also fixed in such a way to include default values of columns associated with sequences.
The command-line interface was not working properly in 0.9.3-beta1 by rejecting a certain combination of valid parameters. The bug was fixed and now it is running as expected.
The whole set of changes of this release (considering the alpha and beta stages) has 242 entries being 61 new features, 102 changes/improvements, and 79 bug fixes. Below, all the changes since 0.9.3-beta1, for the complete list of changes on the entire development timeline, please, take a look into the CHANGELOG.md.
* [New] Added support to deterministic and provider attributes in collations. * [New] Added missing check constraints in the data dictionary. * [New] Added support to selecting all relationships of a table at once via right-click on a table > select relationships. * [New] Added extra search fields in ObjectFinderWidget. Now it's possible to search relationships by the involved tables (source and destination table), constraints by their columns (source and referenced columns), and relationships by the foreign keys related to them. * [Change] The warning message about the unchecked option related to drop missing objects now pops up only when there are partial diff filters configured. * [Change] Improved the extended fade in/out options for tables/views/foreign tables. * [Change] The partial diff filters generated from changelog will ignore table children objects in order to avoid the wrong generation of diff code. * [Change] Minor refactoring in DatabaseModel::addChangelogEntry in order to use new attributes to define changelog operations. * [Fix] Fixed a crash when trying to select children objects of a schema that has no rectangle defined. * [Fix] Fixed a crash during the importing of domain objects. * [Fix] Fixed a crash during the importing of objects into the current model in very specific cases when the model had some tables/views referencing columns added by relationship. * [Fix] Fixed the full diff switching when there are no filtered objects in ModelDatabaseDiffForm. * [Fix] Fixed a bug in DatabaseModel::addChangelogEntry that was causing the registration of empty signature for some objects. * [Fix] Fixed a bug in CLI that was not accepting the use of --list-conns parameter * [Fix] Fixed the data dictionary generation in such a way to include nextval(sequence) calls in the "default value" column. * [Fix] Fixed a bug when configuring spatial data types during reverse engineering/diff. * [Fix] Fixed a bug in Catalog::parseDefaultValues that was causing ARRAY[] values to be wrongly split. * [Fix] Fixed a bug that was causing infinite validation of imported sequences.
Develop: 0.9.4-beta
September 20, 2021
Changes since: v0.9.4-alpha1
Attention: the database model file structure has changed since the last stable 0.9.3. Models created in older releases will certainly fail to load due to incompatibilities because some attributes in the XML code don't exist anymore or have changed during the development of 0.9.4-beta. Before loading your database models in this new release, please, make sure to have a backup of them all and follow the steps presented by the model fix tool to patch the documents' structure. Not paying attention to this situation may cause irreversible data loss! If the fix procedures aren't enough to make your database models loadable again, please, ask for help at the official support channels!
Summary: this version took a bit more to be released than expected but it's finally here. As with any other beta version, this one brings few new features since it is more focused on polishing all that was made on alpha stages in preparation for the stable version.
One new feature brought is the ability to generate GRANT and REVOKE commands to setup new role memberships through the diff process. Another addition is the support for included columns also known as non-key columns on indexes.
Due to that improvement on diff, the original behavior of "Member of" tab on the role editing form was changed in such a way to make the code generated from the comparison between two roles more precise.
This release also brings several improvements in the database design process. For example, the default match mode for FK constraints was changed to MATCH SIMPLE in compliance with the PostgreSQL docs. The layers feature was also patched and now the layers rectangles are correctly updated in certain circumstances.
Now, in the database browser in SQL tool, the tree items collapse state is saved and restored after any updates requested by the user, improving the overall experience on that module.
Finally, the whole set of changes of this release has 50 entries being 12 new features, 24 changes/improvements, and 14 bug fixes. Below, some key changes are highlighted. For the complete list of changes, please, take a look at the CHANGELOG.md.
* [New] Added support for the generation of GRANT/REVOKE commands to control roles memberships via diff process. * [New] Added a fix step to reconfigure roles membership considering the deprecation of Role:RefRole attribute. * [New] Added support for included columns on indexes. * [New] Added the ability for referencing view columns on indexes. * [New] Added support for toggling update notifications for alpha/beta versions. * [New] Added support for save and restore the tree state in DatabaseExplorerWidget. * [Change] Dropped the support for MemberOf (Role::RefRoles) in order to make the diff between two roles more precise. * [Change] In RoleWidget the tab "Member Of" now works only as a convenience feature that adds the role being edited to the ones listed in that tab. * [Change] Restored the file pgmodeler.appdata.xml. * [Change] Allowing swap cluster level object ids in SwapObjectsIdsWidget when the objects are of the same kind. * [Change] Improvements in pgmodeler-se in such a way to control syntax highlighting settings per open editor. * [Change] Avoided the use of a working dir in .desktop file when installing mime types system-wide. * [Change] Improved the way layers rectangles are updated after undoing/redoing operations in OperationListWidget. * [Change] Changed the default match type in foreign key constraint to MATCH SIMPLE. * [Change] Minor adjustment in the ModelWidget::updateSceneLayers in order to force the update of all schemas. * [Change] Exceptions raised in BugReportForm when the "lastmodel" file isn't found are now ignored. * [Change] Minor change in ModelValidationHelper in order to use table's signature instead of name during name validation process. * [Fix] Fixed a crash in diff process caused by the ModelExportHelper instance when canceling the export to DBMS when an exception was raised. * [Fix] Fixed a crash in SwapObjectsIdsWidget when the user tried to swap objects using arrow keys. * [Fix] Minor fix in DatabaseExplorerWidget in order to display view's children source code. * [Fix] Fixed the building of IndexWidget on Qt 5.14 and below. * [Fix] Fixed the problem on ModelDatabaseDiffForm that was not accepting pressing Return/Esc to respectively run the diff and close the dialog due to a conflict with the event loop instance in ModelDatabaseDiffForm::exec(). * [Fix] Minor fix in the configuration of ObjectGroupId element in DatabaseImportForm::updateObjectsTree in order to avoid crashes when no root element is specified. * [Fix] Fixed the generation of aggregate functions when they use functions that contain parameters in which data type have spaces (double precision, character varying). * [Fix] Fixed a segfault that can happen when changing the number of parameters of a function already associated with an aggregate. * [Fix] Additional fix for layers not being correctly loaded from dbm file.
Attention: the database model file structure has changed since the last stable 0.9.3. Models created in older releases will certainly fail to load due to incompatibilities because some attributes in the XML code don't exist anymore or have changed during the development of 0.9.4-beta. Before loading your database models in this new release, please, make sure to have a backup of them all and follow the steps presented by the model fix tool to patch the documents' structure. Not paying attention to this situation may cause irreversible data loss! If the fix procedures aren't enough to make your database models loadable again, please, ask for help at the official support channels!
Summary: this version took a bit more to be released than expected but it's finally here. As with any other beta version, this one brings few new features since it is more focused on polishing all that was made on alpha stages in preparation for the stable version.
One new feature brought is the ability to generate GRANT and REVOKE commands to setup new role memberships through the diff process. Another addition is the support for included columns also known as non-key columns on indexes.
Due to that improvement on diff, the original behavior of "Member of" tab on the role editing form was changed in such a way to make the code generated from the comparison between two roles more precise.
This release also brings several improvements in the database design process. For example, the default match mode for FK constraints was changed to MATCH SIMPLE in compliance with the PostgreSQL docs. The layers feature was also patched and now the layers rectangles are correctly updated in certain circumstances.
Now, in the database browser in SQL tool, the tree items collapse state is saved and restored after any updates requested by the user, improving the overall experience on that module.
Finally, the whole set of changes of this release has 50 entries being 12 new features, 24 changes/improvements, and 14 bug fixes. Below, some key changes are highlighted. For the complete list of changes, please, take a look at the CHANGELOG.md.
* [New] Added support for the generation of GRANT/REVOKE commands to control roles memberships via diff process. * [New] Added a fix step to reconfigure roles membership considering the deprecation of Role:RefRole attribute. * [New] Added support for included columns on indexes. * [New] Added the ability for referencing view columns on indexes. * [New] Added support for toggling update notifications for alpha/beta versions. * [New] Added support for save and restore the tree state in DatabaseExplorerWidget. * [Change] Dropped the support for MemberOf (Role::RefRoles) in order to make the diff between two roles more precise. * [Change] In RoleWidget the tab "Member Of" now works only as a convenience feature that adds the role being edited to the ones listed in that tab. * [Change] Restored the file pgmodeler.appdata.xml. * [Change] Allowing swap cluster level object ids in SwapObjectsIdsWidget when the objects are of the same kind. * [Change] Improvements in pgmodeler-se in such a way to control syntax highlighting settings per open editor. * [Change] Avoided the use of a working dir in .desktop file when installing mime types system-wide. * [Change] Improved the way layers rectangles are updated after undoing/redoing operations in OperationListWidget. * [Change] Changed the default match type in foreign key constraint to MATCH SIMPLE. * [Change] Minor adjustment in the ModelWidget::updateSceneLayers in order to force the update of all schemas. * [Change] Exceptions raised in BugReportForm when the "lastmodel" file isn't found are now ignored. * [Change] Minor change in ModelValidationHelper in order to use table's signature instead of name during name validation process. * [Fix] Fixed a crash in diff process caused by the ModelExportHelper instance when canceling the export to DBMS when an exception was raised. * [Fix] Fixed a crash in SwapObjectsIdsWidget when the user tried to swap objects using arrow keys. * [Fix] Minor fix in DatabaseExplorerWidget in order to display view's children source code. * [Fix] Fixed the building of IndexWidget on Qt 5.14 and below. * [Fix] Fixed the problem on ModelDatabaseDiffForm that was not accepting pressing Return/Esc to respectively run the diff and close the dialog due to a conflict with the event loop instance in ModelDatabaseDiffForm::exec(). * [Fix] Minor fix in the configuration of ObjectGroupId element in DatabaseImportForm::updateObjectsTree in order to avoid crashes when no root element is specified. * [Fix] Fixed the generation of aggregate functions when they use functions that contain parameters in which data type have spaces (double precision, character varying). * [Fix] Fixed a segfault that can happen when changing the number of parameters of a function already associated with an aggregate. * [Fix] Additional fix for layers not being correctly loaded from dbm file.
Purchase
Purchase an access key and support this project. Pay using PayPal™, Stripe™, or Bitcoins and enjoy ready-to-use packages.
Download
Get the binary packages by using an access key previously purchased.
Source
If you want to compile pgModeler by yourself, you can grab the source code from the official repository.
Preparing your
payment, please wait...
Do not close the page or cancel the loading!
Do not close the page or cancel the loading!