Women in Technology

Hear us Roar



Article:
  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.


Dick