Sorry too terse I for you I suppose :) >From my perspective it is a more active project. It has more compatibility with other engine dialects (for example mysql). It has better stability than derby. If i recall the footprint is even smaller than derby (not that this matters much). It has a memory mode if you dare choose that (I would not for production, we got bit bigtime by HS SQL with that once upon a time). It also provides full text searching, big win for me.
As for management tools, it is just like any other small DB engine, its just a jar the management tools is a good ole SQL DDL, but hey you can pretty much take MySQL manager and generate DDLs and run them on H2 so yeah I guess it has better management tools too. It also has ODBC so it can interface with more tools if you have some old ODBC tools. And because I take particular exception to your innuendo here: Better because the Railo folks say so? > Personally I back a fully open source CFML engine instead of Railo. Matt did some work very early on to emded h2 actually it was Matt that introduced me to H2. Adam On Tue, Oct 6, 2009 at 4:48 PM, Bryan Stevenson < br...@electricedgesystems.com> wrote: > > On Tue, 2009-10-06 at 16:27 -0400, Adam Haskell wrote: > > Use H2, it is better and bundled with Railo. > > > > Adam > > Care to elaborate Adam? ;-) > > Why is it "better" than Derby in your opinion? > > Better performance? > > Better management tools available? > > Better because the Railo folks say so? > > I'd love to know > > Cheers > - > > Bryan Stevenson B.Comm. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
