X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6B4EFD1C7EB; Fri, 1 Aug 2003 13:48:32 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 40248-07; Fri, 1 Aug 2003 10:47:29 -0300 (ADT) Received: from roz (unknown [62.189.170.5]) by svr1.postgresql.org (Postfix) with ESMTP id 88AF4D1C518; Fri, 1 Aug 2003 10:48:31 -0300 (ADT) Received: from rory by roz with local (Exim 3.36 #1 (Debian)) id 19iaGk-0005JY-00; Fri, 01 Aug 2003 14:48:30 +0100 Date: Fri, 1 Aug 2003 14:48:30 +0100 From: Rory Campbell-Lange To: Josh Berkus Cc: Justin Clift , Bruce Momjian , Joe Conway , "Advocacy (PostgreSQL)" , Cornelia Boenigk Subject: Re: [GENERAL] interesting PHP/MySQL thread Message-ID: <20030801134830.GD20032@campbell-lange.net> References: <200306211146.41852.josh@agliodbs.com> <3EF973C4.9070009@postgresql.org> <20030731115651.GB14574@campbell-lange.net> <200307310938.31125.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200307310938.31125.josh@agliodbs.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1 X-Sequence-Number: 1879 Hi Josh On 31/07/03, Josh Berkus (josh@agliodbs.com) wrote: > > Another alternative is that I could write a newbie's gentle > > introduction to using pl/pgsql. With Josh's initial encouragement I > > have recently delivered a very successful project using Postgres > > functions. Development speed was greatly assisted by providing > > consistent database interfaces while the operations behind those > > interfaces could change. The system uses a combination of php and > > postgres, so I could hit some advocacy targets by describing the > > integration here! > > I would be delighted to co-write an article on PHP + Data-Push > Functions in PL/pgSQL architecture with you. > > For example, a fun one would be to do "Powerful search screens with > PHP, and PL/PgSQL Set Returning Functions" I have a little writing experience, although on the subject of architecture! I would be more than delighted to collaborate on writing something along the lines of what you suggest. A serious caveat is that I don't consider myself a good programmer. A possibly elegant approach to what you suggest is for us to dream up a PHP/Postgres task and for me as a relative newbie to provide a solution. You could then "crit" it (i.e. point out flaws and superior approaches), and this could become part of the basis for the article, or for explaining to readers why certain approaches have advantages over others. All the best, Rory -- Rory Campbell-Lange