In my experience at least two of the databases you list excel at something my one caveat is, that although postgresql does do everything you want I have found it to be rather slow under load. That may be because there is little documentation on tuning it and such.
MYSQL simply screams at reads. Its even fairly quick with a transactional backend like innodb or such. Also both of these two have some commercial support available which I have often found to be a sticking point with clients on picking ANY database. I cant speak to the other two because I haven't had enough experience to benchmark them. (and in the case of Derby I haven't even used it). Al -----Original Message----- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 9:03 AM To: user@struts.apache.org Subject: [OT]question about open source data base selection Hi I am working on a intranet project, we plan to use a open source database, there wont be a lot of load on it, may be a 500-700 records written or deleted per day. I would like to have a database which has features like views, stored procedures, foreign key constraint etc Which would you guys prefer, and also which is a real open source where i dont have to worry about license. I have a list like mysql, postgre sql, Ingres by CA, Derby from apache , Ashish __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
