
The premier open-source modeling tool dedicated to the #PostgreSQL ecosystem. 🐘 Deep integration, professional features, and a flexible workflow! 🛠️
Brazil
Joined August 2012
- Tweets769
- Following16
- Followers1.4K
- Likes191
Good evening, everyone! It’s been a while since I last posted here... But I’m back to give you an update on the development of pgModeler 2.0.0-beta.
I’m happy to announce that about 50% of the model versioning plugin (git) is now implemented. Here is what we have so far:
• Detailed commit history display, featuring well-rendered forks and merges, along with badges indicating tags and branches.
• Detailed information for the selected commit under the "Commit Info" tab.
• List of modified files in each commit, including the number of additions and deletions per file, under the "Changed files" tab.
• Support for Diff and Blame views. By clicking on a file, a window opens providing instant access to changes and authorship for every line.
• Branch management: Creation, removal, and checkout (supporting both local and remote branches [detached HEAD]).
What’s still missing:
• Commit operations: commit, cherry-pick, revert, and restore.
• Basic repository operations: clone (with SSH/HTTPS authentication), pull, and push.
• Advanced operations: merge and rebase (the latter is still under study).
It might seem like a small list, but getting this into the UI — especially the history rendering — was a massive amount of work. Anyway, I’m very happy with the results. This is the core set of operations I want ready for the stable release of pgModeler 2.0. I’ll add more features in the future as they become necessary or requested.
The main goal of this plugin is, first, to provide a user-friendly interface for those not used to the Git command line. Second, it aims to make pgModeler an even more complete tool, ensuring users don't have to rely on external software in their data modeling workflow.
Finally, this plugin will be a perfect fit for the .sdbm format (split database model, available in pgModeler Plus), which was designed for easier versioning by splitting the model into multiple smaller files to simplify conflict resolution.
As with all other plugins, this will be exclusive to the pgModeler Plus version.
I'll bring more news soon! :)
It's happening! Soon, pgModeler Plus will be capable of performing database model versioning without leaving the GUI with the new versioning plugin that integrates with the git command. Another promised feature on the way! 🥳🥳
8
273
Hey there! Guess who is arriving with a refreshed UI!? 😎
pgModeler 2.0-alpha is ready for shipping. This week, I'll be working on the preparation for the (delayed 😅) launch. Great things are coming to our powerful tool. Stay tuned!
Hello, guys! I'm excited to announce that pgModeler 1.1.0-beta will bring a simplified way to create views and as a bonus, it'll be possible to create views that reference other views. The work is still in the early stages but the image below is the feature already in action. 🥳
Look what just arrived! 🤩 Now I can work better on improving the MacOs version of pgModeler! I can't express enough gratefulness for all donations that collaborated on acquiring this machine. Thanks wholeheartedly, everyone! ❤️ – at Palmas, Brazil
1
23
1,354
Hell yeah! I have great news for macOS users: today we've reached the campaign's goal! 🥳🥳 Thank you wholeheartedly to everyone that donated to this campaign 🩷! Finally, I'll be able to improve the tool's macOS port. So, now let's buy that Mac Mini M2! 🤓
Hello, guys! I would like to make a humble request to my dear followers. The Mac Mini campaign is almost 100%. So, if you didn't donate yet, please, go ahead. If you can't donate, help us by spreading the word about the campaign. Thanks in advance! 🙏😊pgmodeler.io/campaign
Hello, guys! I'm a bit absent lately that's because I'm working on patching pgModeler 1.0 & developing 1.1.0-alpha. I have a lot of ideas in mind for the new major version and one of them is a plugin that wraps pg_dump, pg_dumpall, and pg_restore commands, an old user's request!
1
8
797
Hey guys! I'm here to announce pgModeler 1.0.2 fixing some small bugs. Also, I want to share with you a long-awaited feature in 1.1.0-alpha that will improve the usage of the SQL tool: the code completion based on object names living on a database. 🎉😎
youtube.com/watch?v=DCwvwuCL…
Taking the opportunity, I want to announce the pgModeler now supports secure connections to database servers by using SSH tunnels! This feature is available in the paid version of the tool. All details will be provided in the release notes. 😎
youtu.be/YQ_eYGgqusw
5
383
I also take the opportunity to ask for donations to the Mac Mini M1 campaign. Sadly, we're only at 9% of the goal... So I really hope we can reach the goal really fast if you help to spread the campaign or make your donation!😁 pgmodeler.io/campaign
1
It seems that Twitter doesn't like 4k videos. 😅
So, here's a better video: youtube.com/watch?v=vUboh9rM…
1
Here's the first official pgModeler plugin made by the project's author himself! 😁 The quick edit allows one to search for the desired object and open the related editing dialog. This is a well-known feature on many IDEs, and arrives in pgModeler to improve the user experience!
Great news! pgModeler 1.0.0-alpha1 is now fully ported to Qt 6, taking advantage of all toolkit's improvements including better support for hi-dpi screens. The video below gives you a hint on how is possible to tweak the entire UI to fit your needs!
youtube.com/watch?v=Ud0Nxi9j…
Off-topic: today I found a relic from the times when pgModeler (formerly called pgsqlDBM) was being developed in 2006. This book is maybe one of the most known by Brazilian IT students and served as the basis for the modeling concepts adopted by pgModeler. Great memories! 🤩 – at Palmas, Brazil
7
... and here it is! The themes support in 1.0.0-alpha is working as planned. For now, themes have hardcoded settings, but in future releases I plan to allow users to create their own themes. Who's excited for starting using the dark theme? 🙋🏽♂️
youtu.be/23flOcxrc5Y – at Palmas, Brazil
pgModeler 1.0 configuration form was slightly redesigned. Controls related to canvas colors and source code style were moved to "Appearance" settings, opening the path to the dark theme support. 😎



















