Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Database of choice

by thraxil (Prior)
on Aug 10, 2001 at 21:14 UTC ( #103955=note: print w/replies, xml ) Need Help??

in reply to Database of choice

i'm curious why some people who prefer open-source databases prefer mysql over postgres?

i've used both and found that they're equally easy to setup and admin and roughly the same speed (recent versions of postgres have gotten much faster). but then postgres also supports transactions, foreign keys, subselects and all those other things that many of us would consider necessary elements of a real DBMS.

are the various built in functions in mysql that much more of a convenience? or is it just that mysql has gotten so much hype lately that people haven't even tried postgres?

not trying to troll here, i've had nothing but pleasant experiences with mysql. i'm honestly curious what people see as mysql's real advantage over postgres?

anders pearson

Replies are listed 'Best First'.
Re: Re: Database of choice
by httptech (Chaplain) on Aug 12, 2001 at 23:58 UTC
    I have stuck with MySQL primarily because I'm used to it. I started with mSQL, which lacks some vital features, so when I found MySQL I thought it was great. For simple databases, MySQL is easy to use and learn. Postgres has more advanced features that compete with the "big boys", but I've never needed them for the kind of work I do. I considered switching once, in case of future need, but I didn't like the way Postgresql handled things like OIDs and stuff as opposed to MySQL. I'm sure if I had started out with Postgres I'd swear by it instead.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://103955]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (8)
As of 2018-05-22 09:00 GMT
Find Nodes?
    Voting Booth?