Design, Configure, Deploy
See all
Members (521)
Raphael Araújo's profile photo
2ndQuadrant Latinoamérica's profile photo
Alice - Lidia's profile photo
Abigail Anzola's profile photo
Accede Holdings's profile photo
anirban basu's profile photo
Andrew Taylor's profile photo
Altamiro Rodrigues's profile photo
Andreya Curitibana's profile photo
André Sékou ZONGO's profile photo
Aheli Banga (Oli)'s profile photo
Andre Otto's profile photo
Amine Bensalah's profile photo
Alfredo Marcillo's profile photo
Albert Mikaelyan (Tahvok)'s profile photo
Alberto Gaburro's profile photo
Alvaro Neto's profile photo
Aleksandar Tokarev's profile photo
Aleksandr Beliavski's profile photo
Alhassan Hakami's profile photo
Alex Louis's profile photo
alexis hayro MV's profile photo
Alexandre Soares's profile photo
Ameba Softwares's profile photo

Stream

Join this community to post or comment

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.8.1-alpha is out! **

This is the first alpha release for the upcoming patch version 0.8.1. It brings some small fixes for bugs reported in the 0.8.0 including a fix for Windows version which had some problems related to configuration files not being correctly copied as well to the "DLL entry point not found" error. Additional improvements were done here and there to make the tool even better. Refer to CHANGELOG.md to the complete list of news/changes/fixes.

I'm planning to make the development timeline for 0.8.1 shorter than 0.8.0. Also, we'll have two patch releases (0.8.1 and 0.8.2) as usual before start to work on the major release 0.9.0 (no release date yet).

Well, that's it!
Don't forget to submit any bugs at GitHub!

Changelog:
https://github.com/…/pgmodel…/blob/v0.8.1-alpha/CHANGELOG.md

Binaries:
http://www.pgmodeler.com.br

Source code:
https://github.com/pgmodeler/pgmodeler/releases
4
Сергей Костюченко's profile photo
5 comments
Add a comment...
 
---Hola comunidad, Al querer instalar Slony-l (para hacer replicaciones) me aparece el error de la imagen, Alguno de ustedes conoce la solución ?
 
---Hello community , Wanting to install Slony -l ( for replication ) shows me the error image , any of you know the answer.
 ·  Translate
2
Add a comment...

Fernando Pineda

Discussion  - 
 
He compilado #pgModeler en Linux, varias versiones. Pero en windows parece ser una tarea imposible... ¿Alguien tienen algun manual completo o algo por el estilo que solucione los errores? (aclaro no soy muy bueno el windows o por lo menos no tanto como en linux)
 ·  Translate
1
André Krebs's profile photoFernando Pineda's profile photo
2 comments
 
ok, gracias.
 ·  Translate
Add a comment...

Andrew Yanick

Discussion  - 
 
Hello Raphael,
First of all, congratulations for the work you are doing for pgModeler. Looking at the past the updates are very good.

But don`t you think is awkward to release so many binaries and ask everytime people to pay for them? More than that I see the price is growing and growing.
Isn`t better to ask a decent price for just a release and then put changes into updates?

