PostgreSQL Database Modeler

PostgreSQL Database Modeler (pgModeler) allows a webmaster to create his own database schema using a simple drag&drop GUI and render the necessary SQL code to create it.

A plugins system is packaged with pgModeler, so functionality can be extended by anyone interested to do so.

The download package contains only the source code. However, instructions on how to compile the code on various OSs are included.

What is new in this release:

• New:
• Added support to multiple SQL execution widget instances for the same browsed database in SQL tool.
• Added truncate table actions on DatabaseExplorerWidget.
• Changed:
• Minor adjustments on ModelValidationHelper.
• Minor adjustments on CustomSQLWidget.
• Included the delete cascade action to Edit menu in MainWindow.
• Minor widget adjustments on ModelDatabaseDiffForm.
• Minor improvements when saving temp models. Now the saving thread will not run if the diff/export/import dialogs are focused avoiding (rare) race conditions.
• Improved the update notifier to display a recover link and purchase link on the "Get binary package" button menu.
• Minor adjustment on output icons at ModelExportForm.
• Improvement on DatabaseModel::getObjectReferences to retrieve indexes as references to columns. This solve the bug related to import and diff processes that was causing detached columns to be dropped even if there were indexes referencing those columns.
• Added a more friendly error message when the user try to undo/redo an invalid operation at operations history.
• Minor improvement on ConnectionsConfigWidget adding the ability to make the configured initial database to be auto browsed when using the connection to manage objects on Manage view.
• Fixes:
• Fixed the output of SQL commands on diff, import and export. The commands now does not comes without original line breaks.
• Fixed unexpected dialog blockings and form resetting on diff and export dialogs when minimizing and restoring the application.
• Fix a crash when converting a serial column to sequence in which the first is not assigned to a primary key.
• Minor fix on crash handler startup. Now exceptions occurred during the process are printed to stdout.
• Fix a crash when pasting objects right after closing the source model (from where the objects were copied/cut).
• Minor fix on ModelWidget::showObjectForm to correctly show permissions details.
• Minor fix on the import process. Now the majority of problems related to objects that are created before their dependencies are solved.
• Fixed some bug related to object duplication error treatment on ModelExportHelper.
• Fixed a crash on connections config dialog when user removed a single connection and close the application, causing segmentation fault.
• Minor fix on SQLToolWidget to avoid the disabling of SQL command input and controls when a database is dropped and there is at least one database being browsed.
• Minor fix on session saving process.
• Fixed a bug that was causing relationship points to be moved twice when multiple objects were selected on the canvas area.
• Fixed some syntax errors on snippets.conf file.
• Fixed a bug that was preventing global settings for relationships to be persisted.
• Fixed a bug when importing permissions related to functions.
• Minor fix on signal/slot connection order in NewObjectOverlayWidget.
• Minor improvements on swap objects ids dialog.

What is new in version 0.8.0 / 0.8.1-alpha1:

• New:
• Added support to multiple SQL execution widget instances for the same browsed database in SQL tool.
• Added truncate table actions on DatabaseExplorerWidget.
• Changed:
• Minor adjustments on ModelValidationHelper.
• Minor adjustments on CustomSQLWidget.
• Included the delete cascade action to Edit menu in MainWindow.
• Minor widget adjustments on ModelDatabaseDiffForm.
• Minor improvements when saving temp models. Now the saving thread will not run if the diff/export/import dialogs are focused avoiding (rare) race conditions.
• Improved the update notifier to display a recover link and purchase link on the "Get binary package" button menu.
• Minor adjustment on output icons at ModelExportForm.
• Improvement on DatabaseModel::getObjectReferences to retrieve indexes as references to columns. This solve the bug related to import and diff processes that was causing detached columns to be dropped even if there were indexes referencing those columns.
• Added a more friendly error message when the user try to undo/redo an invalid operation at operations history.
• Minor improvement on ConnectionsConfigWidget adding the ability to make the configured initial database to be auto browsed when using the connection to manage objects on Manage view.
• Fixes:
• Fixed the output of SQL commands on diff, import and export. The commands now does not comes without original line breaks.
• Fixed unexpected dialog blockings and form resetting on diff and export dialogs when minimizing and restoring the application.
• Fix a crash when converting a serial column to sequence in which the first is not assigned to a primary key.
• Minor fix on crash handler startup. Now exceptions occurred during the process are printed to stdout.
• Fix a crash when pasting objects right after closing the source model (from where the objects were copied/cut).
• Minor fix on ModelWidget::showObjectForm to correctly show permissions details.
• Minor fix on the import process. Now the majority of problems related to objects that are created before their dependencies are solved.
• Fixed some bug related to object duplication error treatment on ModelExportHelper.
• Fixed a crash on connections config dialog when user removed a single connection and close the application, causing segmentation fault.
• Minor fix on SQLToolWidget to avoid the disabling of SQL command input and controls when a database is dropped and there is at least one database being browsed.
• Minor fix on session saving process.
• Fixed a bug that was causing relationship points to be moved twice when multiple objects were selected on the canvas area.
• Fixed some syntax errors on snippets.conf file.
• Fixed a bug that was preventing global settings for relationships to be persisted.
• Fixed a bug when importing permissions related to functions.
• Minor fix on signal/slot connection order in NewObjectOverlayWidget.
• Minor improvements on swap objects ids dialog.

