Zope (and therefore Aqueduct) runs on many platforms. This list is always growing! The lastest list of supported platforms and databases can be found on our website.

As of April 1998, Digital Creations supported:

• Linux v2
• BSDI v3
• OSF1v3
• Solaris 2.5
• Solaris 2.6
• HP/UX 10.x
• Irix 6.46
• Windows NT Server v4
• Windows NT Workstation v4

Here's a common problem... The people that are experienced and talented in the development of efficient SQL queries are often not the people that have the best eye for aesthetics and presentation. Similarly, an organization's best graphics specialists and HTML authors might not be qualified to write efficient SQL. What to do?!

The combination of Zope and Aqueduct allows website managers to segregate the responsibility for the SQL queries from the responsibility for developing a visually attractive and appealing interface. Consider the following SQL query (note the template variable substitution is highlighted in red:

This query is certainly not the most complex or complicated query that's ever been devised. However, it does involve joining two relational tables and sorting/ordering the output. So, while not terribly complex, it might very well be beyond the expertise of an HTML developer or graphics artist. No problem! Just get your local SQL guru to create a Zope SQL Method that implements this SQL query. Let's call it qryListOrderInformation.

With the qryListOrderInformation object created our HTML developers and graphics artists can do what they do best... make the site look visually appealing. Our graphic designer can now access the data returned from the query using the Document Template Markup Language (DTML) as follows:

<table>
  <tr>
    <th>Order<br>Number</th>
    <th>Quantity</th>
    <th>Shipped</th>
  </tr>

  <!--#in qryListOrderInformation-->
    <tr>
      <td><!--#var order_number--></td>
      <td><!--#var quantity--></td>
      <td><!--#var shipped--></td>
    </tr>
  <!--#/in-->
</table>

When the query was run, it would return data which would, in turn, be merged with the template to produce the folllwing HTML:

<table>
  <tr>
    <th>Order<br>Number</th>
    <th>Quantity</th>
    <th>Shipped</th>
  </tr>

    <tr>
      <td>2</td>
      <td>4</td>
      <td>3</td>
    </tr>

    <tr>
      <td>3</td>
      <td>6</td>
      <td>0</td>
    </tr>

</table>

Which when rendered in a browser would appear as follows:

Order Number	Quantity	Shipped
2	4	3
3	6	0

What's the secret?

It's no longer a secret... The fastest way to show significant demonstrable returns from your internet/intranet/extranet website is to web-enable existing operational databases. A close second is the design and development of new web-centric databases designed to deliver enhanced sales, marketing and customer service capabilities to your organization. Like we said, what needs to be done is no longer a secret.

How to do it...

Today's most precious commodity? Your time. In Zope (our web application development and delivery platform) and Aqueduct (our relational database publishing solution) Digital Creations has developed a suite of software that lets you work smarter, not harder.

Take for example, Aqueduct. Aqueduct packages your database queries (i.e., the SQL queries) into reusable objects that are made available throughout your website in accordance with the security parameters you establish. Aqueduct supports two-tier and n-tier implementations. Consider the following diagram which depicts a single-tier Aqueduct implementation. This diagram might depict a centralized web server serving data from a centralized database server.