Jochem van Dieten wrote: >Damien McKenna wrote: > > >>One is the obvious question of, have you thought of PostgreSQL? It is >>much more feature rich than MySQL and is now also a native Windows app >>with version 8 (previously it wasn't, at least as standard). >> >> > >Hey, you stole my line! > >There are a number of other alternatives to consider, just in the >free Open Source arena there is Firebird, Ingress, Derby and >PostgreSQL (and then I am skipping a few off the less prevalent >ones). All have their pro's and cons, but personally I like >PostgreSQL a lot. >Like Damien said it is much more feature rich then MySQL, and you >can use that to make a migration easier. For instance, instead of >replacing the MS getDate() idiosyncracy with the MySQL Now() >idiosyncracy in all of your CF code, you can just leave your CF >code alone and define a getDate() function in PostgreSQL that >returns the current timestamp. >One function, instead of all your CF code. > >Jochem > > > I'm going to have to agree completely here. Vivio has had a lot of experience converting MS SQL server databases to PostgreSQL databases - and we have nothing but good things to say about PostgreSQL. If you don't want to use MySQL because it doesn't have the advanced SQL features you want, then note that PostgreSQL does. If you don't want to use MySQL because of it's slightly restrictive license, then note that PostgreSQL is released under the BSD license - which means you can pretty much do whatever you want to with it just as long as you keep the copyrights in tact. (Edit it, resell it, include it in your apps, etc etc etc.)
PostgreSQL is *awesome* and it's the first database I'd recommend to MS SQL database users as a cost-effective, efficient, and cross-platform alternative. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196350 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