What is new in version 0.7.2 / 0.8.0-beta2:

• New:
• PostgreSQL version 9.3 activated on code base. Now import and export operations works with this new version.
• Change:
• The way inheritance is created. Now the INHERIT command is appended in the table's definition.
• Update on model validation. Generalization and copy relationships have the participant tables' id's validated in order to check reference breaking.
• Version info upgraded on MacOSX app bundle configuration file (Info.plist).
• Minor change on "pgmodeler.vars". Included environment variables for custom Qt installation.
• Fixes:
• Fixed a bug related to INSTEAD OF/ON UPDATE triggers on views.
• Fixed a bug related to incorrectly error raised when setting a owner table in the same schema as the sequece.
• Fixed a bug related to importing sequences which name has uppercase characters.
• Fixed misspelled "Connetion" word on configuration form.

What is new in version 0.6.0:

• Added a validation when removing protected FK relationships.
• Added a progress info (at bottom widgets bar) for temporary model saving.
• User can now restore the last session via File > Restore Session. Sessions will not be restored at startup anymore.
• Added a "zoom" option when exporting to PNG image.

What is new in version 0.5.0:

• pgModeler now aborts app closing when the user wants to do a last saving on modified models.
• Added support to hide relationship labels and table extended attributes on configuration dialog.
• Added "Recent Models" menu.
• Introduced the Xml2Object plugin to help on develpment testings.
• Added partial support to PostgreSQL Extensions objects.
• Added JSON datatype.
• Added support for rules and trigger on views.
• Added support for user defined range types.
• Added support for collations on composite types (user defined).
• Added built-in range types.
• Added support to INCLUDING/EXCLUDING options when dealing with copy relationships.
• Added support for EXCLUDE constraint support
• Added NO INHERIT option to check constraints.
• Added REPLICATION option to roles.
• Added FOR ORDER BY option and removed Recheck from OperatorClassElement.
• Added collation support for index elements.
• Added [NOT] LEAKPROOF key word to functions.
• Added collation attribute to domains.
• Required fields are now highlighted on editing forms.

What is new in version 0.4.1-rc1:

• Changes:
• User can now prepend a CTE (commom table expression, a.k.a "with queries") on view's definition.
• User can now create a single reference containing a expression that defines the entire view.
• Improvements on permissions, user now can control GRANTs and REVOKEs via permission editing form.

What is new in version 0.3.3:

• Changes:
• pgModeler license were update to GPLv3.
• Error massages and entire UI were translated to en_US. Now people can contribute more easily with translation files.
• The left side image were removed form all forms giving more space to show widgets.
• pgModeler now shows a messagebox at startup if any critical error is raised instead to show them on stdin.
• Fixes:
• Translation files now are correctly loaded depending on system language.
• Compilation process and execution is working correctly on Windows system.

What is new in version 0.3.2:

• Changes:
• The default extension for the models now stands for ".dbm".
• Tables and sequences now can be used as function return type as well parameter type. This is valid for other objects that make use of base types (except for table columns).
• The relationship conversion command now need to be confirmed by the user.
• Fixes:
• Compilation process now works correctly on Windows system.
• Adjusted the size of some forms to show their fields properly.
• The "make distclean" command now make the correct cleanup on build/ directory.
• Startup scripts "start-pgmodeler.(sh|bat)" where adjusted. To prevent errors pgModeler need to be started through these scripts.
• Corrected the reference to the plugins directory.
• The action "New Object -> Tablespace" now is displayed properly.

Requirements:

• PostgreSQL 8 or higher