The version I am using now is 0.7.1. I didn`t bought 0.7.2, because I was afraid of a too faster release and paying again...now I see the latest is 0.8.0. If I buy, what to do with older versions and with money?
1
Raphael Araújo's profile photo
 
Hi, Andrew.

Thank you for the feedback. I'm glad to see that you're enjoy my project.

About the "so many binaries", actually, we have a set of download modalities. The most basic one is the download of a single release for a specific platform and the most expensive is the download of any release for any platform. All download concessions (let's say this way) will last for one year. So, for gold, platinum and diamond ones you'll have the chance to download all versions released in a year.

About the price, is not that is growing and growing... I've made some small adjustment to compensate the conversion between USD to BRL, but I know that charge a big price is not a good idea so the adjustment will be small and will have a limit. But, IMHO, the price is not that big if you compare the price of pgModeler against the proprietary tools on the market that do the same task.

About the fear of too fast releases... In previous post here in the community I've said that the release of stable versions will be delayed for two reasons: 1) to be able to better test the code base; 2) to give user a reasonable time to use their previosly bought version. 

Recently, an user suggested me to do a "demo" version to give the chance to test some key functionalities before take the decision to buy the software's binary. The demo binaries are already available.

Finally, I'm all ears for suggestions. I wont repeat myself why I charge for binaries but I hope someday pgModeler is supported by some enterprise in such way that I can return to release binaries free of charge. If you are interested in talk about this all in details we can discuss via e-mail (I don't like to write big posts here in G+ is kinda annoying :) )

Thanks!
Add a comment...

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.8.0-alpha1 is out! **

Despite the designation "alpha1" this release brings important improvements on stability and speed being more reliable than the current stable release 0.7.2. The key features of this version are:

1) It's possible to handle table's data through the data grid feature on SQL tool. ATTENTION: this is an experimental feature. Do not use the data manipulation in production environments.

2) Several improvements on SQL tool related to command execution, database objects handling and small fixes here and there;

3) Improved validation process being faster and less crash prone as older versions.

4) Improved code generation speed by polishing the cached code mechanism;

5) Improved startup speed by allocating the majority of dialogs and controls on demand and no more at startup time.

6) Added two new sample models. Those models can be opened directly from the main window's central widget.
You can get full details about changes here:
https://github.com/pgmodeler/pgmodeler/blob/v0.8.0-alpha1/RELEASENOTES.md

Note: the models generated in previous versions (include 0.8.0-alpha) will demand some patches through the model fix dialog.
Enjoy this new release and don't forget to submit bugs to github.com/pgmodeler/pgmodeler/issues

Binaries:
http://pgmodeler.com.br
5
1
Stefanie Janine Stölting's profile photo
Add a comment...
 
Muy buenas tengo problemas al tratar de usar el comando make install me genera la siguiente error :

cd plugins/xml2object/ && ( test -e Makefile || /home/gabo/Qt/5.2.1/gcc_64/bin/qmake /opt/pgmodeler/plugins/xml2object/xml2object.pro -o Makefile ) && make -f Makefile install
make[1]: se ingresa al directorio «/opt/pgmodeler/plugins/xml2object»
cp build/libxml2object.so /opt/pgmodeler/build/plugins/xml2object > /dev/null
install -m 644 -p /opt/pgmodeler/plugins/xml2object/res/xml2object.png /opt/pgmodeler/build/plugins/xml2object/
install -m 644 -p /opt/pgmodeler/plugins/xml2object/xml2object.json /opt/pgmodeler/build/plugins/xml2object/
make[1]: se sale del directorio «/opt/pgmodeler/plugins/xml2object»
cp -f -R /opt/pgmodeler/samples /opt/pgmodeler/build/
cp -f -R /opt/pgmodeler/schemas /opt/pgmodeler/build/
cp -f -R /opt/pgmodeler/lang /opt/pgmodeler/build/
cp -f -R /opt/pgmodeler/conf /opt/pgmodeler/build/
install -m 644 -p /opt/pgmodeler/pgmodeler.vars /opt/pgmodeler/build/
install -m 755 -p /opt/pgmodeler/start-pgmodeler.sh /opt/pgmodeler/build/
strip /opt/pgmodeler/build/start-pgmodeler.sh
strip:/opt/pgmodeler/build/start-pgmodeler.sh: No se reconoce el formato del fichero
make: [install_pgmodeler_data] Error 1 (no tiene efecto)

Mi pregunta es cual es el motivo de error ¿??
 ·  Translate
1
Add a comment...
 
I  try to install pgmodeler on ubuntu but i can't it doesn't work. I install all the requirements and when i put "make" at the end i had the "error 3" Can anyone help me?
2
stefanny zuñiga's profile photoAndré Krebs's profile photo
7 comments
 
+stefanny zuñiga  Open the terminal, as root the command chmod +x start-pgmodeler.sh on file. Of the command ./start-pgmodeler.sh. 
Add a comment...

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.7.2-beta1 is out! **

That's it, people! The last beta release is waiting your download! As I told in previous posts I would not add new features until the 0.8.0, but I broke the promise... this release contains four small new features, three of them related to PostgreSQL 9.4! 

There are some not critical bug fixes just to enhance the tool's usage. Also, with the development of this release I could find an important bug (unkown cause and not fixed yet) that can lead to crashes on MacOSX system when compiling pgModeler with Qt 5.3. The workaround was to revert back to Qt 5.2.1 the default framework version. I intend to take care of this problem only in 0.8.0 development.

More details of this version is available on change log:
https://github.com/pgmodeler/pgmodeler/blob/v0.7.2-beta1/CHANGELOG.md

Binary download:
http://pgmodeler.com.br/

Enjoy! 
2
Add a comment...

Raphael Araújo
owner

Discussion  - 
 
Good morning, guys!

How many of you makes use of "event triggers" and "unlogged tables" here? I'm thinking to put those features on next 0.7.2 or 0.8.0. Are those feature worth of implementation? Give your opinion! 

Have a nice sunday!
1
Add a comment...
 
Open Source software is licensed so you can download and use the software free-of-charge. The source code for the software is made available free-of-charge, you (or a programmer you hire) can make changes to the software to better meet your needs, and you can release your changed code back to the community passing the benefit on to other users.

That is the meaning of open source.
Even if you, Raphael Araújo, made the source code free-of-charge, you don`t have an open source software.

