ColdFusion MX on Mac OS X, Part 3
Subject:   Database question
Date:   2002-10-07 07:13:26
From:   mrbitter
In order to use database with CF on Jaguar, what Database utility does anyone recommend? I've got Access in Virtual PC with SQL Server 7 running, but I can't find a workable DB. Has anyone got the DB function to work with Jaguar?
Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Database question
    2002-10-10 06:37:37  dicklacara [View]

    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.