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, buying any binary package, you'll help 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-beta1
October 05, 2020
Changes since: v0.9.3-beta
Summary: we are quite close to the end of another amazing development cycle with this last beta release of 0.9.3!
This launch brings mainly bug fixes but in order to make pgModeler even more complete, we've added full support to procedures and transforms.
Additionally to new things, pgModeler was improved in such a way to render database models more properly in high DPI screens.
There were some important changes in the code generation and exporting too. For the former, the SQL code of the database object will respect the disabled status. In previous versions, the SQL code was always deactivated.
The model exporting process will now abort the execution if the database object has its code disabled. This behavior does not apply to model validation which forces the enabling of the database object's SQL so the whole model can be properly checked. pgModeler now will not generate ADD CONSTRAINT instructions for constraints during diff when the parent table is also being created in the process.
Also, default values and functions arguments containing json/jsonb values are now properly formatted and saved to the XML code avoiding corruption of the database model in very specific cases.
Finally, some of the changelog entries in this version are listed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added the version descriptor for PostgreSQL 13. * [New] Added support to procedures in design, import and diff processes. * [New] Added support to transforms in design, import and diff processes. * [New] Added support to modifying attributes toggler colors from appearance settings. * [New] Tag objects now include attribute toggler colors. * [Change] Changed the behavior of the generation of SQL code for database object, now it'll respect the SQL disabled status of the object. * [Change] The ModelExportHelper will abort the export process if the SQL code of the database object is disabled. * [Change] The database model is now flagged as modified everytime the objects are swapped. * [Change] Improved the ObjectSelectorWidget in order to save/restore the geometry of internal ModelObjectsWidget instances. * [Change] pgModeler will alert about a possible data/work loss if the user is trying to save a model in which there're other instances loaded other tabs. * [Change] Making the class Function be a direct child of BaseFunction. * [Change] Moved the common code between functions and procedures to a base class called BaseFunction. * [Change] Replaced the attributes PhysicalTable::DataSeparator and DatabaseExplorerWidget::ElemSeparator usages by PgModelerNs::DataSeparator. * [Change] Refactored the schema files in order to remove code duplication related to ddl-end token. * [Change] Minor improvement in ConfigurationForm by adding a splitter between config items (left) and settings page (right). * [Change] Minor improvements on objects rendering in order to consider screen dpi when configuring objects border sizes. * [Change] Minor refactoring in the parameter/signature generation in class Function. * [Change] Making the NewObjectOverlay less transparent in order to enhance reading. * [Fix] Fixed a bug in constraint.sch that was avoiding the correct importing of exclude of constraints. * [Fix] Minor fix in the SyntaxHighlighter in order to highlight correctly multline blocks (specially comments). * [Fix] Fixed a bug in DatabaseImportHelper that was causing failure when importing some objects' permissions. * [Fix] Fixed a bug on MainWindow that was wrongly showing the main menu bar in certain cases at startup. * [Fix] Minor fix in BaseFunction::createSignature in order to remove OUT keywords from signature. * [Fix] Fixed a bug when importing triggers in which functions arguments contain json/jsonb values. Now values are properly formatted. * [Fix] Fixed a bug in XmlParser::convertCharsToXMLEntities that was not converting json/jsonb default values correctly breaking the entire XML code of the database model. * [Fix] Fixed a bug in Parameter class that was causing default values to be ignored. * [Fix] Fixed a bug in SchemaParser related to exceptions being raised wrongly in expressions evaluation. * [Fix] Fixed a bug in ModelFixForm that was passing arguments to CLI in wrong format. * [Fix] Fixed a bug in CLI that was ignoring input-db parameter when doing diff. * [Fix] Minor fix in the graphical objects rendering in 4k screens when QT_AUTO_SCREEN_SCALE_FACTOR is set. Now they are rendered in acceptable proportions. * [Fix] Minor fix in ModelsDiffHelper in order to avoid generating ALTER...ADD COSTRAINT for constraints (check and unique) in which parent table is also being created.
Summary: we are quite close to the end of another amazing development cycle with this last beta release of 0.9.3!
This launch brings mainly bug fixes but in order to make pgModeler even more complete, we've added full support to procedures and transforms.
Additionally to new things, pgModeler was improved in such a way to render database models more properly in high DPI screens.
There were some important changes in the code generation and exporting too. For the former, the SQL code of the database object will respect the disabled status. In previous versions, the SQL code was always deactivated.
The model exporting process will now abort the execution if the database object has its code disabled. This behavior does not apply to model validation which forces the enabling of the database object's SQL so the whole model can be properly checked. pgModeler now will not generate ADD CONSTRAINT instructions for constraints during diff when the parent table is also being created in the process.
Also, default values and functions arguments containing json/jsonb values are now properly formatted and saved to the XML code avoiding corruption of the database model in very specific cases.
Finally, some of the changelog entries in this version are listed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added the version descriptor for PostgreSQL 13. * [New] Added support to procedures in design, import and diff processes. * [New] Added support to transforms in design, import and diff processes. * [New] Added support to modifying attributes toggler colors from appearance settings. * [New] Tag objects now include attribute toggler colors. * [Change] Changed the behavior of the generation of SQL code for database object, now it'll respect the SQL disabled status of the object. * [Change] The ModelExportHelper will abort the export process if the SQL code of the database object is disabled. * [Change] The database model is now flagged as modified everytime the objects are swapped. * [Change] Improved the ObjectSelectorWidget in order to save/restore the geometry of internal ModelObjectsWidget instances. * [Change] pgModeler will alert about a possible data/work loss if the user is trying to save a model in which there're other instances loaded other tabs. * [Change] Making the class Function be a direct child of BaseFunction. * [Change] Moved the common code between functions and procedures to a base class called BaseFunction. * [Change] Replaced the attributes PhysicalTable::DataSeparator and DatabaseExplorerWidget::ElemSeparator usages by PgModelerNs::DataSeparator. * [Change] Refactored the schema files in order to remove code duplication related to ddl-end token. * [Change] Minor improvement in ConfigurationForm by adding a splitter between config items (left) and settings page (right). * [Change] Minor improvements on objects rendering in order to consider screen dpi when configuring objects border sizes. * [Change] Minor refactoring in the parameter/signature generation in class Function. * [Change] Making the NewObjectOverlay less transparent in order to enhance reading. * [Fix] Fixed a bug in constraint.sch that was avoiding the correct importing of exclude of constraints. * [Fix] Minor fix in the SyntaxHighlighter in order to highlight correctly multline blocks (specially comments). * [Fix] Fixed a bug in DatabaseImportHelper that was causing failure when importing some objects' permissions. * [Fix] Fixed a bug on MainWindow that was wrongly showing the main menu bar in certain cases at startup. * [Fix] Minor fix in BaseFunction::createSignature in order to remove OUT keywords from signature. * [Fix] Fixed a bug when importing triggers in which functions arguments contain json/jsonb values. Now values are properly formatted. * [Fix] Fixed a bug in XmlParser::convertCharsToXMLEntities that was not converting json/jsonb default values correctly breaking the entire XML code of the database model. * [Fix] Fixed a bug in Parameter class that was causing default values to be ignored. * [Fix] Fixed a bug in SchemaParser related to exceptions being raised wrongly in expressions evaluation. * [Fix] Fixed a bug in ModelFixForm that was passing arguments to CLI in wrong format. * [Fix] Fixed a bug in CLI that was ignoring input-db parameter when doing diff. * [Fix] Minor fix in the graphical objects rendering in 4k screens when QT_AUTO_SCREEN_SCALE_FACTOR is set. Now they are rendered in acceptable proportions. * [Fix] Minor fix in ModelsDiffHelper in order to avoid generating ALTER...ADD COSTRAINT for constraints (check and unique) in which parent table is also being created.
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!