ColdFusion MX on Mac OS X, Part 3
Subject:   Database question
Date:   2002-10-10 06:37:37
From:   dicklacara
Response to: Database question

So far I have been able to run the following databases with CFMX under Mac OS X 10.2.1 Jaguar.

  • PointBase Embedded (CFMX Examples, etc).
  • PointBase Server (CFMX PetMarket Blueprint)
  • FileMaker
  • FrontBase
  • MySQL
  • OpenBase
  • OpenLink to MS-Access under VPC Emulation
  • Oracle
  • PostgreSQL
  • Sybase

Free or trial versions are available for all of the above except MS-Access.

All of these run native on Mac OS X, except MS-Access.

FileMaker and MS-Access are not recommended for online production -- rather the are used as a source for conversion of an offline database to a more robust RDBMS,, suited for online production.

Some of these dbs come with a GUI SQL client, which allows you to interactively create and execute SQL queries against the database -- great for development & debugging.

There are several general-purpose SQL clients which will work with any JDBC-compliant db (all of the above except MS-Access).

I will discuss the ViennaSQL client in the next article, as well as interfacing CFMX with several of the above databases.

The next article, part 4, is at O'Reilly, being edited -- it is 3 times the word-count limit, and needs to be broken into several parts.