On Tue, 2022-06-21 at 10:56 +0800, Rino Mardo wrote: > hi. i found odbc.postgresql.org when i was looking for a way to hook up my > c++ project to postgresql server. > installed it and tested to be successful in connection. this was when i had > postgresql > running from a virtualbox vm in Ubuntu. > > i installed a postgresql container using Docker for Windows in my laptop. > from a Windows terminal i can > connect to the postgresql container and from there use psql client to create > database. > > when postgresql was running in an Ubuntu vm in virtualbox, i wasn't able to > test the c++ connection. > now i want to but can't find a way how. either from python or any programming > language. > > i guess my problem is more of the programming than db server side but i > thought to try asking here > in case someone can help. thanks.
I am surprised that you choose to be fettered by the constraints of a generic API like ODBC. For me, that only makes sense if you want to be portable to different databases. I would use the powerful C API of libpq, or, if you want some C++ boilerplate around it, use libpqxx. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
