• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. CONNECTING ZOPE TO EXTERNAL R... > Relational Database Management Syste...

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 (www.oracle.com) and Sybase (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 (www.mysql.com)

PostgreSQL (www.postgresql.com)

Interbase (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.

Note

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.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint