aspose 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 Spring in Action this week in the Spring 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: 15299
    
    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 - Experts at Building Test Data
Michael Matola
whippersnapper
Ranch Hand

Joined: Mar 25, 2001
Posts: 1751
    
    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: 15299
    
    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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: MySQL or PostgreSQL