Once in a winter winter
I needed the day free of charge tool for database design. One that would also be able to generate scripts. Really like Visual Paradigm , but it costs, of course, like an airplane. Therefore, armed with Google and the advice of familiar developers, I went on a quest.
 
 
As a result, I found a very good tool pgModeler . The only thing I did not like was that sql-scripts can be generated only for PostgreSQL . But since At that time (and now, and even then) this database was used, then this tool was enough.
 
site project.
 
 
pgModeler is an Open Source project, but to get the binaries, you need to pay denyuzhku. Only source codes of the project are available You have to collect Using Qt
 
 
With Qt, I came across only once in my life - on the labs in the university, - and it was a long time and not true. Apparently, that's why I had some difficulties in assembling. Well, either because there were not so many useful articles (in fact, at that time I found only
? one
), And assembly documentation very scarce.
 
 
Well, let's move on to the assembly itself.
 
 

Environment

 
System: Windows 7 x64.
 
PgModeler version: ???-alpha.
 
PostgreSQL version: 10.4.
 
Qt: Qt ??? for Windows 32-bit (MinGW ???).
 
 

Assembling

 
The above instructions were written in accordance with the above environment.
 
 
 
Download source.
 
Download PostgreSQL.
 
Install in C: PostgreSQL.
 
IMPORTANT!
 
You can install it in any directory, but then you have to change the path in the assembly file. Also, there should not be spaces in the path, otherwise the collector will try to break this path into several.
 
 
Download Qt .
 
IMPORTANT!
 
You need to install a 32-bit version with MinGW even on a 64-bit system, because in nature there are only 32-bit versions of Qt and MinGW, which can work with each other.
 
 
Install Qt in C: QtQt???.
 
Add Paths to Qt and MinGW to the path environment variable.
 
 
Go to the ComputerProperties of the systemAdditional system parametersVarious variables System variablesPathChange.
 
Add to:
 
qmake - C: QtQt???.6.3mingw49_32bin.
 
mingw32-make - C: QtQt???Toolsmingw492_32bin.
 
 
 
 
In the sources in the pgmodeler.pri file, if necessary, change the paths.
 
Create the C: pgModeler folder for the compiled application.
 
Open cmd.
 
Go to the source folder using cd.
 
To configure the configuration files, execute
 
qmake PREFIX + = C: /pgModeler -r -spec win32-g ++ CONFIG + = release pgmodeler.pro
 
 
To compile the project, execute
 
mingw32-make -j5
 
 
To move the compiled files to C: pgModeler, execute
 
mingw32-make install
 
 
Go to the folder with the application
 
cd C: pgModeler
 
 
Copy Qt files to the application folder
 
windeployqt pgmodeler.exe
 
 
Copy the following DLLs to the application folder:
 
 
C: PostgreSQL10binlibeay32.dll
 
C: PostgreSQL10binlibiconv-2.dll
 
C: PostgreSQL10binlibintl-8.dll
 
C: PostgreSQL10binlibpq.dll
 
C: PostgreSQL10binlibxml2.dll
 
C: PostgreSQL10binssleay32.dll
 
 
 
To run without Qt on the system, copy the following DLLs to the application folder:
 
 
C: QtQt???.6.3mingw49_32binQt5Network.dll
 
C: QtQt???.6.3mingw49_32binQt5PrintSupport.dll
 
 
 

Conclusion

 
Here, in general, that's all. I hope this article will be useful to someone.
 
 
 
I tried to understand how to build this application on the basis of articles . But the instructions are a little bit messy, sometimes incomprehensible and there are extra actions, for example, installing a third-party MinGW (by the way, I did not work with Qt 5.6.? because of what I had to move away from this article and figure out what and how) or downloading libxml? which is in PostgreSQL.
 
 
The official, "very useful", "understandable" and very "complete" instruction for assembling this application is here . True, it is in it they write about the compatibility of Qt and MinGW.