• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Postgres SQL or MySQL

 
Helen Thomas
Ranch Hand
Posts: 1759
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
David Ulicny
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
More advance is Postgres, more use is MySQL
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64623
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Helen Thomas
Ranch Hand
Posts: 1759
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Dave and Bear.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
Andrew Eccleston
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic