It all comes down to how much 'heavy lifting' you want to do at the database level.
Shared file databases like: Access FoxPro dBase ..etc... are fine for development and light duty systems. Concurrence, locking and speed are issues, as are things like the ability to create and leverage stored procedures. MS SQL Sybase Oracle PointBase DB2 Postgres ...are all fully relational databases. They all support views, stored procs, triggers etc... MySQL is pretty much on the same level as Access...No views, no stored procs, though I must say they plan this in version 4.1...same goes for triggers...which means you have to do any real heavy lifting in scripts or at the application server level...which isn't advisable. MySQL is cheap...being free...but if you want a serious database at NO COST...look into PostGres (www.postgresql.org) Find a local mirror, read the documentation...better than MySQL by a long shot...views, stored procs, triggers...the works...AND FREE... PS...you can run PostGres in Windows using CygWin. The documentation is there, read up. My 2centavos... Byron At 11:04 AM 4/22/2002 -0400, you wrote: >The answer depends on what sort of work you want to with the database. MS >Access works reasonably well for straighforward applications where you >don't need stored procedures, triggers, etc. > >********************* >Hi all, > >I installed CF Studio on my home PC ( Windows XP Home ) running with Apache >Server. Can anyone suggest a good database to run from the PC ? > > >- >You are subscribed to the CFUGToronto CFTALK ListSRV. >This message has been posted by: [EMAIL PROTECTED] >To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ >Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ >This System has been donated by Infopreneur, Inc. >(http://www.infopreneur.net) Byron Bignell CTO, G+A Electramedia "Your web department" p. 416 361 6161 f. 416 361 0553 www.electramedia.com Nature hates to vacuum. - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Byron Bignell <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
