Source of the document: Achived on 2006-Jun-07. 
Path: tagtrade.org!not-for-mail
From: "Felix E. Klee" <felix.klee@inka.de>
Newsgroups: tagtrade.devel
Subject: Task: Port of SelectQuery to PostgreSQL
Date: Wed, 07 Jun 2006 09:33:03 +0200
Lines: 70
Message-ID: <87fyih2zf4.wl%felix.klee@inka.de>
NNTP-Posting-Host: pd9e3ab5e.dip.t-dialin.net
Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka")
Content-Type: text/plain; charset=US-ASCII
X-Trace: tagtrade.org 1149665583 71938 217.227.171.94 (7 Jun 2006 07:33:03 GMT)
X-Complaints-To: usenet@tagtrade.org
NNTP-Posting-Date: Wed, 7 Jun 2006 07:33:03 +0000 (UTC)
User-Agent: Wanderlust/2.14.0 (Africa) SEMI/1.14.6 (Maruoka) FLIM/1.14.7
 (=?ISO-8859-4?Q?Sanj=F2?=) APEL/10.6 Emacs/21.4 (i486-slackware-linux-gnu)
 MULE/5.0 (SAKAKI)
X-Smtpserver: localhost:1125
X-Newsserver: news.tagtrade.org:119
Xref: tagtrade.org tagtrade.devel:1

For usage as part of TagTrade.org's portal, the PMwiki cookbook recipe
SelectQuery needs to be ported.

The problem:

  SelectQuery 1.0 only works with a MySQL database.  At TagTrade.org,
  however, we will likely set up a PostgreSQL database, part of which
  should be accessible through PMwiki.

The task:

  Write a variant of SelectQuery version 1.0 (or higher) which
  interfaces with PostgreSQL version 7.3.

Info about the recipe:

  http://www.pmwiki.org/wiki/Cookbook/SelectQuery

Conditions:

  The first one to accomplish the task will receive 20 EUR.  In case he
  follows the process outlined in the URN X-trade a.0.1 specifications
  (see below), then he'll receive an additional 10 EUR.  Following the
  process is strongly encouraged - guidance will be provided by me, upon
  request.

  Payment will be through bank transfer, Paypal, or whatever else is
  convenient for the person who provided the first solution and for me.

The URN X-trade a.0.1 specifications:

  http://www.tagtrade.org/Main/URNXTradeA-0-1

About tag trade:

  http://www.tagtrade.org/

What to do next:

  * If you have any questions, just post them in a follow up to this
    message.

  * If you start working on the task, then post a follow up to the
    current message, together with a tag such as the following:

    <this-X-trade:strt:
    from=your@em.ail;date=2006-06-07:
    task_from=felix.klee@inka.de;task_date=2006-06-07;
    tild=2006-06-10:
    a.0.1>

    Be sure to adapt the fields "from" (your email address), "date" (the
    current date, in GMT), and "tild" (when you plan to be finished, in
    GMT) correspondingly.

<this-X-trade:task:
from=felix.klee@inka.de;date=2006-06-07:
tild=2006-07-01:
a.0.1>

<this-X-trade:paym:
from=felix.klee@inka.de;date=2006-06-07:
task_from=felix.klee@inka.de;task_date=2006-06-07;
mini=20;maxi=30;curr=EUR:
a.0.1>

-- 
Felix E. Klee
Naunynstr. 2, 76530 Baden-Baden, Germany
Tel.: +49 7221 396961, Fax: +49 7221 396960, Mobile: +49 174 1386060