U++ forum: Welcome to the forum

Re: postgresql mingw [message #51765 is a reply to message #51763]

Mon, 20 May 2019 02:25

mtdew3q
Messages: 181
Registered: July 2010
Location: Upstate, NY (near Canada)

Experienced Member

Hi all-
So I thought while I am trying to figure out what in the world is going on with PostgreSQL with mingw in U++ I had another idea. Everyone knows that mingw can be used with other frameworks so I tried to fire up libpqxx. Here is my printout:

checking for pkg-config... /mingw64/bin/pkg-config
configure: using PostgreSQL headers at c:/pgsql/include
configure: using PostgreSQL libraries at c:/pgsql/lib
checking c:/pgsql/include/libpq-fe.h usability... yes
checking c:/pgsql/include/libpq-fe.h presence... yes
checking for c:/pgsql/include/libpq-fe.h... yes
checking for ability to compile source files using libpq... yes

So everything was going great until with my bright idea tried to use the version 12 development branch and that is newer than the libpqxx on GitHub.

Well, I need pgsql to work so I will try to compile a different version of postgres with mingw.

I had to do some nifty configuring to get that to work. It (libpqxx configure script) couldn't find libraries or headers so I made one of these files (libpq.pc):
refix=/c/pgsql
exec_prefix=${prefix}/bin
libdir=${exec_prefix}/lib
includedir=${prefix}/include

Name: postgresql
Description: DB
Requires:
Version: 12.0
Libs: -Lc:/pgsql/lib
Cflags: -Ic:/pgsql/include

I hope that helps anyone wanting to get into SWIG with U++ and libpqxx. That way you can use tkinter with python and C++ or just Tk and C++ all with postgres.

I will return at a little later time once I get another version set up and see what I can't figure out about why I couldn't get U++ up and running with postgres on mingw.

Hope you are having a cool weekend. I am on a 3 day weekend. It has been fun.
thnx

later - Roboloki

Report message to a moderator