On the other hand, I donated to you since version 0.6.2, then payed for 0.7.0 and I will not do the mistake again, because the improvements are too few and unnoticeable.
2
Raphael Araújo's profile photo
 
First, the main meaning of Open Source Software is the freedom to get, modify and redistribute its SOURCE CODE!

Second, in my understanding, pgModeler is OSS even the binaries being charged because, in no moment, I've closed the source, instead, I encourage people to take it and do changes or redistribute as they wish.

Third, I'm very grateful for you donation and payment. But tell that the improvements are too few and unnoticeable is a little bit harsh! Have you ever read one of the change logs? See the amount of bug fixes or improvements present on the timeline of one release to see how it can change:
https://github.com/pgmodeler/pgmodeler/blob/v0.7.2-beta/CHANGELOG.md

Finally, even the GPL permits selling open source software. Read here: http://www.gnu.org/licenses/gpl-faq.en.html#DoesTheGPLAllowMoney
So tell me, what I'm doing wrong?

Thus, if you think its a "mistake" to pay for pgModeler then go ahead, get the source code and compile it for yourself! Link: https://github.com/pgmodeler/pgmodeler/releases

Good luck and have a nice day.
Add a comment...
 
Help!
#pgModeler has two nasty bugs:

1.
Create trigger procedure.
Create trigger on table.
Validate -> ERROR
DECISION: replace procedure before trigger in XMLfile.
Validate -> Success

2. 
Switching keyboard layout by Ctrl-Shift (Russian<->English)
First character in any field don't entered


My distr is #Fedora 20 x86_64
1
Юрий Корик's profile photoRaphael Araújo's profile photo
3 comments
 
Ok. I'll register myself the issues. I'm glad to see pgModeler is being useful to you! Little by little we're improving it... By the way, thanks for the feedback. 
Add a comment...

About this community

PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database clusters from version 8.0 to 9.1.
Brazil

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.8.0 is out! **

After eight months working on create an even more improved product the final 0.8.0 is done. This version is the best one ever created because the software is more stable, reliable, useful and beautiful.
Compared to the previous release (0.7.2) this one has a lot more features that will surely improve the database design. Also, there are new features to help user in manage live databases.

To give an idea on how pgModeler has changed since 0.7.2, the full change log for the new release has 349 entries, being 85 new features, 147 changes and 117 bug fixes. Detailed changes available on CHANGELOG.md.

Obviously, not all new features or changes will be noted since they were created to help in bug fixes but what matters is that pgModeler is now a better product.

Some key features of this new version are:

