PostgreSQL, MySQL, MsSQL whats your flavour?

[yorks.terrier]

okay folks lets here what db you are using and why you prefer it to others?

the reason for this is because I am currently using MySQL but am thinking about taking PostgreSQL for a test run, so I thought I would see what folks on here would use and what they think of them

[Techmonkey]

Using MySQL for anything I do with web pages and the like.

Reason I use it is because it comes with my web hosting. Couldnt really tell you the pro's and con's of any of them really.

IAWS will probably have some info though or maybe even Shultz or Bomberman.

[yorks.terrier]

yeah thats understandable, tbh the main reason I started off learning MySQL was because that was the one I had heard the most about and seemed to be the most popular at the time, but now I would like to broaden my database horizons somewhat and as I'm on a bit of an open source kick at the moment I figured Postgres should be the next step.

[iamwithstupid]

If you are only going to be using your own custom stuff then you might as well use postgresql since it does have a an advantage over mysql in peformance terms. But if you are going to be using other peoples code/developing for multiple people it is better to use Mysql because it is what the majority of open source web apps are developed for, and it is better to just run one database than having one mysql and one postgresql running at the same time.

At the same time you have to take into account that big players like youtube and google use mysql for all their stuff and most performance boosts are going to be coming from your use of various caching technologies than the database engine you are using.

http://www.danga.com/memcached/

[yorks.terrier]

iamwithstupid Wrote:If you are only going to be using your own custom stuff then you might as well use postgresql since it does have a an advantage over mysql in peformance terms. But if you are going to be using other peoples code/developing for multiple people it is better to use Mysql because it is what the majority of open source web apps are developed for, and it is better to just run one database than having one mysql and one postgresql running at the same time.

At the same time you have to take into account that big players like youtube and google use mysql for all their stuff and most performance boosts are going to be coming from your use of various caching technologies than the database engine you are using.

http://www.danga.com/memcached/

from what i have read, when using rails you can quite easily switch between the two just by changing the specified db type in your database.yml file.

the main reason I am looking at learning another db type is a) for personal gratification, I enjoy learning new things b) because I think it would be good to show on my cv that I have experience of working with more than one db type

[iamwithstupid]

Yeh if you use rails correctly you can change db type like that, but I was more talking about running other peoples code, in say PHP because pieces of software like vbulletin/most other things, are written for only Mysql. But if you are just going to be running custom code or rails only then you might as well try postgresql.

[Fearless_Shultz]

have not used mysql seriously in a while, mostly because of the past lack of support for stored procedures which are very handy in making sure you don't leave any site you create open to sql injection attacks. I believe mysql now supports stored procedures though so might be giving it a revist.... though I am not sure if it yet supports transactions which give you the ability to roll back and undo sql commands.... In terms of postgresql, have heard lots of good things but never actually used it so can't comment. I generally tend to use sql server for db related stuff but unfortunately it does add a premium to hosting costs as I have never seen it available for free and also needs to run on a windows server which wouldn't be ideal for the dev path you are taking

[yorks.terrier]

iamwithstupid Wrote:Yeh if you use rails correctly you can change db type like that, but I was more talking about running other peoples code, in say PHP because pieces of software like vbulletin/most other things, are written for only Mysql. But if you are just going to be running custom code or rails only then you might as well try postgresql.

ahh okay I didnt realise you were talking in that sense mate, but yeah I agree if you're using prebuilt software like that then it is best to stick with mysql

Fearless_Shultz Wrote:have not used mysql seriously in a while, mostly because of the past lack of support for stored procedures which are very handy in making sure you don't leave any site you create open to sql injection attacks. I believe mysql now supports stored procedures though so might be giving it a revisit.... though I am not sure if it yet supports transactions which give you the ability to roll back and undo sql commands.... In terms of postgresql, have heard lots of good things but never actually used it so can't comment. I generally tend to use sql server for db related stuff but unfortunately it does add a premium to hosting costs as I have never seen it available for free and also needs to run on a windows server which wouldn't be ideal for the dev path you are taking

tis true matey while you can integrate with SQL server through most OS languages now using SQLServer would probably be classed as straying from the OS :lol but like I say this thread is more for seeing what people use and what they like /dislike about it just sadly I couldnt put up a poll to go with it