Download pgModeler
Distributed in many flavours just pick yours
Distributed in many flavours just pick yours
pgModeler is an 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 by ordering any binary package you'll help to keep its development alive and at full speed!
Stable: 0.9.2
December 26, 2019
Changes since: v0.9.2-beta2
Summary: this is the end of a long development cycle that started still in May, 2018 when the stable 0.9.1 was released. This one is composed by 84 new features, 134 fixes and 146 changes in total.
This release was intended to be just a fine tuning of what was constructed in alpha and beta versions and it only includes new relavant feature included specifically to generate data dictionaries in HTML format from database models.
This was a request from many users that needed an extra form of documenting their databases. Data dictionary generation feature is still considered experimental despite of being a relatively simple functionality. So, there's always room for improvements.
Finally, the changes of this version are detailed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Add support to data dictionaries generation in HTML format in ModelExportForm. * [New] Added options to control data dictionary generation in CLI. * [New] Plugins now can optionally be associated to a menu action or not. Generally, an plugin not associated to a menu action is automatilly executed during the startup (see PgModelerPlugin::initPlugin). * [Change] Making BaseRelationship::getReferenceForeignKey() public. * [Change] Isolated duplicated code in MainWindow::isToolButtonsChecked that checks if any tool button of the bottom or right widget bars is checked. * [Change] Removing the plugins from core code. * [Change] Modified pgmodeler.pro to include plugins folder when present in the source root (either in debug or release mode). * [Change] Ignoring plugins folder in the core code. * [Change] Minor improvement on ModelWidget::rearrangeSchemasInGrid in order to consider the amount of tables to determine the minimum grid size used to rearrange table. * [Change] Minor text adjustments in CLI. * [Change] Added an additional checking during relationship creation in order to avoid the creation of 1-* or n-n relationships involving partition tables. * [Change] Removing the restriction to create 1-1, 1-n and n-n relationships in which the involved tables are partitioned ones. * [Change] Disabling the SQL statment ALTER...OWNER TO in the object's SQL when the owner role has its SQL disabled but the object itself not. This will avoid reference errors when validating/exporting code. * [Fix] Fixed the "Save" action enabled state according to the current model's modified state. * [Fix] Fixed a crash when the user tried to edit connections in ModelDatabaseDiffForm and right after select a connection in the "Compare to" field. * [Fix] Fixed the generation of escaped comments for columns.
Summary: this is the end of a long development cycle that started still in May, 2018 when the stable 0.9.1 was released. This one is composed by 84 new features, 134 fixes and 146 changes in total.
This release was intended to be just a fine tuning of what was constructed in alpha and beta versions and it only includes new relavant feature included specifically to generate data dictionaries in HTML format from database models.
This was a request from many users that needed an extra form of documenting their databases. Data dictionary generation feature is still considered experimental despite of being a relatively simple functionality. So, there's always room for improvements.
Finally, the changes of this version are detailed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Add support to data dictionaries generation in HTML format in ModelExportForm. * [New] Added options to control data dictionary generation in CLI. * [New] Plugins now can optionally be associated to a menu action or not. Generally, an plugin not associated to a menu action is automatilly executed during the startup (see PgModelerPlugin::initPlugin). * [Change] Making BaseRelationship::getReferenceForeignKey() public. * [Change] Isolated duplicated code in MainWindow::isToolButtonsChecked that checks if any tool button of the bottom or right widget bars is checked. * [Change] Removing the plugins from core code. * [Change] Modified pgmodeler.pro to include plugins folder when present in the source root (either in debug or release mode). * [Change] Ignoring plugins folder in the core code. * [Change] Minor improvement on ModelWidget::rearrangeSchemasInGrid in order to consider the amount of tables to determine the minimum grid size used to rearrange table. * [Change] Minor text adjustments in CLI. * [Change] Added an additional checking during relationship creation in order to avoid the creation of 1-* or n-n relationships involving partition tables. * [Change] Removing the restriction to create 1-1, 1-n and n-n relationships in which the involved tables are partitioned ones. * [Change] Disabling the SQL statment ALTER...OWNER TO in the object's SQL when the owner role has its SQL disabled but the object itself not. This will avoid reference errors when validating/exporting code. * [Fix] Fixed the "Save" action enabled state according to the current model's modified state. * [Fix] Fixed a crash when the user tried to edit connections in ModelDatabaseDiffForm and right after select a connection in the "Compare to" field. * [Fix] Fixed the generation of escaped comments for columns.
Develop: 0.9.3-beta
July 10, 2020
Changes since: v0.9.3-alpha1
Summary: here we are again bringing another round of improvements to pgModeler. This release basically enhances what has been done in 0.9.3-alpha1 plus bringing an important experimental feature: the partial diff.
After a entire month exclusively dedicated to the partial diff implementation we finally have something usable. This feature consists in taking an input database or model, apply user-provided filters and diminishing the amount of objects to be compared. This brings a significant gain of speed in the process because only a subset of the database/model will be handled.
In order to make the partial diff as user-friendly as possible, the database model received an internal changelog which consists on a list of modification made during a design session. This list can be queried in such way that only the objects modified that match the filter(s) criteria are used in the partial diff process. Talking about model's internal changelog, this one can be persisted into the model file so it can be restored in the next design session, thus, the user is free to apply a partial diff anytime as long as the changelog isn't cleaned up.
The database import process was patched in such way that a sequence will be automatically created when a column refers it from the default value. This will happen only when the automatic dependency resolution is active.
The objects filtering widget introduced in 0.9.3-alpha1 was slightly redesigned by moving options to a popup menu in order to make the widget more compact and easier to use.
The command line interface received lots of improvements too, from a simple menu redesign to the support to partial diff. Seveal bugs were fixed in this release too. The majority related to crashes but there was some bugs affecting the database design like the one that was rendering incorrectly the relationships the combination of collapsed tables and the "FK to PK" connection mode was in use.
A bug in diff was eliminated too and now inheritances are correctly processed and the proper code generated.
Finally, some of the change log entries in this version are listed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added support to partial diffs between a model and database or between two databases. * [New] The CLI now validates the mixing of options of different operation modes. * [New] Created an internal changelog on DatabaseModel to register object's modification over time being useful for partial diff operations. * [New] Added the widget called ChangelogWidget to control the model's internal changelog settings in the design view. * [New] Added support to save/load changelog from model file. * [New] The CLI now supports partial diffs too. * [New] Added a warning message prior to the partial diff without using "Do not drop missing objects" option. * [New] Added cast and user mapping to the list of filterable objects. * [New] Added a hint text in ObjectsFilterWidget to inform about exact match searching. * [New] Added support to DatabaseImportHelper to create a sequence assigned to a column via default value if automatic dependencies resolution is enabled. * [Change] Improved the sequences assignments to columns in DatabaseImportHelper::assignSequencesToColumns. * [Change] Minor adjustment on objects grids in SwapObjectsIdsWidget, DatabaseImportForm and ModelDatabaseDiffForm by changing the columns order. * [Change] Minor change in ObjectsFilterWidget by making the action "Only matching" checked by default. * [Change] Minor improvement on CLI to accept the value "all" for the paramenter --force-children in order to force all table children at once. * [Change] Improved the objects filtering in such way to allow filter by name or signature. * [Change] Improved the UI of ObjectsFilterWidget by moving all options to a popup menu. * [Change] Several changes in all catalog queries in order to support signature matching. * [Change] Adjusted the appimages building process. * [Change] Changing the default font size of graphical objects to 10pt in order to try to solve the intermittend issue of disappearing texts. * [Change] Updated the French translation. * [Fix] Fixed a regression in ObjectFinderWidget that was not opening objects form with double-click on an item on the results grid. * [Fix] Fixed a bug when drawing relationships in FK to PK connection mode. Now when one of the tables is collapsed the center points of both are used as connection points to the relationship. * [Fix] Fixed a crash in ModelDatabaseDiffForm while enabling/disabling the partial diff tab. * [Fix] Fixed the diff process for inheritance relationships created for two existing tables. * [Fix] Fixed a crash in LayersWidget when renaming a layer. * [Fix] Minor fix in DatabaseImportHelper::assignSequencesToColumns. * [Fix] Minor fix in ConstraintWidget that was trying to validate FK relationships for generated tables of many-to-many relationships. * [Fix] Fixed a bug in Catalog::getObjectsOIDs that was executing a catalog query for a certain object when it was not being filtered. * [Fix] Minor fix in ModelDatabaseDiffForm tabs enabling/disabling steps. * [Fix] Fixed the QProcess usage in ModelFixForm due to QProcess::start() deprecation in Qt 5.15. * [Fix] Fixed a crash when trying to move several objects to a layer from the object finder widget and in the selected set one or more objects aren't graphical ones.
Summary: here we are again bringing another round of improvements to pgModeler. This release basically enhances what has been done in 0.9.3-alpha1 plus bringing an important experimental feature: the partial diff.
After a entire month exclusively dedicated to the partial diff implementation we finally have something usable. This feature consists in taking an input database or model, apply user-provided filters and diminishing the amount of objects to be compared. This brings a significant gain of speed in the process because only a subset of the database/model will be handled.
In order to make the partial diff as user-friendly as possible, the database model received an internal changelog which consists on a list of modification made during a design session. This list can be queried in such way that only the objects modified that match the filter(s) criteria are used in the partial diff process. Talking about model's internal changelog, this one can be persisted into the model file so it can be restored in the next design session, thus, the user is free to apply a partial diff anytime as long as the changelog isn't cleaned up.
The database import process was patched in such way that a sequence will be automatically created when a column refers it from the default value. This will happen only when the automatic dependency resolution is active.
The objects filtering widget introduced in 0.9.3-alpha1 was slightly redesigned by moving options to a popup menu in order to make the widget more compact and easier to use.
The command line interface received lots of improvements too, from a simple menu redesign to the support to partial diff. Seveal bugs were fixed in this release too. The majority related to crashes but there was some bugs affecting the database design like the one that was rendering incorrectly the relationships the combination of collapsed tables and the "FK to PK" connection mode was in use.
A bug in diff was eliminated too and now inheritances are correctly processed and the proper code generated.
Finally, some of the change log entries in this version are listed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added support to partial diffs between a model and database or between two databases. * [New] The CLI now validates the mixing of options of different operation modes. * [New] Created an internal changelog on DatabaseModel to register object's modification over time being useful for partial diff operations. * [New] Added the widget called ChangelogWidget to control the model's internal changelog settings in the design view. * [New] Added support to save/load changelog from model file. * [New] The CLI now supports partial diffs too. * [New] Added a warning message prior to the partial diff without using "Do not drop missing objects" option. * [New] Added cast and user mapping to the list of filterable objects. * [New] Added a hint text in ObjectsFilterWidget to inform about exact match searching. * [New] Added support to DatabaseImportHelper to create a sequence assigned to a column via default value if automatic dependencies resolution is enabled. * [Change] Improved the sequences assignments to columns in DatabaseImportHelper::assignSequencesToColumns. * [Change] Minor adjustment on objects grids in SwapObjectsIdsWidget, DatabaseImportForm and ModelDatabaseDiffForm by changing the columns order. * [Change] Minor change in ObjectsFilterWidget by making the action "Only matching" checked by default. * [Change] Minor improvement on CLI to accept the value "all" for the paramenter --force-children in order to force all table children at once. * [Change] Improved the objects filtering in such way to allow filter by name or signature. * [Change] Improved the UI of ObjectsFilterWidget by moving all options to a popup menu. * [Change] Several changes in all catalog queries in order to support signature matching. * [Change] Adjusted the appimages building process. * [Change] Changing the default font size of graphical objects to 10pt in order to try to solve the intermittend issue of disappearing texts. * [Change] Updated the French translation. * [Fix] Fixed a regression in ObjectFinderWidget that was not opening objects form with double-click on an item on the results grid. * [Fix] Fixed a bug when drawing relationships in FK to PK connection mode. Now when one of the tables is collapsed the center points of both are used as connection points to the relationship. * [Fix] Fixed a crash in ModelDatabaseDiffForm while enabling/disabling the partial diff tab. * [Fix] Fixed the diff process for inheritance relationships created for two existing tables. * [Fix] Fixed a crash in LayersWidget when renaming a layer. * [Fix] Minor fix in DatabaseImportHelper::assignSequencesToColumns. * [Fix] Minor fix in ConstraintWidget that was trying to validate FK relationships for generated tables of many-to-many relationships. * [Fix] Fixed a bug in Catalog::getObjectsOIDs that was executing a catalog query for a certain object when it was not being filtered. * [Fix] Minor fix in ModelDatabaseDiffForm tabs enabling/disabling steps. * [Fix] Fixed the QProcess usage in ModelFixForm due to QProcess::start() deprecation in Qt 5.15. * [Fix] Fixed a crash when trying to move several objects to a layer from the object finder widget and in the selected set one or more objects aren't graphical ones.
Purchase
Purchase an access key and support this project. Pay using PayPal™ 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!