AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  postgreSQL v. MySQL?          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Nikita Tovstoles Guest Posted: Fri Aug 13, 2004 6:26 pm    Post subject: postgreSQL v. MySQL? Hi, I am designing a j2ee-based web service (web site + personal profile pda client) and i'm trying to determing whether i should be using mysql or postgreSQL at the back end. I was using mysql in prototype development, and was perfectly happy with stability and performance. However, mysql doesn't have triggers and stored procedures, which postgre apparently does have. PostreSql's features sounds very appealing however, but since i never used it, i'd like to hear any feedback on whether postgre is capable of handling larger-scale deployments (must be able to handle 10s to 100s of thousands of users)? Who uses Postgre? How much slower is it than mysql? Does it scale horizontally? thanks a lot -nikita Back to top RC Guest Posted: Tue Aug 17, 2004 1:09 pm    Post subject: Re: postgreSQL v. MySQL? Nikita Tovstoles wrote: Quote: Hi, I am designing a j2ee-based web service (web site + personal profile pda client) and i'm trying to determing whether i should be using mysql or postgreSQL at the back end. I was using mysql in prototype development, and was perfectly happy with stability and performance. However, mysql doesn't have triggers and stored procedures, which postgre apparently does have. You are right, last time I checked MySQL it even does not support foreign key! To me MySQL is for those people don't know much about relational database, no need to write triggers, store procedures. They only need a database to store their online shopping lists. Quote: PostreSql's features sounds very appealing however, but since i never used it, i'd like to hear any feedback on whether postgre is capable of handling larger-scale deployments (must be able to handle 10s to 100s of thousands of users)? Who uses Postgre? How much slower is it than mysql? Does it scale horizontally? So far I only see PostgreSQL support OS on Linux, not support for Windows 98/2000/XP/NT It is fast enough for me. Of course, not good as commercial products Oracle, Informix, Sybase, SQL Server, etc. This site I stored all our data into PostgreSQL http://dipper.nws.noaa.gov/hads/dipper/indexDipper.html Back to top Paul Thomas Guest Posted: Tue Aug 17, 2004 7:17 pm    Post subject: Re: postgreSQL v. MySQL? On Tue, 17 Aug 2004 14:09:30 +0100, RC wrote: Quote: [snip] So far I only see PostgreSQL support OS on Linux, not support for Windows 98/2000/XP/NT PostgreSQL runs on loads of Unixen (I think its over 20). Native Win32 support (2000/XP) will be available with version 8.0, which has just entered its first beta. -- Paul Thomas +------------------------------+---------------------------------------------+ Quote: Thomas Micro Systems Limited | Software Solutions for Business | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+ Back to top David Harper Guest Posted: Wed Aug 18, 2004 7:02 am    Post subject: Re: postgreSQL v. MySQL? Raymond Chui wrote: Quote: You are right, last time I checked MySQL it even does not support foreign key! To me MySQL is for those people don't know much about relational database, no need to write triggers, store procedures. They only need a database to store their online shopping lists. A lot of big names such as NASA, LANL, Sabre and Yahoo seem happy enough to use MySQL for mission-critical tasks. In any case, you're completely wrong about foreign keys: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html <quote> Starting from MySQL 3.23.44, InnoDB features foreign key constraints. </quote> To me, MySQL is for those people who want a relational database that is easy to install, easy to use, fast, efficient, and which has a choice of database engines (MyISAM, InnoDB, ...) to suit the needs of all kinds of users. I'm a MySQL user, and a very satisfied one, but I have nothing against PostgreSQL. It's a good database system too, and it may meet Nikita's needs better than MySQL. I just don't like to see inaccurate and ill-informed comments passed off as fact. David Harper Cambridge, England Back to top ccc31807 Guest Posted: Wed Aug 18, 2004 12:39 pm    Post subject: Re: postgreSQL v. MySQL? RC <raymond.chui (AT) noaa (DOT) gov> wrote Quote: You are right, last time I checked MySQL it even does not support foreign key! To me MySQL is for those people don't know much about relational database, no need to write triggers, store procedures. They only need a database to store their online shopping lists. As a veteran of some vicious fights over MySQL, I'd agree with you -- MySQL is not a mission critical database system. However, MySQL is fast, secure, small, easy, reliable, and free. Others, such as SQL Server (with which I have the most experience) is a mission critical database system, but it's not fast, secure, small, reliable, nor free. (It is easy enough.) You seem to turn your nose up at people who want to store their online shopping lists, something MySQL is very good for. It strikes me that you criticize particular tasks because you find that the tool best suited to those tasks unsuitable for other, more involved, tasks. You need to rethink this. Why take an eighteen wheeler to the grocery store for milk and bread (or beer and cigarettes) when all you need is a Volkswagen? CC Back to top Jon Martin Solaas Guest Posted: Thu Aug 26, 2004 10:53 pm    Post subject: Re: postgreSQL v. MySQL? David Harper wrote: Quote: Raymond Chui wrote: You are right, last time I checked MySQL it even does not support foreign key! To me MySQL is for those people don't know much about relational database, no need to write triggers, store procedures. They only need a database to store their online shopping lists. A lot of big names such as NASA, LANL, Sabre and Yahoo seem happy enough to use MySQL for mission-critical tasks. In any case, you're completely wrong about foreign keys: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html quote Starting from MySQL 3.23.44, InnoDB features foreign key constraints. /quote To me, MySQL is for those people who want a relational database that is easy to install, easy to use, fast, efficient, and which has a choice of database engines (MyISAM, InnoDB, ...) to suit the needs of all kinds of users. I'm a MySQL user, and a very satisfied one, but I have nothing against PostgreSQL. It's a good database system too, and it may meet Nikita's needs better than MySQL. I just don't like to see inaccurate and ill-informed comments passed off as fact. David Harper Cambridge, England If you want facts: MySQL is still playing catch-up when it comes to features all relational databases should have. The link you provided is actually a very good reason not to use MySQL; in version X.Y.Z feature A works this way, in version XX.YY.ZZ it works the other way, you have to use one table type to have a certain feature, and another type to have another feature blah blah blah. Why bother? Of course, if your need is very simple, MySQL works fine, and it's certainly room for a database that focuses on simple needs. But on the other hand, why not use a database that provides all features you'll ever need? PostgreSQL, Firebird, MySQL MAX DB (earlier SAP DB) and many others exist. (Wonder why MySQL offers their version of SAP DB ...) On the bright side; MySQL ConnectorJ is pretty rock solid. In a database test in eWeek quite some time ago MySQL performed very well, much because of it's large cache and solid jdbc driver, many of the competitors failed tests due to crappy drivers. (Unfortunately they insisted on running the test on Win32, so PostgreSQL wasn't racing ...) And, if you think MySQL is easy to configure; well, PostgreSQL is even easier. So, I'm sorry to tell you this, but; MySQL is the MS DOS of relational databases :-) Ouch! -- jonmartin.solaas¤h0tm4i1 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.