Thread: DB connectivity using C

Hi,

Are there any methods to connect to a database (say postgresql) using C?


Thanks,
Angshu

http://www.google.co.uk/search?q=postgresql+C+API

also google for ODBC, which is probably the most common way.

postgresql's homepage has an ODBC driver which you can download.

there are also docs for the c api to postgres

thank you google.

Originally Posted by xhi

there are also docs for the c api to postgres

thank you google.

If you use libpq (and I think it is pretty good, I work with it on a daily basis) you have to remember to use the PQclear call to free memory that PostgreSQL allocates on your behalf (usually results and connection pointers, PGres* and PGconn*) so that you eliminate memory leaks.

That's not always intuitive if you use the same pointer over and over again.

Good luck!

Originally Posted by fgw_three

If you use libpq (and I think it is pretty good, I work with it on a daily basis) you have to remember to use the PQclear call to free memory that PostgreSQL allocates on your behalf (usually results and connection pointers, PGres* and PGconn*) so that you eliminate memory leaks.

That's not always intuitive if you use the same pointer over and over again.

Good luck!

Good Advice, thanks.