This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
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 Soft Skills this week in the Jobs Discussion 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: 15300
    
    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: 1757
    
    3
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: 15300
    
    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