This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Postgres SQL or MySQL" Watch "Postgres SQL or MySQL" New topic

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

Joined: Jan 10, 2002
Posts: 63544

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] [About Bear] [Books by Bear]
Helen Thomas
Ranch Hand

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

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.



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

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
I agree. Here's the link:
subject: Postgres SQL or MySQL
It's not a secret anymore!