• Guest
HabraHabr
  • Main
  • Users

  • Development
    • Programming
    • Information Security
    • Website development
    • JavaScript
    • Game development
    • Open source
    • Developed for Android
    • Machine learning
    • Abnormal programming
    • Java
    • Python
    • Development of mobile applications
    • Analysis and design of systems
    • .NET
    • Mathematics
    • Algorithms
    • C#
    • System Programming
    • C++
    • C
    • Go
    • PHP
    • Reverse engineering
    • Assembler
    • Development under Linux
    • Big Data
    • Rust
    • Cryptography
    • Entertaining problems
    • Testing of IT systems
    • Testing Web Services
    • HTML
    • Programming microcontrollers
    • API
    • High performance
    • Developed for iOS
    • CSS
    • Industrial Programming
    • Development under Windows
    • Image processing
    • Compilers
    • FPGA
    • Professional literature
    • OpenStreetMap
    • Google Chrome
    • Data Mining
    • PostgreSQL
    • Development of robotics
    • Visualization of data
    • Angular
    • ReactJS
    • Search technologies
    • Debugging
    • Test mobile applications
    • Browsers
    • Designing and refactoring
    • IT Standards
    • Solidity
    • Node.JS
    • Git
    • LaTeX
    • SQL
    • Haskell
    • Unreal Engine
    • Unity3D
    • Development for the Internet of things
    • Functional Programming
    • Amazon Web Services
    • Google Cloud Platform
    • Development under AR and VR
    • Assembly systems
    • Version control systems
    • Kotlin
    • R
    • CAD/CAM
    • Customer Optimization
    • Development of communication systems
    • Microsoft Azure
    • Perfect code
    • Atlassian
    • Visual Studio
    • NoSQL
    • Yii
    • Mono и Moonlight
    • Parallel Programming
    • Asterisk
    • Yandex API
    • WordPress
    • Sports programming
    • Lua
    • Microsoft SQL Server
    • Payment systems
    • TypeScript
    • Scala
    • Google API
    • Development of data transmission systems
    • XML
    • Regular expressions
    • Development under Tizen
    • Swift
    • MySQL
    • Geoinformation services
    • Global Positioning Systems
    • Qt
    • Dart
    • Django
    • Development for Office 365
    • Erlang/OTP
    • GPGPU
    • Eclipse
    • Maps API
    • Testing games
    • Browser Extensions
    • 1C-Bitrix
    • Development under e-commerce
    • Xamarin
    • Xcode
    • Development under Windows Phone
    • Semantics
    • CMS
    • VueJS
    • GitHub
    • Open data
    • Sphinx
    • Ruby on Rails
    • Ruby
    • Symfony
    • Drupal
    • Messaging Systems
    • CTF
    • SaaS / S+S
    • SharePoint
    • jQuery
    • Puppet
    • Firefox
    • Elm
    • MODX
    • Billing systems
    • Graphical shells
    • Kodobred
    • MongoDB
    • SCADA
    • Hadoop
    • Gradle
    • Clojure
    • F#
    • CoffeeScript
    • Matlab
    • Phalcon
    • Development under Sailfish OS
    • Magento
    • Elixir/Phoenix
    • Microsoft Edge
    • Layout of letters
    • Development for OS X
    • Forth
    • Smalltalk
    • Julia
    • Laravel
    • WebGL
    • Meteor.JS
    • Firebird/Interbase
    • SQLite
    • D
    • Mesh-networks
    • I2P
    • Derby.js
    • Emacs
    • Development under Bada
    • Mercurial
    • UML Design
    • Objective C
    • Fortran
    • Cocoa
    • Cobol
    • Apache Flex
    • Action Script
    • Joomla
    • IIS
    • Twitter API
    • Vkontakte API
    • Facebook API
    • Microsoft Access
    • PDF
    • Prolog
    • GTK+
    • LabVIEW
    • Brainfuck
    • Cubrid
    • Canvas
    • Doctrine ORM
    • Google App Engine
    • Twisted
    • XSLT
    • TDD
    • Small Basic
    • Kohana
    • Development for Java ME
    • LiveStreet
    • MooTools
    • Adobe Flash
    • GreaseMonkey
    • INFOLUST
    • Groovy & Grails
    • Lisp
    • Delphi
    • Zend Framework
    • ExtJS / Sencha Library
    • Internet Explorer
    • CodeIgniter
    • Silverlight
    • Google Web Toolkit
    • CakePHP
    • Safari
    • Opera
    • Microformats
    • Ajax
    • VIM
  • Administration
    • System administration
    • IT Infrastructure
    • *nix
    • Network technologies
    • DevOps
    • Server Administration
    • Cloud computing
    • Configuring Linux
    • Wireless technologies
    • Virtualization
    • Hosting
    • Data storage
    • Decentralized networks
    • Database Administration
    • Data Warehousing
    • Communication standards
    • PowerShell
    • Backup
    • Cisco
    • Nginx
    • Antivirus protection
    • DNS
    • Server Optimization
    • Data recovery
    • Apache
    • Spam and antispam
    • Data Compression
    • SAN
    • IPv6
    • Fidonet
    • IPTV
    • Shells
    • Administering domain names
  • Design
    • Interfaces
    • Web design
    • Working with sound
    • Usability
    • Graphic design
    • Design Games
    • Mobile App Design
    • Working with 3D-graphics
    • Typography
    • Working with video
    • Work with vector graphics
    • Accessibility
    • Prototyping
    • CGI (graphics)
    • Computer Animation
    • Working with icons
  • Control
    • Careers in the IT industry
    • Project management
    • Development Management
    • Personnel Management
    • Product Management
    • Start-up development
    • Managing the community
    • Service Desk
    • GTD
    • IT Terminology
    • Agile
    • Business Models
    • Legislation and IT-business
    • Sales management
    • CRM-systems
    • Product localization
    • ECM / EDS
    • Freelance
    • Venture investments
    • ERP-systems
    • Help Desk Software
    • Media management
    • Patenting
    • E-commerce management
    • Creative Commons
  • Marketing
    • Conferences
    • Promotion of games
    • Internet Marketing
    • Search Engine Optimization
    • Web Analytics
    • Monetize Web services
    • Content marketing
    • Monetization of IT systems
    • Monetize mobile apps
    • Mobile App Analytics
    • Growth Hacking
    • Branding
    • Monetize Games
    • Display ads
    • Contextual advertising
    • Increase Conversion Rate
  • Sundry
    • Reading room
    • Educational process in IT
    • Research and forecasts in IT
    • Finance in IT
    • Hakatonas
    • IT emigration
    • Education abroad
    • Lumber room
    • I'm on my way

