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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:196338 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
