X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6227E5280D for ; Fri, 24 Jun 2005 12:06:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64469-09 for ; Fri, 24 Jun 2005 15:06:38 +0000 (GMT) Received: from mail.dialmex.net (67.107.77.98.ptr.us.xo.net [67.107.77.98]) by svr1.postgresql.org (Postfix) with ESMTP id 088E9528AD for ; Fri, 24 Jun 2005 12:06:37 -0300 (ADT) Received: from david.dialmex.net (dmxnocws13.dialmex.net [67.107.77.78]) by mail.dialmex.net (Postfix) with ESMTP id E61B2EE98F; Fri, 24 Jun 2005 10:06:35 -0500 (CDT) Received: by david.dialmex.net (Postfix, from userid 4001) id E37711460EE1; Fri, 24 Jun 2005 10:06:35 -0500 (CDT) Subject: Re: Driver for Gnome/GTK Applications..... From: David Stanaway To: Landon Blake Cc: pgsql-interfaces@postgresql.org In-Reply-To: <4FEA62844670C04B907701DF410B16EB0D7ED8@plotroom.domain.ksninc.pvt> References: <4FEA62844670C04B907701DF410B16EB0D7ED8@plotroom.domain.ksninc.pvt> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 24 Jun 2005 10:06:35 -0500 Message-Id: <1119625595.720.9.camel@david.dialmex.net> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/62 X-Sequence-Number: 5630 Hi there, libpq is the C client library for postgresql, and it is pretty well documented, well designed and fast. There are some database abstraction libraries also which you can use, including libodbc, libdbi and libgnomedb http://www.unixodbc.org/ http://libdbi.sourceforge.net/ http://www.gnome-db.org/ I haven't used any of these, although the perl dbi interface (Which I think the C libdbi is influenced by) is something I have used, and it is very good. Maybe some other people have some experience with these abstraction libraries and can say which to avoid etc. On Thu, 2005-06-23 at 14:17 -0700, Landon Blake wrote: > I have recently moved to a Linux environment from Windows. I know that you can connect to PostgreSQL via JDBC with Java and ODBC with Microsoft programs, but what is the best way to connect to PostgreSQL from an application written to run on Linux? I will most likely be writing the GUI with GTK and Gnome. Any suggestions? > > Thanks, > > Landon > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- David Stanaway