1) Optmized layout: the entire layout was improved, separating portions of the software in form of views (welcome, design and manage) giving users a better usage experience. Also, as part of layout improvements, the database model objects are now more clean and smooth being more pleasing to the eyes.

2) Faster code generation: the SQL and XML code generation speed was increased by introducing the cached code feature. With this feature the loading, saving and export processes are more faster speeding up the productivity.

3) Per-user configurations: pgModeler now is capable to store its settings separated for each user in the same system. This is quite handy when several users need to run the software with their own preferred settings without mess with others settings.

4) Model database diff: create SQL scripts containing all commands needed to keep synchronized both model and database. With the diff feature you can make changes on a living database without drop it and recreate from the model that originate it. Just do the needed changes on the model and compare it to the database, pgModeler will handle the rest creating DDL commands and storing them on a file or applying directly to a server. NOTE: this is an experimental feature so it may fail in some cases.

5) Improved reverse engineering: the import process is even better. Free from a lot of bug of previous releases the import permits user to create partial models by importing only a few set of objects or the entire database as he wishes. This process now is capable to solve automatically the majority of problems related to object's dependencies that previous versions could not handle.

6) Improved SQL tool: being now a dedicated section of the software the SQL tool (manage view) is even better. Now its possible to handle several databases, manage table data through the data manipulation dialog and run SQL commands directly on the server. In this release, SQL code snippets were introduced in order to help users to create and execute SQL commands when working on a database.

7) Improved model validation: the main source of crashes in previous releases the validation process was carefully improved being more stable and reliable by fixing the majority of model inconsistencies that may appear during the design time.

8) Improved model export: several bugs were fixed on the model export process. Additionally, user now have the option to run DROP commands before create an object directly on the database. This is useful when you do not want to drop the entire database in order to recreate the objects.

9) Miscellaneous: several bug fixes throughout the subprojects, ability to drop objects in cascade way during design, several improvements on quick actions menu when two or more objects are selected, several improvements on the configuration sections and much more.

So, what comes next? 
First, the author will go on a vacation to refresh his mind! Emoticon smile
Second, the user's guide will be completely updated to include new features of release 0.8.0.
Finally, the project's site will be completely redesigned.

I'm not planning to release any patch version in the next 30-45 days but if some severe bug is discovered I'll not hesitate in implement a fix and release it. But if the bug is a simple one I prefer to be focused on the tasks mentioned before.

I really proud of this work and I hope will all like it! Emoticon wink
See you!

Binaries:
http://pgmodeler.com.br

Source:
http://github.com/pgmodeler/pgmodeler/tags
7
1
Marc Cousin's profile photoAlfredo Marcillo's profile photo
 
A great tool just became greater :) Thanks for all the hard work.
Add a comment...
 
Hi comunidad, disculpen alguien que pueda apoyarme para hacer la instalacion en windows, ya he probado de todo y no logro compilar, agradeceria cualquier suguerencia
 ·  Translate
1
Juan Ivan De La Cruz Flores's profile photoFernando Pineda's profile photo
3 comments
 
pague la suscripción completa y vale como 100.000 pesos(colombianos), pero solo para windows sale como por 7 dolares (14000)pesos
 ·  Translate
Add a comment...

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.8.0-alpha2 is out! **

Hello again followers!

I'm here to announce the third alpha of the version 0.8.0. In this release, important bugs reported since alpha1 were fixed. 
Additionally, some improvements were made, some of them are:

1) The code now compiles and runs fine on the latest Qt 5.3.2 in all supported platforms.

2) The creation of graphical objects was simplified being more quick the use of keyboard to create objects. By default those objects will be created on the center of canvas in one step instead of the two needed in previous versions (this behavior can be changed on settings)

3) Added an option to disable render smoothness to improve performance on large models (this behavior can be changed on settings).

4) If the user try to save or export a model and it is invalidated, pgModeler will first validate and then proceed with the pending operation (this behavior can be changed on settings).

In total, we have 37 change log entries, being 9 new features, 12 changes and 16 bug fixes. Details about them can be found here:
https://github.com/pgmodeler/pgmodeler/blob/v0.8.0-alpha2/RELEASENOTES.md

