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 for yourself. As a facility, we provide compiled binary packages at a really small price. Also, if you're interested in evaluate a binary package, you can get a demo copy before proceed with the purchasing. Since this is an independent project by ordering any binary package you'll help to keep its development alive and at full speed!
Current: 0.9.1
May 14, 2018
Changes since: v0.9.1-beta1
Summary: after eight months of hard work we finally have the stable release 0.9.1. This version is a mark in the pgModeler's development and so important as the release 0.8.2 in terms of improvements because it brought features requested long ago and that will make pgModeler even better to work with, being some of them: crow's foot notation support, multiple relationships for the same table pair, support to row level security, identity columns and much more.
For this release specifically (considering only the work after 0.9.1-beta1), the golden rule was to fix bugs, adjust the current features and introduce few new things and thus was done: 21 bug fixes, 14 changes/improvements and 7 new features. The majority of new features are related to the CLI which received the ability to import and diff databases which can make it even better to integrate to automtated deployment processess or run quick tasks over models or databases without the need to open pgModeler's GUI.
Some important improvements were done in the overall performance of the SQL tool. The query execution and results display are a lot better now being quicker and less eager in terms of memory consumption avoiding crashes when querying large tables. The data manipulation also received a patch that makes the row duplication more efficient.
Now, for the fixes, another patch was introduced in order to resize correctly dialogs in HiDPI/Retina displays. Several reverse engineering bugs were fixes and now databases are imported more precisely compared to previous releases. Lastly, a bug that seems to happen only on macOS while dealing with large models is finally fixed and was related to some running threads messing around with the main process avoiding it to correctly save the model and causing hang ups sometimes.
The whole set of changes of this release (considering the alpha and beta stages) has 152 entries being 43 new features, 47 changes/improvements and 62 bug fixes. Below we highlight some of news for the work since 0.9.1-beta1, for the complete list of changes, please, take a look into the CHANGELOG.md.
* [New] Added support to line selection by clicking and moving the mouse over the line numbers widget in any source code field. * [New] The validator now checks if the model has columns referencing spatial data types and creates the postgis extension automatically when fixing the model. * [New] Added support to RESTART IDENTITY on truncate tables in DatabaseExplorerWidget. * [New] Added support to diff operation in CLI. * [New] Added support to import database from CLI. * [New] Adding missing types regrole and regnamespace. * [Change] Improved the copy/duplicate operation in order to copy rules, index, trigger and policies together to their parents. * [Change] Added column names to the code completion widget used in the filter widget at DataManipulationForm. * [Change] Improved the SQLExecutionWidget in such way that it'll display large amount of data more quickly and consuming less memory. * [Change] Minor improvement in SQLExecutionWidget to show the amount of time took to run a query. * [Change] Minor improvement in the text find widgets in SQL tool in order to make them closable via dedicated button. * [Change] Improved the set tag operation in ModelWidget in order to cleanup the assigned tags to a set of objects. * [Change] Refactored all the CLI options. * [Change] Improved the performance of the row duplication action in DataManipulationForm. * [Change] Improved the performance of "Move to schema" operation. * [Change] Changed the behaviour of select and fade buttons in ObjectFinderWidget in such way to enable the user to select/fade the objects in the listing (or not included in the results). * [Fix] Fixed the tab behavior on comment box in all editing forms of database objects. * [Fix] Fixed the catalog query for user defined types. * [Fix] Fixed the import of user defined types which names contains uppercase characters. * [Fix] Fix window scaling on HiDPI/Retina screens. * [Fix] Fixed a bug in ModelExportHelper that was failing to remane the database when the command appeared. * [Fix] Fixed a bug in CollationWidget that was referencing the collation attributes LC_??? using the wrong constant. * [Fix] Fixed the behaviour of the message box that warns about the need of validate the model prior to export, save or diff. Now rejecting the dialog (i.e. closing it) will be considered that the user wants to proceed with the pending operation even with an invalid model. * [Fix] Fixed the import of comments for constraints,triggers, index and rules. * [Fix] Fixed a bug in the aggregate import process. * [Fix] Minor fix in DataManipulationForm to avoid the generation of a where clause when the filter is filled only with spaces. * [Fix] Minor fix in the magnfier tool to use the same render hints as the canvas viewport. * [Fix] Fixed a bug in the diff process that was trying to recreate the whole database when the "Force recreation" option was set. * [Fix] Fixed a bug when showing the source of tables in DatabaseExplorerWidget when these objects have permissions assigned. * [Fix] Fixed the saving process for large models by stopping the threads related to temp models saving while the model file is being written.
Summary: after eight months of hard work we finally have the stable release 0.9.1. This version is a mark in the pgModeler's development and so important as the release 0.8.2 in terms of improvements because it brought features requested long ago and that will make pgModeler even better to work with, being some of them: crow's foot notation support, multiple relationships for the same table pair, support to row level security, identity columns and much more.
For this release specifically (considering only the work after 0.9.1-beta1), the golden rule was to fix bugs, adjust the current features and introduce few new things and thus was done: 21 bug fixes, 14 changes/improvements and 7 new features. The majority of new features are related to the CLI which received the ability to import and diff databases which can make it even better to integrate to automtated deployment processess or run quick tasks over models or databases without the need to open pgModeler's GUI.
Some important improvements were done in the overall performance of the SQL tool. The query execution and results display are a lot better now being quicker and less eager in terms of memory consumption avoiding crashes when querying large tables. The data manipulation also received a patch that makes the row duplication more efficient.
Now, for the fixes, another patch was introduced in order to resize correctly dialogs in HiDPI/Retina displays. Several reverse engineering bugs were fixes and now databases are imported more precisely compared to previous releases. Lastly, a bug that seems to happen only on macOS while dealing with large models is finally fixed and was related to some running threads messing around with the main process avoiding it to correctly save the model and causing hang ups sometimes.
The whole set of changes of this release (considering the alpha and beta stages) has 152 entries being 43 new features, 47 changes/improvements and 62 bug fixes. Below we highlight some of news for the work since 0.9.1-beta1, for the complete list of changes, please, take a look into the CHANGELOG.md.
* [New] Added support to line selection by clicking and moving the mouse over the line numbers widget in any source code field. * [New] The validator now checks if the model has columns referencing spatial data types and creates the postgis extension automatically when fixing the model. * [New] Added support to RESTART IDENTITY on truncate tables in DatabaseExplorerWidget. * [New] Added support to diff operation in CLI. * [New] Added support to import database from CLI. * [New] Adding missing types regrole and regnamespace. * [Change] Improved the copy/duplicate operation in order to copy rules, index, trigger and policies together to their parents. * [Change] Added column names to the code completion widget used in the filter widget at DataManipulationForm. * [Change] Improved the SQLExecutionWidget in such way that it'll display large amount of data more quickly and consuming less memory. * [Change] Minor improvement in SQLExecutionWidget to show the amount of time took to run a query. * [Change] Minor improvement in the text find widgets in SQL tool in order to make them closable via dedicated button. * [Change] Improved the set tag operation in ModelWidget in order to cleanup the assigned tags to a set of objects. * [Change] Refactored all the CLI options. * [Change] Improved the performance of the row duplication action in DataManipulationForm. * [Change] Improved the performance of "Move to schema" operation. * [Change] Changed the behaviour of select and fade buttons in ObjectFinderWidget in such way to enable the user to select/fade the objects in the listing (or not included in the results). * [Fix] Fixed the tab behavior on comment box in all editing forms of database objects. * [Fix] Fixed the catalog query for user defined types. * [Fix] Fixed the import of user defined types which names contains uppercase characters. * [Fix] Fix window scaling on HiDPI/Retina screens. * [Fix] Fixed a bug in ModelExportHelper that was failing to remane the database when the command appeared. * [Fix] Fixed a bug in CollationWidget that was referencing the collation attributes LC_??? using the wrong constant. * [Fix] Fixed the behaviour of the message box that warns about the need of validate the model prior to export, save or diff. Now rejecting the dialog (i.e. closing it) will be considered that the user wants to proceed with the pending operation even with an invalid model. * [Fix] Fixed the import of comments for constraints,triggers, index and rules. * [Fix] Fixed a bug in the aggregate import process. * [Fix] Minor fix in DataManipulationForm to avoid the generation of a where clause when the filter is filled only with spaces. * [Fix] Minor fix in the magnfier tool to use the same render hints as the canvas viewport. * [Fix] Fixed a bug in the diff process that was trying to recreate the whole database when the "Force recreation" option was set. * [Fix] Fixed a bug when showing the source of tables in DatabaseExplorerWidget when these objects have permissions assigned. * [Fix] Fixed the saving process for large models by stopping the threads related to temp models saving while the model file is being written.
Develop: 0.9.2-beta2
November 04, 2019
Changes since: v0.9.2-beta1
Summary: the development of this new version was strongly focused on delivering the support to foreign table objects. This way pgModeler is now capable of handling all foreign objects implemented by PostgreSQL.
There was other important improvements including the support to diff presets which let the user to configure a set of options enabled/disabled for the diff operations.
Due to the release of PostgreSQL 12 some patches were applied to pgModeler in order to allow the users to connect to database servers of that version. This will allow all operations that depends on connections like export, diff, import to be performed on newer versions of PostgreSQL.
Lots of bugs were fixed too including crashes, false-positive results on diff feature and some problems on reverse engineering that was causing some kind of objects to be imported wrongly.
Finally, some changes of this version are detailed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added support to foreign tables. * [New] Added support to select all foreign tables in ModelWidget. * [New] Added support to swap objects ids using arrow keys by changing creation order between two close objects on the grid. * [New] Added support to save diff settings in form of presets. * [New] Added an option to BaseObject to force the comment escaping making multilined comments be presented as single lines but without changing their semantics. * [New] Adding support to parse escaped text delimiters and value separators in CSVLoadWidget. * [Change] Avoid unchecking PK checkboxes on TableWidget when adding a new column. * [Change] Validating the dialogs geometry regarding to screens geometry in order to avoid their appearance in an invalid position (out of range). * [Change] Restricting the usage of "Default partition" option for partitioning relationships when the partition table is a foreign table. * [Change] Improved the Relationship class to accept foreign tables. * [Change] Updated View class to accept reference foreign table columns. * [Change] Moved the original implementation of DatabaseModel::createTable to a template method createPhysicalTable in order to reuse it to create tables and foreign tables. * [Change] ForeignObject is not a BaseObject child anymore due to multi inheritance problem that it can generate in ForeignTable class. * [Change] Disabling mime type update on installers. * [Change] Changed the way temp source file is handled by the tool in order to solve a sharing violation problem on Windows. * [Fix] Fixed an bug in SQL generation of columns that was wrongly removing a comma from decimal data types. * [Fix] Fixed some catalog queries in order to support PostgreSQL 12. * [Fix] Fixed the ObjectFinderWidget in order to fade out correctly the listed/not listed elements. * [Fix] Fixed the quick actions menu at ModelWidget in order to include the "Edit data" action for foreign tables. * [Fix] Fixed the DatabaseImportHelper::assignSequencesToColumns in order to correctly assign sequences to foreign table columns. * [Fix] Fixed a crash in ModelValidationHelper that was caused by wrong checking when validating generic sql objects. * [Fix] Fixed the source code display for tables and foreign tables on DatabaseExplorerWidget. * [Fix] Fixed the CodeCompletionWidget to display foreign table children. * [Fix] Fixed the diff process in order recognize partition foreign tables attach/detach. * [Fix] Fixed the generation of XML code of partitioning relationships. * [Fix] Improved the DataManipulationForm in order to restore the columns visibility when retrieving again the data of the current table. * [Fix] Fixed the drop action in DatabaseExplorerWidget for user mappings. * [Fix] Fixed the generation of SQL code of partition tables in order to avoid the inclusion of partitioned tables columns on the code. * [Fix] Fixed a crash on DatabaseImportHelper when destroying detached inherited columns. * [Fix] Fixed a regression when importing permissions related to functions. * [Fix] Fixed the SwapIdsWidget postion/size saving and restoration. * [Fix] Additional fix to the extension import to correctly indetify it as a data type handler. * [Fix] Fixed a bug on Role's SQL generation due to a missing attribute. * [Fix] Additional fix in GeneralConfigWidget to save correctly the settings of dockwidgets. * [Fix] Minor fix in DatabaseModel to write ddl end token in the appended/prepended custom code. * [Fix] Fixed a false-positive result when doing the diff between two fuctions that contains the same signature. * [Fix] Fixed the diff generation for Role objects when setting up an blank password. * [Fix] Fixed the "Prepend at the beggining of the model" option behavior on CustomSQLWidget. * [Fix] Fixed the catalog query for extension in order to indetify correctly if this object handles a data type. * [Fix] Fixed the "Clear items" action in popup menu at DataManipulationForm. * [Fix] Fixed the importing of tables and views in such way to automatically create correctly the domains referenced by their columns. * [Fix] Fixed a bug on ModelDatabaseDiffForm that was causing the form to be reseted on the middle of a diff process when the user minimize the diff dialog causing unexpected behavior (or even crashes sometimes). * [Fix] Minor fix in ModelDatabaseDiffForm to avoid using uniform items height in output widget.
Summary: the development of this new version was strongly focused on delivering the support to foreign table objects. This way pgModeler is now capable of handling all foreign objects implemented by PostgreSQL.
There was other important improvements including the support to diff presets which let the user to configure a set of options enabled/disabled for the diff operations.
Due to the release of PostgreSQL 12 some patches were applied to pgModeler in order to allow the users to connect to database servers of that version. This will allow all operations that depends on connections like export, diff, import to be performed on newer versions of PostgreSQL.
Lots of bugs were fixed too including crashes, false-positive results on diff feature and some problems on reverse engineering that was causing some kind of objects to be imported wrongly.
Finally, some changes of this version are detailed below. For the complete list of changes/fixes, please, read the CHANGELOG.md.
* [New] Added support to foreign tables. * [New] Added support to select all foreign tables in ModelWidget. * [New] Added support to swap objects ids using arrow keys by changing creation order between two close objects on the grid. * [New] Added support to save diff settings in form of presets. * [New] Added an option to BaseObject to force the comment escaping making multilined comments be presented as single lines but without changing their semantics. * [New] Adding support to parse escaped text delimiters and value separators in CSVLoadWidget. * [Change] Avoid unchecking PK checkboxes on TableWidget when adding a new column. * [Change] Validating the dialogs geometry regarding to screens geometry in order to avoid their appearance in an invalid position (out of range). * [Change] Restricting the usage of "Default partition" option for partitioning relationships when the partition table is a foreign table. * [Change] Improved the Relationship class to accept foreign tables. * [Change] Updated View class to accept reference foreign table columns. * [Change] Moved the original implementation of DatabaseModel::createTable to a template method createPhysicalTable in order to reuse it to create tables and foreign tables. * [Change] ForeignObject is not a BaseObject child anymore due to multi inheritance problem that it can generate in ForeignTable class. * [Change] Disabling mime type update on installers. * [Change] Changed the way temp source file is handled by the tool in order to solve a sharing violation problem on Windows. * [Fix] Fixed an bug in SQL generation of columns that was wrongly removing a comma from decimal data types. * [Fix] Fixed some catalog queries in order to support PostgreSQL 12. * [Fix] Fixed the ObjectFinderWidget in order to fade out correctly the listed/not listed elements. * [Fix] Fixed the quick actions menu at ModelWidget in order to include the "Edit data" action for foreign tables. * [Fix] Fixed the DatabaseImportHelper::assignSequencesToColumns in order to correctly assign sequences to foreign table columns. * [Fix] Fixed a crash in ModelValidationHelper that was caused by wrong checking when validating generic sql objects. * [Fix] Fixed the source code display for tables and foreign tables on DatabaseExplorerWidget. * [Fix] Fixed the CodeCompletionWidget to display foreign table children. * [Fix] Fixed the diff process in order recognize partition foreign tables attach/detach. * [Fix] Fixed the generation of XML code of partitioning relationships. * [Fix] Improved the DataManipulationForm in order to restore the columns visibility when retrieving again the data of the current table. * [Fix] Fixed the drop action in DatabaseExplorerWidget for user mappings. * [Fix] Fixed the generation of SQL code of partition tables in order to avoid the inclusion of partitioned tables columns on the code. * [Fix] Fixed a crash on DatabaseImportHelper when destroying detached inherited columns. * [Fix] Fixed a regression when importing permissions related to functions. * [Fix] Fixed the SwapIdsWidget postion/size saving and restoration. * [Fix] Additional fix to the extension import to correctly indetify it as a data type handler. * [Fix] Fixed a bug on Role's SQL generation due to a missing attribute. * [Fix] Additional fix in GeneralConfigWidget to save correctly the settings of dockwidgets. * [Fix] Minor fix in DatabaseModel to write ddl end token in the appended/prepended custom code. * [Fix] Fixed a false-positive result when doing the diff between two fuctions that contains the same signature. * [Fix] Fixed the diff generation for Role objects when setting up an blank password. * [Fix] Fixed the "Prepend at the beggining of the model" option behavior on CustomSQLWidget. * [Fix] Fixed the catalog query for extension in order to indetify correctly if this object handles a data type. * [Fix] Fixed the "Clear items" action in popup menu at DataManipulationForm. * [Fix] Fixed the importing of tables and views in such way to automatically create correctly the domains referenced by their columns. * [Fix] Fixed a bug on ModelDatabaseDiffForm that was causing the form to be reseted on the middle of a diff process when the user minimize the diff dialog causing unexpected behavior (or even crashes sometimes). * [Fix] Minor fix in ModelDatabaseDiffForm to avoid using uniform items height in output widget.
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 for 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!