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-alpha
August 20, 2018
Changes since: v0.9.1
Summary: this release does not have an extensive change log but brings some long desired features as well important fixes. The first feature to talk about is the long awaited SQL execution cancelling which enables the user to abort the execution of any command issued to the server in the SQL execution field (Manage view) without the need to kill the application in order to interrupt the running SQL (like on previous releases).
Another feature introduced is the compact view of the model. This one makes the tables and views smaller by hiding the columns' data types and other informations. This feature came as a support to those developers who need to present their models to an audience without database specific knowledge. The trick here is to replace the original names of graphical objects by more friendly ones so the audience can understand the essence of the model being worked without worry about the tech details.
Also I decided to include a functionality to save and restore the majority of dialogs sizes and their positions, another long requested feature. This one can be useful for those who don't want pgModeler to resize the forms automatically everytime (specially when working in high resolution screens or dual monitors environments). This feature comes activated by default on new installations and can be deactivated at general settings.
More features were implemented in this release too, being some of them: the support to sequence options on indentity columns, the support to bulk data edition on data manipulation dialog, the support to paste CSV text from clipboard into the dialog where initial data can be specified for tables (in design view) and some other.
One important change done was a partial refactoring of the View editing form by moving the fields related to view's references to a dedicated dialog making the whole form a bit less complicated to use. I have plans to keep improving that dialog in special but in future releases a full UX/UI remodeling will be done in the application.
Below some of the changes of this release, for the complete list of changes, please, take a look into the CHANGELOG.md.
* [New] Added the support to cancelling SQL execution in SQLExecutionWidget. * [New] Added support to save/restore the dialogs sizes and positions. * [New] Added support to truncate tables in DataManipulationForm. * [New] Added support to aliases on some graphical objects to be is used in the compact view mode. * [New] Added support to save/load object's metadata containing aliases information. * [New] Added support to compact view of the model where graphical objects can have a more friendly name for a reduced view as well for those who don't need to see details about tables (clients of the business, for instance). * [New] Added support to sequence options for identity columns. * [New] Added the ability to paste CSV text from clipboard into the TableDataWidget. * [New] Added support to bulk data edit in TableDataWidget. * [Change] Changed the behaviour of the fade in/out of relationships linked to a table by applying the effect on the other tables that are related to the selected one. * [Change] Refactored the view editing dialog by moving the references handling form to a dedicated modal dialog. * [Change] Improved the model loading from file by blocking signals of relationships avoiding excessive/repetive rendering of objects. The whole model is fully rendered when the file was completely loaded. * [Change] Minor adjustment on constraints rendering at extended attributes section of tables. * [Fix] Minor fix on stylesheet in order to display the extended button on general toolbar. * [Fix] Fix a shortcut conflict in DataManipulationform. * [Fix] Fixed the offset of strings composing the StorageType. * [Fix] Minor fix in SQLExecutionWidget allowing the output widget to be resized to a size lower than the default one. * [Fix] Fixed the generation of Database object source in DatabaseExplorerWidget. * [Fix] Minor fix in HintTextWidget to stay on top of all widget when being displayed. * [Fix] Fixed a bug that was not quoting extension name when needed. * [Fix] Fixed a crash when trying to remove a fk relationship when it was created from a foreign key which references protected columns (added by relationship). * [Fix] Fix a crash when importing CSV files into DataManipulationForm.
Summary: this release does not have an extensive change log but brings some long desired features as well important fixes. The first feature to talk about is the long awaited SQL execution cancelling which enables the user to abort the execution of any command issued to the server in the SQL execution field (Manage view) without the need to kill the application in order to interrupt the running SQL (like on previous releases).
Another feature introduced is the compact view of the model. This one makes the tables and views smaller by hiding the columns' data types and other informations. This feature came as a support to those developers who need to present their models to an audience without database specific knowledge. The trick here is to replace the original names of graphical objects by more friendly ones so the audience can understand the essence of the model being worked without worry about the tech details.
Also I decided to include a functionality to save and restore the majority of dialogs sizes and their positions, another long requested feature. This one can be useful for those who don't want pgModeler to resize the forms automatically everytime (specially when working in high resolution screens or dual monitors environments). This feature comes activated by default on new installations and can be deactivated at general settings.
More features were implemented in this release too, being some of them: the support to sequence options on indentity columns, the support to bulk data edition on data manipulation dialog, the support to paste CSV text from clipboard into the dialog where initial data can be specified for tables (in design view) and some other.
One important change done was a partial refactoring of the View editing form by moving the fields related to view's references to a dedicated dialog making the whole form a bit less complicated to use. I have plans to keep improving that dialog in special but in future releases a full UX/UI remodeling will be done in the application.
Below some of the changes of this release, for the complete list of changes, please, take a look into the CHANGELOG.md.
* [New] Added the support to cancelling SQL execution in SQLExecutionWidget. * [New] Added support to save/restore the dialogs sizes and positions. * [New] Added support to truncate tables in DataManipulationForm. * [New] Added support to aliases on some graphical objects to be is used in the compact view mode. * [New] Added support to save/load object's metadata containing aliases information. * [New] Added support to compact view of the model where graphical objects can have a more friendly name for a reduced view as well for those who don't need to see details about tables (clients of the business, for instance). * [New] Added support to sequence options for identity columns. * [New] Added the ability to paste CSV text from clipboard into the TableDataWidget. * [New] Added support to bulk data edit in TableDataWidget. * [Change] Changed the behaviour of the fade in/out of relationships linked to a table by applying the effect on the other tables that are related to the selected one. * [Change] Refactored the view editing dialog by moving the references handling form to a dedicated modal dialog. * [Change] Improved the model loading from file by blocking signals of relationships avoiding excessive/repetive rendering of objects. The whole model is fully rendered when the file was completely loaded. * [Change] Minor adjustment on constraints rendering at extended attributes section of tables. * [Fix] Minor fix on stylesheet in order to display the extended button on general toolbar. * [Fix] Fix a shortcut conflict in DataManipulationform. * [Fix] Fixed the offset of strings composing the StorageType. * [Fix] Minor fix in SQLExecutionWidget allowing the output widget to be resized to a size lower than the default one. * [Fix] Fixed the generation of Database object source in DatabaseExplorerWidget. * [Fix] Minor fix in HintTextWidget to stay on top of all widget when being displayed. * [Fix] Fixed a bug that was not quoting extension name when needed. * [Fix] Fixed a crash when trying to remove a fk relationship when it was created from a foreign key which references protected columns (added by relationship). * [Fix] Fix a crash when importing CSV files into DataManipulationForm.
Purchase
Purchase an access key and support this project. Pay using PayPal™ 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!