I need to apologize because there was a huge delay between 0.8.0-alpha1 and alpha2. This because I was facing some personal problems which prevented me to work on the project. I'll try to resume the 20 days release cycle, so I hope until october 20th we have the first beta with the model-database diff with basic functionalities.

That's it!
Binaries already available for download at http://pgmodeler.com.br/

Enjoy! 
3
1
Fernando Pineda's profile photo
Add a comment...
 
CSV A comma-separated values (CSV) file is any file containing text that is separated with a comma, but can also be a file separated with any other c...
1
Stefanie Janine Stölting's profile photo
 
What does it have to do with a PostgreSQL database designer?
Add a comment...

Daniel Garcia

Discussion  - 
 
Hello guys,

I just wanted to ask a question.
Do we really need to install postgresql database on the machine where we want to install pgmodeler?
Or only the postgresql client install is necessary?

Thanks!
1
Raphael Araújo's profile photoDaniel Garcia's profile photo
2 comments
 
Ok .... 

thanks Raphael!
Add a comment...
 
Instalei os requerimentos mas nao consigo abrir o pgmodeler nao tenho nenhum erro! compilo o pgmodeler o que sai na janela.
szuniga@szuniga:~/Descargas/Instaladores/pgmodeler-0.7.2$./start-pgmodeler.sh
./start-pgmodeler.sh: línea 16: pgmodeler: orden no encontrada
 ·  Translate
1
stefanny zuñiga's profile photoFernando Pineda's profile photo
3 comments
 
ok
Add a comment...

André Krebs

Discussion  - 
 
I can not export, of the following error: 
Could not execute the SQL command. Message returned: ERROR: new collation (pt_BR.UTF8) is incompatible with the collation of the template database (en_US.UTF-8) HINT: Use the same collation as in the template database, or use the template template0.
1
Сергей Костюченко's profile photo
 
You need to recreate database:
createdb -T template0 -E UTF8 databasename
Add a comment...

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.7.2 is out! **

Finally, the last release of 0.7.x serie is ready! A lot of work was done to give this version more stability and improved usage. Some features I would like to highlight are:

1) The addition of jsonb data type as preparation for PostgreSQL 9.4 which is in beta stage.

2) Enabling of PostgreSQL 9.4 for import and export purposes.

3) Introduction of a new object type: event triggers.

4) The "new object overlay" in order to quickly create objects on the model.

5) The update notifier that will popup whenever a new version is available for download.

6) An experimental installer for Linux systems as a facility over the current tarball. Actually, the installer just extracts the files on the selected folder and gives some instructions on how to run pgModeler. This will be improved as new releases come out.

In total, we have 62 change log entries divided in: 15 new features, 16 changes or improvements, 31 bug fixes. Please, take a look on the RELEASENOTES.md file for details about this new version.

With this release I officially finish the 0.7.x series. In a few days I'll start to prepare my work on 0.8.0. My main goal for this version is the model-database sync but some new features may be included on this journey! 

Finally, until the end of the next week the updated version of User's guide will be available on official site.

Release notes:
https://github.com/pgmodeler/pgmodeler/blob/v0.7.2/RELEASENOTES.md

Binaries and source:
http://pgmodeler.com.br/

I hope you have a lot of fun with this new release!
See you! 
7
Stefanie Janine Stölting's profile photo
 
Thank you for your tremendous work
Add a comment...

Raphael Araújo
owner

Discussion  - 
 
** pgModeler 0.7.2-beta is out! **

This release contains fixes for the bugs reported for the 0.7.2-alpha1. The only feature available in this release is the capability to convert an integer column to serial when its default value is a call to function nextval('seq'::regclass). To do that, right-click the column and select "Convert to serial".

With this release we're one step from the final 0.7.2. After that, the 0.7.x will be closed and all my work will be concentrated in the 0.8.0!

Enjoy!

Changelog:
https://github.com/pgmodeler/pgmodeler/blob/v0.7.2-beta/CHANGELOG.md

Download:
http://pgmodeler.com.br/
3
Add a comment...