I would go with MySQL and yes there are GUI's out there such as NaviCat, which I personally use, that rival Enterprise Manager and the Management suite. I also like the fact it isn't microsoft. It scales rather nicely so there are few to no limitations on it. It also has a fairly small memory footprint so running it on the same machine is no biggie.
As far as saying Apache Derby being slow just because it is on top of Java is pretty baseless and making blanket statements like that are just about as bad as saying ColdFusion sucksand is slow because MySpace crashes all the time. yeah. J.J. On Sun, Mar 16, 2008 at 6:43 AM, henry ho <[EMAIL PROTECTED]> wrote: > Which DB would you choose (MSSQL Express / Apache Derby) for a small > (<4gb, with only < 10 simultaneous connections) intranet CF App? > > I only used MS-SQL before, and I found the management studio very easy to > work with. The only concern I have is the limitation of the Express version > might get me one day. > > Then I found out CF8 comes with Apache Derby, and I wonder if that's a > good choice. Actually, when is Derby a good choice?? > > Since there's no management studio like MSSQL for Derby (or MYSQL), anyone > tried RDS support in CFEclipse? Can I use that to create/manage/backup the > DB? Is it reliable? > > Thank you! > Henry > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
