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 Relational Databases 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 Storm Applied this week in the Other Open Source APIs forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 15302
    
    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: 1770
    
    4
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: 15302
    
    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