Softpedia >Mac >Developer Tools >PostgreSQL Database Modeler >  Changelog

PostgreSQL Database Modeler Changelog

What's new in PostgreSQL Database Modeler 0.7.1

Apr 28, 2014
  • [New] Added option to invert panning mode and range selection triggers.
  • [New] Added support to use relationship attributes as special primary keys.
  • [New] Created a small interface to pgmodeler-cli that enables the user to fix a broken model inside pgModeler GUI.
  • [New] Added support to assign a sequence as default value of a column. The sequence will be converted to "nextval('seqname'::regclass) and the validation process will check if the sequence is correctly referenced by the table that owns the column.
  • [Change] Improvement on unique name generation for columns and constraints when connecting relatioships.
  • [Change] Improvement on copy / paste operations.
  • [Change] Minor workaround in order to try to fix the crash due to thread conflict mainly on Windows system.
  • [Change] Minor change on project's description text on about dialog.
  • [Change] Changed the default behavior of left click on blank areas of canvas. Instead of create a range selection the user will move the viewport (panning mode). To enable range selection user must press SHIFT and click/move to draw the selection rectangle.
  • [Change] Major model validation improvement. Now special objects are correctly validated.
  • [Fix] Minor fix on custom columns positioning.
  • [Fix] Input and output files are now correctly escaped on the model fix form and the process works fine.
  • [Fix] Workaround for the slow editing of function's definition. Disabled the automatic syntax highlighting.
  • [Fix] Minor fix on reverse engineering process. In some cases the process was aborted due to duplication of relationships caused by an incorreclty name generation for this kind of object.
  • [Fix] Minor fix on model objects widget when changing the visible object types.
  • [Fix] Fixed the conflict with panning mode and graphical object addition operation.
  • [Fix] Fixed a regression introduced by 0.7.1-beta on model fix process.
  • [Fix] Minor fix on connection class in order to accept empty passwords as well passwords that contains spaces.
  • [Fix] Fixed the column listing on constraint editing form after remove one or more columns.
  • [Fix] Fix a crash when canceling the model saving dialog on Windows.
  • [Fix] Minor patch on the model fix process.
  • [Fix] Fixed wrong default values for relationship added columns.
  • [Fix] Fixed a bug related to file paths with ampersand on config files.
  • [Fix] Fix the broken sql for inheritance when a child table don't have columns but only constraints.
  • [Fix] Fixed a crash when closing a model that contains a view that references columns added by relationships.
  • [Fix] Fixed wrong working directory handling on CLI.
  • [Fix] Fixed a bug on file loading process that could left behind some objects depending on size and arrange of the loaded model.
  • [Fix] Fixed the undesired behavior when moving a table to another schema.
  • [Fix] Fixed connection config. Empty passwords are now accepted.
  • [Fix] Fixed schema object code generation.
  • [Fix] Fixed the usage of PGMODELER_SCHEMAS_DIR environment variable on import process.
  • [Fix] Fixed "ALTER ... SET OWNER" DDL for materialized views.
  • [Fix] Fixed duplicated semicolon at end of permissions defintion.

