Almost two months after launching 1.1.0-alpha1, I'm pleased to announce 1.1.0-beta! This version is the last to receive new features in this development cycle, and from now on, until the release of the stable 1.1.0 only bug fixes will be done. That said, my main focus on this release was to work on two things that have always bothered me since the early days of pgModeler: the view creation process and the extension data types handling. Since the codebase was mature enough, it was time to change those two aspects of the tool. So now pgModeler has a simpler way to create views instead of that old clumsy interface to configure them in previous versions. The other improvement is related to extensions which can now have multiple child data types. Finally, as always, several improvements all over to tool were made as well as some bug fixes here and there. Everything is well explained in this post, so, don't skip it!

After working for four months, we are here to bring you the last alpha release of pgModeler 1.1.0. This version was mainly focused on improving performance on several parts of the tool. A lot of effort was put into refactoring lots of code which led to an amazing (almost unbelievable) result. Basically, pgModeler has improved by ~80% in the database model loading speed, validation, object searching, and other secondary operations. This release also brings some cool UI improvements and a new exclusive feature, named SQL session plugin, available on the paid version of the tool. Finally, as always, pgModeler received some patches that solved crashes and improved the existing features so the user experience could be more pleasant and the results produced could be more accurate with their needs. Everything is fully detailed in this post, don't skip this reading!

After five months of development, the first alpha release for pgModeler 1.1.0 is finally ready and brings some significant improvements compared to 1.0.x. The long-awaited code completion based on living database object names is now implemented in the tool. Also, pgModeler is now able to follow the system's color schema. Many other UI improvements were made attending to the users' requests. One of them is the ability to drag & drop .dbm files directly to the tool's main window to load models. In general settings, the database object shadows can be deactivated improving the rendering speed. The SQL execution widget and data manipulation form now support data exporting to CSV format besides the classic plain text format. In the SQL execution widget, when pasting SQL code coming from external IDEs, pgModeler will try to remove unneeded string concatenation characters in the clipboard text before inserting it in the input field. Finally, this version introduces the backup utility plugin, which implements a simple, user-friendly interface for the commands pg_dump, pg_dumpall, pg_restore, and psql. There's more to be detailed, don't let to read the full blog post!

Following the path to the stable release, today I present to you pgModeler 1.0.0-beta. The main focus of this release is to remove the support for PostgreSQL 9.x which has not been maintained for over a year. This release also brings minor improvements in several parts of the tool. Now, the data dictionary displays information related to indexes, triggers, and sequences used in the tables, making the generated file much more complete from the documental point of view. Another improvement was the ability to generate SQL code split in the command line interface which allows generating SQL by objects in separate files. In the model design area, the magnifier tool has improved to allow better object interaction. As part of the continuous enhancement in the UI and usability, navigating through form fields using shortcuts and tab keys has been improved to be much more consistent and intuitive compared to previous versions. These and some other fixes and changes are detailed in the full post, don't miss it!

After four long months of working, we finally have the first alpha release of pgModeler 1.0! The main goal of this version was to boot up a series of deep improvements in the UI adding visual comfort while using the software. So that was done, this one brings redesigned UI elements and colors, a completely new icon set, and officially introduces the new project logo. As promised, pgModeler 1.0.0-alpha brings a responsive UI adapting the widget sizes and icons according to the screen's resolution. Also, we now have the support for color themes which can be toggled on-the-fly in the appearance settings. I'll explain more about what's new in the full post, don't miss it!

It was quite a challenge to develop version 0.9.4 during the year 2021 but we finally made it, the last pgModeler of the series 0.9.x is ready! This one has a vast set of improvements over 0.9.3, being 51 new features, 104 enhancements, and 73 bug fixes that will make a big difference in the overall usage of the tool. In this post, I'll make a recap of all key features introduced by the alpha and beta versions and talk about the end of the development cycle of the series 0.9.x and my expectations on the development of pgModeler 1.0 in the next year.

This second alpha release brings minor improvements and small fixes being the last version released this year. Some importing issues related to PostgreSQL 10 were fixed and now the users can import their databases without much problem. The diff tool was enhanced in such way that now is possible to compare two databases and not only a model and a database. There were some changes on the database design view like the ability to create relationships more easily and the ability to fade in/out the objects in the result set of the object finder tool. More details in the full post, good reading!

After one year and three months of hard work I proudly present you the pgModeler 0.9.0. This version does not bring extraordinary changes or improvements compared to the previous alphas and betas but it closes one more development cycle delivering an even more refined product to our users keeping the main purpose of this project in mind: create a quality open source software. In order to give an idea on how this project have changed since last year, or since 0.8.2, if we place together all change log entries from the beggining of the 0.9.0 development we would have: 175 entries being them 51 new features, 58 changes/improvements and 68 bug fixes. These numbers only indicates how this project is being constantly enhanced through the years. In this post I'll briefly describe what's new, don't miss it!

This release was meant to be the final 0.9.0 but due to the several changes, bug fixes and new features introduced it was more prudent to bring it as the second beta instead of the stable version so we could gather as many as possible feedbacks and fix any remaining issue in order to finally launch the pgModeler 0.9.0 stable. The new pgModeler brings lots of new features mainly related to the database modeling, but there are several changes and fixes in other areas of the software that will make it even more reliable and easy to use.

This is the last release before we can finally launch the stable 0.9.0. The development of this version was mainly focused on improving the user's experience on high resolution monitors by introducing an automatic machanism that is capable to resize dialogs, objects and fonts according to the current screen settings. This support is quite experimental and will be polished in the next releases. Another feature introduced was the support to browse the referenced rows as well the referrer rows in data manipulation dialog which will improve the the whole data handling experience. How these features work, their drawbacks and limitations are fully explained in this post. Don't miss it!