Jim Lawrence
accessd at shaw.ca
Sun Jan 9 18:43:28 CST 2005
Hi Gustav: If you are looking for a great free database piece of software, I have not found one but at a very reasonable price. The ants DB SQL engine is extremely fast, when running uses a very small footprint (39MB) on WinOS, runs on a variety of OSs, does take 512MB of RAM, which is normal, has all the features you would expect of a professional level SQL DB and is thirty to fifty percent less than MS SQL ( http://www.ants.com/ ) Mind you if money was no object, try Caché, a post-relational object oriented DB. See the white paper: http://www.intersystems.co.za/cache/technology/whitepapers/emergence-prdbms. html (watch for wrap) It is a very awesome package... you can even download a free personal copy for playing with. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Sunday, January 09, 2005 10:21 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] IBM Cloudscape, Apache Derby Thanks Paul I know about the other open-source engines. However, Cloudscape is extremely small, supports triggers, functions and stored procedures, should require zero administration, and should be very easy to deploy. But I can't find anything on speed or benchmarks, so I was looking for some real-life experiences. /gustav >>> Paul at PStrauss.net 09-01-2005 19:02:28 >>> At 1/9/2005 06:21 AM, you wrote: >Hi all > >Anyone having any experience with this open-source db engine? > >http://www-106.ibm.com/developerworks/db2/zones/cloudscape/ No, but I have had a good bit of experience with IBM software in general. When it comes to software, the acronym "IBM" means "I Build Mediocre". I have never used any IBM software that is easy-to-use, lean-and-mean, or that is overall better than the competition. When you look at their offerings from a little ways off, it looks really good. However, when you open the box and actually try to start using the stuff, you'll find all sorts of nasty gotcha's. IBM isn't nearly as good at writing software as it is at writing press releases. When I am using IBM software, it always seems to feel as if I have hitched a team of elephants to my little donkey cart; it doesn't go as fast as I really want it to, it takes a whole lot more care and feeding than I need it to, and most of what it can do, I'll never need. A few years ago I was working with their WebSphere messaging software, called MQ-Series back then. I could barely believe that it had support for OS/2 in it, but I was totally dismayed when I found out they attempted to support Windows 3.x!!! Now, don't get me started on Lotus... If you need an open source engine, just look at MySQL or some of the other open source engines to find one that meets your needs. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com