Incredibly simple PostgreSQL to WEB GUI system

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/