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-alpha1
May 20, 2020
Changes since: v0.9.3-alpha
Summary: after almost two months and keeping the spirit of polishing pgModeler's features during 0.9.3 development we're here to announce important fixes and some interesting new features in 0.9.3-alpha1.
The first one is the capability of identifying and rendering relationships generated from foreign key constraints with the correct visual semantics. In previous versions, pgModeler rendered FK relationships in a default form which, in majority of times, would not express the real semantics of the linking between tables. Now, pgModeler is able to detect if a FK relationship is of the type one-to-one or one-to-many just by analyzing the involved foreign keys, unique keys and not null constraints. Bear in mind that this is still an experimental feature and eventual false-positive detections may occur.
Attending to some requests, pgModeler now allows, even inderectly, the modification of objects generated by one-to-one and one-to-many relationships like columns and foreign keys. In order to achieve that an action to convert one-to-one or one-to-many relationships to FK relationships was created. Basically, this conversion detaches the generated objects causing them to be not protected anymore which allows the user to change any of their attributes. The drawback of this feature is that the user loses the automatic column and constraint propagation offered by the relationships.
Another great new feature is the objects filtering prior to the database reverse engineering. If you constantly works on big databases by generating models from a subset of objects related to those databases this feature is for you! Prior to 0.9.3-alpha1, one needed to load the entire database tree on reverse engineering dialog, select only the desired objects and then perform the importing. This was a really time-consuming operation and even would deplete all CPU and memory resources causing crashes in some cases. Now, the user is able to provide object filters and pgModeler will bring only the ones matching that filters taking a considerable lesser time to construct the database tree/list of the preselected objects as well to import that set of objects. It worth to mention that the CLI also received this feature upgrade with the option --filter and --discard-non-matches.
pgModeler also received support to some new PostgreSQL 12 features, now the tool is capable of handling generated columns while designing models, importing databases and performing diffs. In the bug fixes side, some crashes were eliminated in different portions of the application. Also, relationships are now using correctly the provided global name patterns. Some fixes on the system catalog queries used by pgModeler when running import and diff brought some performance gain on these operations.
Finally, the key change log entries in this version are detailed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added support to creating initial configuration files from CLI. * [New] The CLI is now capable of using the objects filtering in reverse engineering. * [New] Added a warning message when trying to import a big database. * [New] Added support to object filtering in reverse engineering dialog. * [New] Adding support to AppImage building for Linux. * [New] Added support to importing PostgreSQL 12 generated columns. * [New] Adding support to PostgreSQL 12 generated columns. * [New] The ModelNavigationWidget now will display a save icon if the current model is pending a save operation. * [New] pgModeler now guesses if a FK relationship consists in a one-to-one based upon the foreign keys and unique keys settings. * [New] Improved the rendering of FK relationships. Now it recognizes the minimum cardinality by using the right crow's foot descriptor o|< or ||< in the destination entity. * [New] Added support to the conversion of 1-1 and 1-n relationships, allowing the user to perform modifications over objects generated by those relationships. * [New] Adding support to copy model validation widget output as text as well preview it as texts. * [New] Added support to show/hide all layers in LayersWidget. * [New] Added the paramenter application_name to Connection in order to indentify connections created by pgModeler when querying pg_stat_activity. * [New] Added support to save/restore Z value attribute in MetadataHandlingForm. * [New] Created an improved and reusable file selector widget. * [Change] Avoiding retrieve all types (system and user defined) at once before the reverse engineering in DatabaseImportHelper (Experimental). * [Change] Minor updates on windeploy.sh and macdeploy.sh * [Change] Minor improvement on DatabaseImportHelper in order to speed up the objects creation. * [Change] Improved the execution time for the catalog query of data types. * [Change] Improved the catalog query for sequences. * [Change] Avoiding the diff process to generate default value changes for generated columns. * [Change] Minor improvement in LayersWidget in order to allow manual resizing using the mouse. * [Fix] Fixed a bug when retrieving the refs to some objects in DatabaseModel. * [Fix] Minor fix in CLI menu and error messages. * [Fix] Fixed the role importing process. Now referenced roles are auto resolved. * [Fix] Fixed the dependency checking for user defined types in DatabaseModel. * [Fix] Fixed a bug when loading extension that has no schema specified. * [Fix] Minor fix in DatabaseImportHelper::createFunction in order to solve eventual duplicated parameter names when importing some functions. * [Fix] Fixed a bug that was causing global name patterns for relationships to never be used even if they were properly configured. * [Fix] Minor fix in ModelObjectsWidget and ModelWidget to provide the correct information about objects' selection in SceneInfoWidget. * [Fix] Fixed a bug in RelationshipWidget that was causing the cursor never to be restored to its original icon when an exception occurred during relationship editing. * [Fix] Fixed a crash in some situations when closing models.
Summary: after almost two months and keeping the spirit of polishing pgModeler's features during 0.9.3 development we're here to announce important fixes and some interesting new features in 0.9.3-alpha1.
The first one is the capability of identifying and rendering relationships generated from foreign key constraints with the correct visual semantics. In previous versions, pgModeler rendered FK relationships in a default form which, in majority of times, would not express the real semantics of the linking between tables. Now, pgModeler is able to detect if a FK relationship is of the type one-to-one or one-to-many just by analyzing the involved foreign keys, unique keys and not null constraints. Bear in mind that this is still an experimental feature and eventual false-positive detections may occur.
Attending to some requests, pgModeler now allows, even inderectly, the modification of objects generated by one-to-one and one-to-many relationships like columns and foreign keys. In order to achieve that an action to convert one-to-one or one-to-many relationships to FK relationships was created. Basically, this conversion detaches the generated objects causing them to be not protected anymore which allows the user to change any of their attributes. The drawback of this feature is that the user loses the automatic column and constraint propagation offered by the relationships.
Another great new feature is the objects filtering prior to the database reverse engineering. If you constantly works on big databases by generating models from a subset of objects related to those databases this feature is for you! Prior to 0.9.3-alpha1, one needed to load the entire database tree on reverse engineering dialog, select only the desired objects and then perform the importing. This was a really time-consuming operation and even would deplete all CPU and memory resources causing crashes in some cases. Now, the user is able to provide object filters and pgModeler will bring only the ones matching that filters taking a considerable lesser time to construct the database tree/list of the preselected objects as well to import that set of objects. It worth to mention that the CLI also received this feature upgrade with the option --filter and --discard-non-matches.
pgModeler also received support to some new PostgreSQL 12 features, now the tool is capable of handling generated columns while designing models, importing databases and performing diffs. In the bug fixes side, some crashes were eliminated in different portions of the application. Also, relationships are now using correctly the provided global name patterns. Some fixes on the system catalog queries used by pgModeler when running import and diff brought some performance gain on these operations.
Finally, the key change log entries in this version are detailed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added support to creating initial configuration files from CLI. * [New] The CLI is now capable of using the objects filtering in reverse engineering. * [New] Added a warning message when trying to import a big database. * [New] Added support to object filtering in reverse engineering dialog. * [New] Adding support to AppImage building for Linux. * [New] Added support to importing PostgreSQL 12 generated columns. * [New] Adding support to PostgreSQL 12 generated columns. * [New] The ModelNavigationWidget now will display a save icon if the current model is pending a save operation. * [New] pgModeler now guesses if a FK relationship consists in a one-to-one based upon the foreign keys and unique keys settings. * [New] Improved the rendering of FK relationships. Now it recognizes the minimum cardinality by using the right crow's foot descriptor o|< or ||< in the destination entity. * [New] Added support to the conversion of 1-1 and 1-n relationships, allowing the user to perform modifications over objects generated by those relationships. * [New] Adding support to copy model validation widget output as text as well preview it as texts. * [New] Added support to show/hide all layers in LayersWidget. * [New] Added the paramenter application_name to Connection in order to indentify connections created by pgModeler when querying pg_stat_activity. * [New] Added support to save/restore Z value attribute in MetadataHandlingForm. * [New] Created an improved and reusable file selector widget. * [Change] Avoiding retrieve all types (system and user defined) at once before the reverse engineering in DatabaseImportHelper (Experimental). * [Change] Minor updates on windeploy.sh and macdeploy.sh * [Change] Minor improvement on DatabaseImportHelper in order to speed up the objects creation. * [Change] Improved the execution time for the catalog query of data types. * [Change] Improved the catalog query for sequences. * [Change] Avoiding the diff process to generate default value changes for generated columns. * [Change] Minor improvement in LayersWidget in order to allow manual resizing using the mouse. * [Fix] Fixed a bug when retrieving the refs to some objects in DatabaseModel. * [Fix] Minor fix in CLI menu and error messages. * [Fix] Fixed the role importing process. Now referenced roles are auto resolved. * [Fix] Fixed the dependency checking for user defined types in DatabaseModel. * [Fix] Fixed a bug when loading extension that has no schema specified. * [Fix] Minor fix in DatabaseImportHelper::createFunction in order to solve eventual duplicated parameter names when importing some functions. * [Fix] Fixed a bug that was causing global name patterns for relationships to never be used even if they were properly configured. * [Fix] Minor fix in ModelObjectsWidget and ModelWidget to provide the correct information about objects' selection in SceneInfoWidget. * [Fix] Fixed a bug in RelationshipWidget that was causing the cursor never to be restored to its original icon when an exception occurred during relationship editing. * [Fix] Fixed a crash in some situations when closing models.
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!