> BTW, one database you didn't mention was Firebird. I hear it is almost > as capable as PostgreSQL and it does have a native Windows version.
firebird's not quite as "standard" as postgreSQL (it offers "many ANSI SQL-92 features"), has some syntax differences from sql server/access. it has some nice features like UDFs, identity-like values before INSERTs, 64 bit IO, both odbc & jdbc drivers (and for those you into this sort of thing there's a .NET provider in beta now), and of course transactions, sub queries, stored procedures, etc.. its got a fairly active user community. firebird's unicode support is kind of "iffy" which to me is important. > Unfortunately, I have spent too little time working with it to say more. i've played around with it a bit but never in production. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4