Personally, I like MS SQL Express. The only thing is that it doesn't come with an agent, AFAIK, so you'll need to find another way to do backups.
If you don't want limitations, I would go with MySQL, but I could never get used to it, as the management tools sucked. Some people suggested something like NaviCat, which I haven't tried yet. This is the first I'm hearing of Apache Derby, and although I'm sure it's a nice project, it's written in Java, which means it will be slower then MSSQL and MySQL, and it probably doesn't have good management tools. Russ > -----Original Message----- > From: henry ho [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 16, 2008 7:44 AM > To: CF-Talk > Subject: DB choice for small Intranet site > > 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:301379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4