Web Database Poll

MySQL
43% (6 votes)
Microsoft SQL Server
29% (4 votes)
Microsoft Access
29% (4 votes)
Oracle
0% (0 votes)
Other
0% (0 votes)
Total votes: 14

PJ | Are we there yet?
pjboettcher.com

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

I was considering playing with PostgreSQL, but after seeing these benchmarks, I never bothered.

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

I can't imagine a DB not supporting autoincrement.

mairving's picture

They have: 2,256 posts

Joined: Feb 2001

I had heard, though not confirmed, that PostgreSQL does not support autoincrementing. That and it is harder to type than MySQL. Now we have a new choice. The RedHat database which is PostgreSQL.

Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states

They have: 3 posts

Joined: Sep 2001

I've only recently started playing with it, but PostgreSQL supports a lot of the higher-end features that MySQL is lacking...

Personally I use MySQL extensively, as it's free, and integrates seemlessly with PHP (my favorite scripting languate). But I've been looking seriously at PostgreSQL as well, which PHP also supports...

Anyone else have any thoughts on PostgreSQL?

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

Did it work? =P

mySQL doesn't currently support Stored Procedures or Triggers. Read more here.
Probably some other stuff too, but my brain is fried right now.

Mark Hensler
If there is no answer on Google, then there is no question.

Keegan's picture

They have: 300 posts

Joined: Aug 2001

Mark are you trying to confuse us!

Quote: mySQL can't offer what msSQL can

WOW ZING POW!

K

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

I've not played with Oracle, so keep that in mind.

I work mostly with mySQL and love it, mainly because I work mostly with PHP. But if you want power, mySQL can't offer what msSQL can. Keep in mind I have not played with Oracle. I have heard that Oracle is even more powerfull. Sounds fun!

Mark Hensler
If there is no answer on Google, then there is no question.

mjames's picture

They have: 2,064 posts

Joined: Dec 1999

MySQL.

mairving's picture

They have: 2,256 posts

Joined: Feb 2001

I guess that it depends upon how you define best.

Best for the money
MySQL

Best in a 'nix environment
MySQL

Best in a MS environment
SQL Server

Best in ease of use
Access

Best Robustness
Oracle

I use MySQL simple because of the price, the environment, and it's PHP support.

Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.