Re: Equipt a DBMS to Tomcat
Quoting Steven Woody [EMAIL PROTECTED]: Hi, folks MySQL and PostgreSQL, which one is the better choice for tomcat ? -- Steven Woody [EMAIL PROTECTED] [OT] isn't it ;) First, I do not see in which regards a database choice might be linked to a JSP container ? Nevertheless ... Postgresql: I have a very satisfied experience using Postgresql in terms of deployment simplicity, reliability, features and performances. I moved from Oracle to Postgresql four years ago. At that time the reasons I choose Postgresql and not MySql were some features I was looking for like stored procedures, triggers and foreign keys were not supported in MySql. A very productive embrace all db alternative: You might consider investing your time acquiring knowlege of a persistence layer like Hibernate rather than delving into Database and JDBC specifics. It drastically simplifies object persistence development. Going this way you do not have to choose the database you are developping for. The tool can also generate the database schema for you. The final database choice decision comes upon deployment, providing you with a maximum flexibility to your own requirements, your customers legacy, your ISPs offering. You can move from Postgresql, MySql to HSQL (Pure Java DB) or Oracle database (and many more). Worth to mention is the large quantity and high quality of Hibernate documentation, as well as its integration into ANT and XDoclet. Hibernate websites: http://hibernate.bluemars.net/ http://sourceforge.net/projects/hibernate Hibernate articles: http://www7b.software.ibm.com/dmdd/library/techarticle/0306bhogal/0306bhogal.html http://www.meagle.com:8080/hibernate.jsp Hibernate and XDoclet: http://xdoclet.sourceforge.net/tags/hibernate-tags.html I also heard about Torque but have no experience with it: http://db.apache.org/torque/ Patrick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Equipt a DBMS to Tomcat
Hi, folks MySQL and PostgreSQL, which one is the better choice for tomcat ? -- Steven Woody [EMAIL PROTECTED]
Re: Equipt a DBMS to Tomcat
http://advocacy.postgresql.org/advantages pgSQL is ANSI SQL (unions, stored procs), is considered faster than most dbs and is a free license, even on windows, no mater how you use it. MySQL is not realy full SQL, it is sort of like MS Access. Steven Woody wrote: Hi, folks MySQL and PostgreSQL, which one is the better choice for tomcat ? -- Steven Woody [EMAIL PROTECTED] -- Victor Cekvenich, Struts Instructor (215) 321-9146 Advanced Struts Training http://basebeans.com/do/cmsPg?content=TRAINING Server Side Java training with Rich UI, mentoring, designs, samples and project recovery in North East. Simple best practice basic Portal, a Struts CMS, Membership, Forums, Shopping and Credit processing, http://basicportal.com software, ready to develop/customize; requires a db to run. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Equipt a DBMS to Tomcat
I would say MySQL is the better choice, not simply with Tomcat but in general. Kind Regards Schalk Neethling Web Developer.Designer.Programmer.CEO Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or diclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. :: -Original Message- :: From: Steven Woody [mailto:[EMAIL PROTECTED] :: Sent: Saturday, November 08, 2003 9:22 PM :: To: [EMAIL PROTECTED] :: Subject: Equipt a DBMS to Tomcat :: :: Hi, folks :: :: MySQL and PostgreSQL, which one is the better choice for tomcat ? :: :: -- :: Steven Woody :: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]