New in PostgreSQL Database Modeler 0.7.0 (Mar 25, 2014)

  • [New] Addded a catalog attribute "hide-postgres-db" in order to avoid listing "postgres" maintainance DB on import operations.
  • [New] Added options to hide system/extension objects on SQL tool improving the object listing performance.
  • [New] Added support to custom compilation output directory through qmake variables BINDIR, LIBDIR and RESDIR.
  • [New] Added support to deferrable unique, exclude and primary key constraints.
  • [New] Added support to custom colors on tables and views through tag objects.
  • [New] Added support to export models to png image page by page.
  • [New] Canvas can now be moved using Control + Arrow keys. If the shift is pressed the movement factor is increased.
  • [New] Introduced the SQL tool that permits the execution of arbitrary SQL commands direclty on a server.
  • [New] Added methods getType, getTypeId to BaseType and getSQLTypeName to PgSQLType as an alternative to call operators ~, ! and *.
  • [New] Added a commented DROP command at start of each object definition (CREATE or ALTER TABLE ADD)
  • [New] Added a "Code Preview" tab on permissions dialog.
  • [New] Enabled SQL code visualization for FK relationships.
  • [New] Added a build number on about dialog. This number is the compilation date in format yyyymmdd.
  • [New] Added support for materialized and recursive views (PostgreSQL 9.3 feature).
  • [New] Added pgModeler version information on generated sql scripts as well .dbm files for debugging purpose.
  • [New] Added support to custom delete/update actions for relationship generated foreign keys.
  • [New] Added support to move the canvas by positioning the mouse over corners.
  • [New] Added a configuration parameter to control font style for any source code highlight field.
  • [New] Added additional PostGiS types: geomval, addbandarg, rastbandarg, raster, reclassarg, unionarg, TopoGeometry, getfaceedges_returntype, validatetopology_returntype.
  • [Change] Added support to on-demand updates on sql tool object's tree.
  • [Change] Improved the tab navigation experience on editing forms.
  • [Change] Minor change on SQL tool to ommit binary data values.
  • [Change] Dropped the navigation through object using Alt + due to the difficulty to understand the order in which objects are highlighted.
  • [Change] Minor change when generate .stacktrace file for crash handler to include pgModeler build number.
  • [Change] Minor adjustments on DatabaseImportForm's import execution progress.
  • [Change] Minor enhancements on operation list when removing last operations.
  • [Change] Minor enhancements on table and relationship dialogs on error control flow.
  • [Change] Changed Z-value for relationship labels in order to avoid that name labels don't overlaps the cardinality labels.
  • [Change] Removed the translation installing from within plugin loading method at PluginsConfigWidget.
  • [Change] The Application class constructor now loads at once all translation files available for the current language including language file for plugins.
  • [Change] Minor changes on deploy scripts on all platforms. The parameter '-with-build-num' was introduced in order to generate a package with build number.
  • [Change] Relationship dialog enhanced. Now participant tables are described in what role they make part.
  • [Change] Minor improvement on model export process.
  • [Change] Minor improvement on model validation widget.
  • [Change] Minor improvement on crash handler report generation message. Full path to crash file is now shown.
  • [Change] Improved the message displayed when user try to save an invalidated model.
  • [Change] Minor adjustment on model export dialog size.
  • [Change] Minor improvement on model overview widget.
  • [Change] Minor adjustments on window title buttons for model export and database import forms.
  • [Change] Improvement on connection config form. pgModeler now ask to save/update unsaved connection if the user forgot to.
  • [Change] Minor update sql syntax highlighting configuration file.
  • [Fix] Fixed bug that was permitting paste already formatted text (html) on source code input fields.
  • [Fix] Fix broken range type generation.
  • [Fix] The DELETE privilege is now correclty saved on model.
  • [Fix] Fixed drop object command on SQL tool.
  • [Fix] Fixed bug that was crashing pgModeler when a error was raised on view edit form.
  • [Fix] Fixed a bug that was crashing the application when deleting relationship attributes or constraints.
  • [Fix] Fixed bug related to the range selection weird behavior when finishing creating a object.
  • [Fix] Minor fix on OperationList undo/redo methods to update types names on tables that references a modified type.
  • [Fix] Minor fix on View assignment operator to correctly rename the type associated with "this" object.
  • [Fix] Minor fix on DatabaseModel to correctly return the references to a view type.
  • [Fix] Fixed bug that was causing indexes/triggers that references columns added by relationship have the sql code generated twice.
  • [Fix] Minor fix on ResultSet class to identify bytea columns.
  • [Fix] Minor fix on CLI menu to add new export modes.
  • [Fix] Fixed a crash dealing with duplicated columns on a table.
  • [Fix] Fixed bug when deleting tables and fk relationships together.
  • [Fix] Fix bug related to geometry type.
  • [Fix] Minor fix on logical expressions evaluation on SchemaParser.
  • [Fix] Minor fix on model export when showing the name of objects being exported.
  • [Fix] Minor fix on list/view advanced objects of a relationship.
  • [Fix] Minor fix on form resizing when showing the protected object alert.
  • [Fix] Fixed a minor bug that was crashing pgModeler when visualizing many-to-many relationships.
  • [Fix] Fixed some warnings triggered by clang compiler.
  • [Fix] Fixed a crash when loading plugins on MacOSX.
  • [Fix] Fixed the issue related to import roles from database. pgModeler will not query pg_shadow anymore since this view is a very restricted object. Now role passwords will be imported as ****(according to docs).
  • [Fix] Fixed the object name validation. pgModeler now accepts spaces within names.
  • [Fix] Fixed the function editing form resizing.
  • [Fix] Fixed a bug that was not loading "sql disabled" state for relationships.
  • [Fix] Fixed incorrect behavior of "Zoom In" action on MacOSX.
  • [Fix] Trying to fix the infinite loop of the Validation confirm dialog on Windows (more tests needed).

