From: | Brian Modra <brian(at)zwartberg(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | Incredibly simple PostgreSQL to WEB GUI system |
Date: | 2009-11-23 13:19:27 |
Message-ID: | 5a9699850911230519u46d32752nc03f7796a6b95b7c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
Create an entire web application by just writing SQL, HTML, and some
XML configuration. No other coding, no PHP or C++, etc. is required...
though you can add that too, if you like. See:
http:/www.zwartberg.com/cave.html
Following is a very simplistic example of a "cave" service:
<database name="KarooDB" username="bmodra" password=""
connect_timeout="1" connection-pool-size="3"/>
<service name="list-stock" id="list-stock">
<sql>
select owner,type,value,count,id from
stock where owner=<parameter name="owner" type="quoted-string"/>;
</sql>
</service>
Following is the corresponding html:
<table>
<tbody>
<tr>
<th>owner</th>
<th>type</th>
<th>value</th>
<th>count</th>
<th>id</th>
</tr>
<tr id="test">
<!-- conduit rock-name:cave; service-id:list-stock; -->
<td><!-- column owner --></td>
<td><!-- column type --></td>
<td><!-- column value --></td>
<td><!-- column count --></td>
<td><!-- column id --></td>
</tr>
</tbody>
</table>
You can probably figure out the rest: the rows returned replace the
html comments, and the <tr> (template) gets repeated for each row.
This is a very simplistic example... see the following URL for a more
compete example:
http://www.zwartberg.com/surf.html
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2009-11-25 19:25:33 | PostgreSQL RPM packages for Fedora-12 released |
Previous Message | David Fetter | 2009-11-23 02:56:38 | == PostgreSQL Weekly News - November 22 2009 == |