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.
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
), And assembly documentation very scarce.
Well, let's move on to the assembly itself.
System: Windows 7 x64.
PgModeler version: ???-alpha.
PostgreSQL version: 10.4.
Qt: Qt ??? for Windows 32-bit (MinGW ???).
The above instructions were written in accordance with the above environment.
Install in C: PostgreSQL.
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 .
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.
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.
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
To move the compiled files to C: pgModeler, execute
Go to the folder with the application
cd C: pgModeler
Copy Qt files to the application folder
Copy the following DLLs to the application folder:
To run without Qt on the system, copy the following DLLs to the application folder:
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.
It may be interesting