aspose file tools*
The moose likes JDBC and the fly likes Postgres SQL or MySQL 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 "Postgres SQL or MySQL" Watch "Postgres SQL or MySQL" New topic
Author

Postgres SQL or MySQL

Helen Thomas
Ranch Hand

Joined: Jan 13, 2004
Posts: 1759
I haven't followed either for some time. Which one is more advanced or more in use.

And are there any new open source SQL frameworks on the horizon ?


Le Cafe Mouse - Helen's musings on the web - Java Skills and Thrills
"God who creates and is nature is very difficult to understand, but he is not arbitrary or malicious." OR "God does not play dice." - Einstein
David Ulicny
Ranch Hand

Joined: Aug 04, 2004
Posts: 724
More advance is Postgres, more use is MySQL


SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61431
    
  67

When I set up my environment at my hosting company a few years back, I chose PostgreSQL over MySQL since, at least at the time, MySQL did not have transaction support. That may have changed since; I haven't really kept up since Postgres satisfies my DB needs completely.

Another thing I really like about Postgres is its support of the LIMIT and OFFSET keywords which make serving up large datasets as 'pages' almost trivial. I don't know if MySQL has added such support or not.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Helen Thomas
Ranch Hand

Joined: Jan 13, 2004
Posts: 1759
Thanks Dave and Bear.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


MySQL did not have transaction support. That may have changed since

Indeed it has. The newer DB engine (which I think is InnoDB - but take that with a pinch of salt - I have not checked) does have transaction support.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Andrew Eccleston
Ranch Hand

Joined: Jul 07, 2004
Posts: 140
According to MySQL's manual, LIMIT with OFFSET is now supported. Didn't see whether it started in 4.0 or 4.1. It also now supports UNION and (more importantly) subqueries.

Transactional support is provided by InnoDB, which is 'built in' to MySQL these days. Unfortunately, the default table type, MyISAM, still does not support transactions.

HTH

andrew


The statement below is true.<br />-------------------------------<br />The statement above is false.
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

I prefer Postgres because of it's support for stored procedures but usually end up going with mySql, for hosted projects, becuase of its' ubiquity.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
 
jQuery in Action, 2nd edition
 
subject: Postgres SQL or MySQL