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)
- OpenLink to MS-Access under VPC Emulation
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.