Download pgModeler 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. We also provide pre-compiled binary packages at a really fair price in order to gather financial support for the project. Purchased binaries grant access to exclusive features which are released from time to time!
Since this is an independent project with no sponsorship, buying any binary packages helps to keep the development activities at full speed, bringing lots of news periodically, as always!
Stable: 1.0.5 July 26, 2023
Changes since: v1.0.4
This patch release for pgModeler 1.0.x brings the following changes and fixes:
* Added shortcuts to Z-stack operations in ModelWidget.
* Added missing PostgreSQL multirange types.
* Improved the import error message when it's not possible to create/import permission that references a predefined PostgreSQL role.
* Minor code refactor in ObjectsScene and DatabaseModel.
* Fixed a bug in DatabaseModel that was causing FK relationships of a hidden layer to be displayed after loading the model.
* Fixed a bug in MainWindow that was causing the plugin's config action icon to disappear when triggering validation.
* Fixed a bug in PgModelerCliApp::fixModel that was causing the generation of empty models when the input file had no tag "role".
Develop: 1.1.0-alpha June 09, 2023
Changes since: v1.0.x Attention: Some configuration files were changed in pgModeler 1.1.0-alpha causing a break in backward compatibility with pgModeler 1.0.x settings. This way, at the first start of the newer version, pgModeler will try to migrate the older settings to the newer ones automatically!
After five months of development, the first alpha release for pgModeler 1.1.0 is finally ready and brings some important improvements compared to 1.0.x. Below, the key changes are briefly detailed: Improved code completion: A long-awaited feature is finally arriving pgModeler, the code completion based on living database object names. From now on, in the SQL execution widget, will be possible to list column/table names in the middle of the INSERT/DELETE/TRUNCATE/UPDATE commands. This feature also considers table aliases and lists the correct columns. It is worth mentioning that this feature is still experimental despite the good results on different kinds of SQL commands. Improved UI theme management: In 1.0.x, pgModeler wasn't able to correctly follow the system's color set (dark/light). Now, in 1.1.0-alpha, selecting "System default" UI theme in Appearance settings makes pgModeler properly configure the UI color theme as well as the source code highlight settings to follow the system's color schema. Several UI improvements: As always, general UI improvements are made attending to the users' requests. This time pgModeler brought a long list of enhancements, but the following ones are worth mentioning:
* pgModeler now supports the drag & drop of .dbm files selected in the file manager directly into the tool's main window to load models.
* Database object shadows can be now deactivated in the general settings. This feature improves the rendering speed since fewer objects per scene need to be handled.
* The SQL command results in the SQL execution widget and data manipulation form can be now exported to CSV format besides the classic plain text format.
* When pasting SQL code coming from external IDEs in SQL execution using Ctrl+Shift+V, pgModeler will try to remove unneeded string concatenation characters (e.g. " ' + .) in the clipboard text before inserting it in the input field. This is useful for testing SQL code written in other languages' source code using concatenated strings.
* Enclosing characters (),[],{} are now highlighted in any field where it's possible to type SQL code, being helpful to keep the balance of those characters avoiding syntax errors when running the typed commands.
* In order to display large data (e.g. bytea data) in the results grid without degrading the performance an option was added to general settings that toggle the truncation of column data that exceeds a certain limit. The truncated data can be fully visualized by double click the desired cell in the result grid.
* Now the SQL result grid header will display an icon according to the data type of each column.
* In data manipulation form when editing a single element with column data edit dialog, the form will display the current column's value. Bug fixes: Also, as part of the constant search for the overall tool's stability and reliability, almost twenty bugs were fixed, and below we highlight some key ones:
* Fixed a critical bug in pgmodeler-cli that was causing the generation of empty models when the input file had no roles configured.
* Fixed a bug in the database model that could lead to an "unknown exception caught" error.
* Fixed a bug in the CSV generation that was causing the creation of malformed CSV in some circumstances causing the initial table data corruption.
* Fixed some problems with comments when importing a database having the same OIDs for different types of objects.
* Fixed the diff process performed on legacy database versions. Backup utility plugin: This version introduces the backup utility plugin, available in the paid version of the tool, which implements a user-friendly interface for the commands pg_dump, pg_dumpall, pg_restore and psql. This extra feature was developed mainly focused on attending to those users less comfortable with command-line tools, being possible to dump and restore databases without leaving pgModeler's GUI. Of course, advanced users are welcome to use the plugin and help to improve it! In a nutshell, besides configuring the backup tools parameters with a simple form, it allows the creation of presets per backup tool for different needs, it also has some facilities that automate the backup file name generation by using a default backup folder and name patterns.
Finally, for more detailed information about this release's changelog, please, refer to the CHANGELOG.md file.
Purchase
Purchase an access key and support this project. Pay using PayPal™, Stripe™, or Bitcoins and enjoy ready-to-use packages.
Download
Use your access key to download binary packages.
Source
Grab the source code from the official repository and compile it yourself!
pgModeler has two main development branches: main and develop. The main branch is where features considered stable can be found. The development branch, reserved for alpha and beta releases, is where patches, new unstable features are placed and tested.
You can retrieve the source using the git command by running the following:
If you prefer, there are source tarballs ready to be compiled. Once you got the source, you can follow the instructions to compile pgModeler described in the Installation page.
Terms of Purchase & Download
Data Privacy Terms
Access key recovery
Preparing your
payment, please wait...
Do not close the page or cancel the loading!
Contact the developer
For feature requests or bug reports we kindly ask you to open a ticket on the GitHub issues page.