What are some open-source applications written in C/C++ using PostgreSQL?

Question

I'm trying to find open source applications using PostgreSQL that are written in C/C++ so I can study them. A few open source projects using PostgreSQL are Evergreen ILS, SpamAssassin, and pgpool. However, Evergreen and SpamAssassin are written in Perl, and pgpool (written in C) is a replication tool, not a typical application. Moreover, I looked at the SQL code in Evergreen, and it is quite voluminous and complicated.

Hence, I'm looking for one or more applications using PostgreSQL, preferably those that are somewhat trivial (but not too trivial).

Note: I ran apt-cache rdepends libpq5 in Ubuntu and got a few results. The most promising one I saw was dovecot. However, like many others, dovecot has its own database library rather than using libpq inline. I'm thinking I would be better off doing what many other projects do and use a wrapper instead of libpq (PostgreSQL's C API). — Joey Adams
– Joey Adams, Commented Nov 16, 2009 at 21:00

just somebody · Accepted Answer · 2009-11-16 20:27:13Z

1

seen libpqxx? try asking on its mailing list (but scour their wiki first)

http://pqxx.org/development/libpqxx

answered Nov 16, 2009 at 20:27

just somebody

19.4k6 gold badges55 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Joey Adams Over a year ago

Thanks. However, libpqxx is a binding, not an application, meaning its code might not really demonstrate how to use libpq in the context of business logic.

just somebody Over a year ago

yup. that's why i didn't simply point you at it. it's a c++ library to access postgresql, you're bound to find a few oss applications mentioned in the wiki and/or mailing list archives.

Jordan S. Jones · Accepted Answer · 2009-11-16 20:43:50Z

1

pgAdmin is written using c++ using wxwidgets.

answered Nov 16, 2009 at 20:43

Jordan S. Jones

13.9k5 gold badges47 silver badges50 bronze badges

Comments

dschulz · Accepted Answer · 2009-11-16 20:50:41Z

1

how about pgAdmin 3 ?

Also, you may find Qt4 a very easy way interact with databases programming in C++. http://doc.trolltech.com/4.6-snapshot/sql-programming.html

answered Nov 16, 2009 at 20:50

dschulz

4,8161 gold badge34 silver badges31 bronze badges

Comments

user212986 · Accepted Answer · 2009-11-17 15:44:48Z

0

Have you searched through the projects at http://pgfoundry.org ?

answered Nov 17, 2009 at 15:44

user212986

Comments

jtv · Accepted Answer · 2009-12-08 03:56:35Z

0

Two examples that are open-source:

Kexi (see kexi-project.org)
FOST4 ( http://support.felspar.com/Fost%204 )

answered Dec 8, 2009 at 3:56

jtv

1

Comments

HitScan · Accepted Answer · 2011-05-11 00:39:01Z

0

It's pretty big, but the KDE Project's Amarok is written in C++ and can use a PgSQL backend (among several others). While it's pretty large, you may be able to find some interesting things in the database code. Since it uses a pre-defined schema (as opposed to the extremely general types of access that something like pgAdmin uses) it may have some good things to teach you. It will definitely be easier to pick apart than Evergreen, which actually has an entire middleware layer that actually does the data access through exposed services (The OpenSRF Project).

answered May 11, 2011 at 0:39

HitScan

8,7993 gold badges25 silver badges17 bronze badges

Collectives™ on Stack Overflow

What are some open-source applications written in C/C++ using PostgreSQL?

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related