| 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: 56202
|
|
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.
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About 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
|
|
 |
|
|
subject: Postgres SQL or MySQL
|
|
|
0
