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 10EA8D1C4D5; Thu, 31 Jul 2003 16:39:56 +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 61467-07; Thu, 31 Jul 2003 13:38:50 -0300 (ADT) Received: from davinci.ethosmedia.com (209-128-84-228.bayarea.net [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 62D96D1C4D0; Thu, 31 Jul 2003 13:39:53 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3364451; Thu, 31 Jul 2003 09:40:12 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Rory Campbell-Lange , Justin Clift Subject: Re: [GENERAL] interesting PHP/MySQL thread Date: Thu, 31 Jul 2003 09:38:31 -0700 User-Agent: KMail/1.4.3 Cc: Bruce Momjian , Joe Conway , "Advocacy (PostgreSQL)" , Cornelia Boenigk References: <200306211146.41852.josh@agliodbs.com> <3EF973C4.9070009@postgresql.org> <20030731115651.GB14574@campbell-lange.net> In-Reply-To: <20030731115651.GB14574@campbell-lange.net> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200307310938.31125.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/351 X-Sequence-Number: 1875 Rory, > 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" Also, several magazines ... such as Linux Magazine and Linux Journal, and possible Open ... would be happy to print a multi-part series on a simple PHP/PostgreSQL application. Either way, I'll be happy to participate. Plus, we're starting the overhaul of Techdocs so that posting articles will be easier. -- Josh Berkus Aglio Database Solutions San Francisco