Our organization has products backed by both databases and we are almost entirely shielded from the database details in Tomcat. I don't really see how it should matter in terms of Tomcat (or any Web container). I'm thinking this is more a Java issue than a Tomcat issue.
The main differences we've encountered is that the MySQL implementation of JDBC requires some extra parameters to be passed along when connections are made, otherwise the ResultSet will fail on particular conditions. But this is an database layer issue, and the db layer exists independently of the web apps. Our observation of the MySQL vs Postgre debate is this: (btw we use versions 5.0 and 8.1 respectively) * Postgre has more features (sequences and triggers) but also an enormous amount of complexity * MySQL has much finer authorization control, but lacks some of the big-boy features such as triggers ** of course a lot has changed in the newer versions of both of these DBMS On Thu, Jan 15, 2009 at 5:20 PM, Ken Bowen <kbo...@als.com> wrote: > Hi all (especially Chris -- very informative long post today on > Tomcat/MySQL): > > For a several reasons (including the apparent infinite default for > connection timeout), I'm contemplating switching one or two projects from > MySQL to PostgreSQL. I'd like to gather opinions on the tradeoffs, > including: > > Unfortunately, MySQL isn't really that tunable. On the other hand, MySQL > requires very little in the way of tuning! > > I created a couple of proof-of-concept projects with PostgreSQL for someone > about six months ago, and the only really puzzling thing what how to set up > "sequences" corresponding to MySQL's AUTOINCREMENT (I'm not sure I've really > wrapped head around it completely anyway). For those small projects, it > worked well, but there was no stress involved. > > I'd like to hear about people's experiences and what they think are the > strengths and weaknesses of each DBMS for use behind Tomcat. > > Thanks much in advance, > Ken Bowen > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
