Z SQL Methods provide access to relational and other external databases from Zope . Database queries and commands can be used to publish relational data, collect and store data in relational databases, and create complex web-deployed database applications.
Z SQL Methods facilitate cooperation of people who know databases and people who know the Web. Database logic is separated from presentation and application logic. Database administrators can focus on developing database queries without having to be expert on HTML or Web application development. Web developers can focus on presentation or application development without becoming expert on SQL or database schemas.
Z SQL Methods provide high performance by maintaining open database connections, so it is not necessary to connect to a database on each request.
Z SQL Methods utilize features of Zope , to enable complex applications that would be harder to create in other environments.
This guide is created to facilitate content managers and developers who want to access relational and external databases from Zope. The format of the guide provides step by step instructions on how to publish relational data on the Web. With Zope examples and explanations, the user create SLQ queries using DTML.
Included in the user's guide are instructions to create search interfaces between Zope and database queries. Relational database queries results with Zope are called objects. The Z SQL methods supports the integration of relational data with the Zope object system.
A section on Database Connections explain how to manage and create connections to external databases. This guide will take you through creating, testing and debugging, query templates, editing of SQL database methods. SQL Methods supports a number of specialized tags for inserting values or comparisons into SQL source, an explanation of these various tags are provided in this guide.
Publishing relational data on the Web with Z SQL Methods typically requires three steps: