Design, Configure, Deploy
See all
Members (628)
Raphael Araújo's profile photo
Marco Antonio Sanchez's profile photo
Leonardo Santos da Mata's profile photo
Mike Sherrill's profile photo
Junior Cesar's profile photo
Dhruvin shingala's profile photo
Radha Gayam's profile photo
Net Zealous's profile photo
omar silva's profile photo
VIPIN PATEL's profile photo
Arvind verma's profile photo
Antoine Medvedev's profile photo
CoreMaapR Technical Learning Services's profile photo
Aleksandr Beliavski's profile photo
Erik Hernandez's profile photo
Eliseu Schmidt (WolfCWB)'s profile photo
Василий Бахарев's profile photo
Rafael Oliveira's profile photo
Boubacar Moumouni Kaougé's profile photo
Nelson Kenji's profile photo
Jose ribeiro neto's profile photo
Jeff Egan's profile photo
Renato Gómez Gómez's profile photo
daniel gomez's profile photo

Stream

Join this community to post or comment

Sarah Jones

Discussion  - 
 
Ein Blick auf Andl

Die neue Datensprache Andl ist ein großartiges neues Open Source-Projekt, das Sie kennenlernen sollten.
Erfahren Sie jetzt alles Wissenswerte über Andl!
 ·  Translate
Die neue Datensprache Andl ist ein großartiges neues Open Source-Projekt, das Sie kennenlernen sollten. Erfahren Sie jetzt alles Wissenswerte über Andl!
1
Add a comment...
 
Hi +Raphael Araújo​,
for some time now there is an idea going around in my head. Would it be possible to have database changes done with the PostgreSQL Database Modeler saved and read with Switch (http://sqitch.org/)?
That would give the Modeler an interface to work with more than just one developer on a database model. In addition one gets the ability to deploy database changes easily.

Let me know, what you think about it. And thanks a lot for your work on the PostgreSQL Database Modeler.
Sqitch is a database change management application. What makes it different from your typical migration-style approaches? A few things: No opinions. Sqitch is not integrated with any framework, ORM, or platform. Rather, it is a standalone change management system with no opinions about your ...
1
Add a 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
6
Сергей Костюченко's profile photo
5 comments
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
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...

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
6
1
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...

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

Luís de Sousa

Discussion  - 
 
HI everyone. Can anyone explain why pgModeler presents field types that do not exist in Postgres, like "tinterval"? Thanks.
1
Add a comment...

Natalia Guevara

Discussion  - 
 
amigos tengo una consulta
me esta ocurriendo este problema , aca la EÑE (
Ñ ), va despues de la ENE ( N ) y la DOBLE ELE ( LL ), va despues de la (L ).
Pero cuando intento ordenar los apellidos la EÑE, se ubica antes que la letra ' A ', y la doble ele " LL ", tampoco se ubica correctamente despues de la ELE " L ".


Si tienen un ejemplo de los comandos mucho mejor, soy nuevo en este mundo
del Postgres.
 ·  Translate
1
Natalia Guevara's profile photoDragi Raos's profile photo
3 comments
 
This will (hopefully) work as expected only if you use Unicode, employ digraph for LL (https://en.wikipedia.org/wiki/Ll), and specify Unicode collation with correct locale.

HTH
Add a comment...

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
9
1
Marc Cousin's profile photo
 
A great tool just became greater :) Thanks for all the hard work.
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
2
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...

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 photoHumberto Ibanez's profile photo
2 comments
 
I did what is suggested by Костюченко and more:
createdb -T template0 -E UTF8 --lc-collate=en_US.UTF8 --lc-ctype=en_US.UTF8 db_name

But the validator is not being able to validate the imported model.
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! 
8
Stefanie Janine Stölting's profile photo
 
Thank you for your tremendous work
Add a comment...