Build pgModeler

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.

It may be interesting

  • Comments
  • About article
  • Similar news
This publication has no comments.

weber

Author

16-09-2018, 07:16

Publication Date

UML Design / SQL

Category
  • Comments: 0
  • Views: 567
DEV Labs 2018. Online MAP for web
How Microsoft rewrote the C # compiler
Create a trigger function in pgModeler
Oracle vs PostgreSQL. Why choosing
We search for the reasons of brakes of
Collaboration Visual Studio Code and
Write a comment
Name:*
E-Mail:


Comments
Global Dezigns is a Website Development Company in Karachi, Providing services of
website design in karachi
. We are delivering the best partnership across Pakistan. provides a complete range of web development services including web applications, website hosting and maintenance, domain registration, on-page search engine optimization, and website integration with social media platforms such as Facebook, Twitter, LinkedIn, Google Maps, and Google Local Directory. We believe we are well placed to take our knowledge and expertise to the logical next level with the latest web standards.  
  Show/hide text
https://www.globaldezigns.com/



Yesterday, 22:45

mike tomlin

This blog is really great. The information here will surely be of some help to me. Thanks!.mastering physics

Yesterday, 17:57

raymond weber

Coinyspace is the cryptocurrency community and trading forum where members can find any contributors of crypto ecosystem like currencies, exchanges & merchants. Check Out: Bitcoin Merchants
Yesterday, 16:57

noorseo

This is a great high resolution screen which you have shared for the users. Making a website is not an easy task but managing a good website is really a hard work. As far as this website is concerned, I am very happy.https://19216801.1
Yesterday, 16:01

nushra45

i'm satisfied to deem this make recognized Very beneficial for me, as it contains lot of advice. I usually favor to buttonhole The excellent and glad i found this count number in you assertion. thanks Subliminal Hypnosis
Yesterday, 14:56

jahangirkhatri

Adv
Website for web developers. New scripts, best ideas, programming tips. How to write a script for you here, we have a lot of information about various programming languages. You are a webmaster or a beginner programmer, it does not matter, useful articles will help to make your favorite business faster.

Login

Registration Forgot password