Home > Articles > Web Development

  • Print
  • + Share This
This chapter is from the book

Relational Database Management Systems (RDBMS)

Mainly, you can divide databases into two categories: commercial relational database management systems and open-source relational database management systems.

The leading commercial RDBMSs are Oracle (http://www.oracle.com) and Sybase (http://www.sybase.com).

However, these databases are not suitable for home users or small businesses because of the cost factor. The price for a license for one of these databases varies from a few thousand up to a few hundred thousand dollars which, for some companies, may be too expensive. They also are much more resource intensive. But both Oracle and Sybase are worth their money because they come with many more features and possibilities than their open-source counterparts.

The most important open-source RDBMSs are

MySQL (http://www.mysql.com)

PostgreSQL (http://www.postgresql.com)

Interbase (http://www.interbase.com)

In this chapter, we are going to describe how to connect a MySQL database to Zope. This procedure only differs from say, Oracle or Sybase, in that you need to use the respective database adapter for those databases.


Most of the previously mentioned databases are transactional databases. However, out-of-the-box MySQL is not transaction aware.

Zope does work best with transactional databases. Inconsistency problems can arise when a ZODB transaction is aborted if the RDBMS is not transactional.

  • + Share This
  • 🔖 Save To Your Account