New in PostgreSQL Database Modeler 0.6.2 (Dec 20, 2013)

  • [Change] Update Qt version to 5.2.0 on build scripts (Windows only).
  • [Change] Linux binaries are now bundled with all needed Qt libs.
  • [Change] Important change on the way that special primary keys are created for generalization/copy relationships. Now there is the need to create the relationship first, close the dialog and open it again in order to generate the columns that will be used on the primary key.
  • [Fix] Workaround done on the sql append widget when handle a lot of code avoiding slowdowns on the syntax highlighting.
  • [Fix] Fixed the incorrect creation of foreign keys on many-to-many relationships.
  • [Fix] Fixed the conversion of self many-to-many relationships.
  • [Fix] Fixed a bug that was causing some constraints to be destroyed when the relationship was connected to the table that owned the constraint.
  • [Fix] Comments that contains apostrophes now are correctly escaped in order to avoid SQL related errors.
  • [Fix] Fixed the incorrect generation of SQL code of check constraint associated to many-to-many relationships.
  • [Fix] Minor fix on crash handler when trying to read an stack trace file that doesn't exists.
  • [Fix] Minor typos fixes on CLI menu.
  • [Fix] Minor fix on the about form positioning.

New in PostgreSQL Database Modeler 0.6.1 (Nov 13, 2013)

  • [New] PostgreSQL version 9.3 activated on code base. Now import and export operations works with this new version.
  • [Change] Changed the way inheritance is created. Now the INHERIT command is appended in the table's definition.
  • [Change] Update on model validation. Generalization and copy relationships have the participant tables' id's validated in order to check reference breaking.
  • [Change] Version info upgraded on MacOSX app bundle configuration file (Info.plist).
  • [Change] Minor change on "pgmodeler.vars". Included environment variables for custom Qt installation.
  • [Fix] Fixed a bug related to INSTEAD OF/ON UPDATE triggers on views.
  • [Fix] Fixed a bug related to incorrectly error raised when setting a owner table in the same schema as the sequece.
  • [Fix] Fixed a bug related to importing sequences which name has uppercase characters.
  • [Fix] Fixed misspelled "Connetion" word on configuration form.
  • [Fix] Typos correction on model validation message box.
  • [Fix] Fixed incorrect objects removal after cancel the edition.
  • [Fix] Minor fix on disconnection of generalization relationships.
  • [Fix] Minor fix on updating table's graphical representation when importing primary keys.
  • [Fix] Minor change when displaying the columns' types on table/relationship editing form.
  • [Fix] Fixed the compilation process on MacOSX 10.9 (Mavericks).
  • [Fix] Minor change on macdeploy.sh to use Qt5.2-beta by default.