Cave

Incredibly simple PostgreSQL to WEB GUI system

PostgreSQL is one of the world's greatest databases, so I am using it for this project's database.

For convenience, I made it so that the database interface, including the SQL is organised into "service"s, which could be one or more SQL statements. Parameters are passed to the service, and columns are returned (organised into rows.)

This links up very neatly with the surf application (a dynamic web server) via "conduit"s, to dynamically fill in values in web pages and create html content for the rows returned.

So the entire web application can be created by just creating some SQL, HTML, and some XML configuration. No other coding is required. No PHP or C++, etc. is required... though you can add that too, if you like.

Following is a very simplistic example of a 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>
	    

... which when served by surf, will produce something like this:

More...

• Full Cave documentation
• Full Surf documentation
• Surf
• The Karoo Project

Documents
Downloads
Sourceforge

Other Links:

WEB Design
Runners
Lazy Lizard
Attractions
Contact

Large services (like an internet banking system for example), which can grow and grow and grow, to absorb the load as time goes on... and which don't suffer so much from unexplained periods of being offline, or "freezing up".

Zwartberg Reseach & Development is a registered trading name of Open Source Software Consulting CC.
Phone:+27235411462, fax:+27235411379, mobile:+27796977082,
brian@zwartberg.com, P.O. Box 2, Prince Albert, 6930, South Africa.