Return-Path: postman Delivery-Date: Wed, 20 Oct 93 15:21:57 PDT Return-Path: postman Received: by postgres.Berkeley.EDU (5.61/1.29) id AA23936; Wed, 20 Oct 93 15:17:32 -0700 Resent-From: postman (POSTGRES mailing list) Resent-Message-Id: <9310202217.AA23936@postgres.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: bambi@Bond.edu.au Received: from kirk.Bond.edu.au by postgres.Berkeley.EDU (5.61/1.29) id AA23928; Wed, 20 Oct 93 15:17:24 -0700 Received: from fiddich.its.Bond.edu.au by kirk.Bond.edu.au using SMTP (5.65b) X-Return-Path: Received: by fiddich.ITS.BU.OZ.AU (5.65b) id AA27683; Thu, 21 Oct 93 08:19:26 +1000 Date: Thu, 21 Oct 1993 08:14:57 +1000 (EST) From: "David J. Hughes" Subject: Re: better programming interface ? To: Niranjan Perera Cc: postgres@postgres.Berkeley.EDU In-Reply-To: <9310201639.AA17615@gis.lislab.uga.edu> Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-dist Resent-Date: Wed, 20 Oct 93 15:17:31 PDT On Wed, 20 Oct 1993, Niranjan Perera wrote: > The current libpq interface is nice, but a lot of work needs to be done by the programmer if > one wants to access any of the data. I put together a simple interface (not OO, sorry) for work I'm doing under Postgres. You pass it queries and it returns linked lists of the data found. All the data is returned to the application in the one call rather than cycling through it, element by element, with fetch. That code is included in the relshow package available from :- Hostname : kirk.Bond.edu.au IP Addr : 131.244.1.1 Path : /pub/Bond_Uni/relshow It's simple and clean and easy to use. It may help you out. I have also written a perl package that offers the same interface to pgperl users although that's not in the relshow distribution. (mail me if you're interested). ___ David J. Hughes bambi@Bond.edu.au / \ / / / / __/ __ __ ____/ / / __ Senior Network Programmer / \ / \ / \ / / / / / \ / Information Technology Services \____/ \__// / \__/ \___/ / / / Qld. 4229 AUSTRALIA (+61 75 951450)