File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes MySQL or PostgreSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL or PostgreSQL" Watch "MySQL or PostgreSQL" New topic
Author

MySQL or PostgreSQL

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

I have been using MySQL for quite awhile. Was wondering if PostgreSQL was any better or worse? Or is it just a "feature" issue where they both have features the other one doesn't so it becomes a trade off?
Thanks.


GenRocket - A Test Data Generation Platform
Michael Matola
whippersnapper
Ranch Hand

Joined: Mar 25, 2001
Posts: 1740
    
    2
One thing I definitely don't like about MySQL is that the current version does not support subqueries. If all you ever do is "select * from table" then it's not an issue. But for more more sophisticated querying MySQL in its present form just doesn't cut it.
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

That's good to know. What about Stored Procedures. I heard that MySQL does not support them but PostgreSQL does. However, when browsing through the documentation I can find nothing to confirm this one way or another.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL or PostgreSQL
 
Similar Threads
mac + mysql for a java guy
What database should I use?
Firebird
PostgreSQL vs MySQL, JDBC Performance
Question about Big Moose's server specs