MySQL vs. PostgreSQL

Community preference: PostgreSQL (71% of 540 votes)
Your preference: (sign in to begin voting)
Your vote budget:

Why MySQL is better

Why PostgreSQL is better
1. Larger user base
0
44 votes   0 comments
add
2. Easy to use
0
34 votes   26 comments
add
3. Built-in asynch replication
0
33 votes   0 comments
add
4. has phpMyAdmin
0
13 votes   0 comments
add
5. Multiple storage engines to choose from
0
12 votes   0 comments
add
6. Built-in full-text search
0
10 votes   0 comments
add
7. Better Performance
0
6 votes   0 comments
add
8. More and better marketing
0
3 votes   0 comments
add
9. Better capability to ignore integrity constraints
0
1 votes   0 comments
add
10. Postgres is too much B&D
0
1 votes   0 comments
add
1. Much better vertical scalability
0
64 votes   0 comments
add
2. faster
0
55 votes   0 comments
add
3. Focuses on a single, good storage engine
0
39 votes   1 comment
add
4. Friendlier license (BSD vs GPL-or-pay-MySQL)
0
27 votes   0 comments
add
5. Project is more independent of commercial interests
0
25 votes   0 comments
add
6. psql console better than mysql console
0
22 votes   1 comment
add
7. scalability and performance unmatched by mysql
0
19 votes   0 comments
add
8. Is well designed from start
0
19 votes   0 comments
add
9. Works with the SQL standards and when it extends it, does so sanely.
0
18 votes   0 comments
add
10. Very similar to Oracle but in a good way
0
17 votes   0 comments
add
11. can write stored procedures in multiple languages
0
14 votes   0 comments
add
12. Dose what it claims
0
12 votes   0 comments
add
13. MySQL:s license is too anal, thats why we picked Postgres in the first place.
0
10 votes   0 comments
add
14. Flexable full text search
0
8 votes   0 comments
add
15. Independent of Commercial Compromises
0
6 votes   1 comment
add
16. tablespaces
0
5 votes   0 comments
add
17. extensible type system
0
5 votes   0 comments
add
18. Users are generally pretty clueful
0
5 votes   0 comments
add
19. can add an index and write to table concurrently
0
5 votes   0 comments
add
20. Cluster indexes
0
4 votes   0 comments
add
21. Pluggable PLs (Programming Languages)
0
3 votes   0 comments
add
22. has phppgadmin
0
1 votes   0 comments
add
23. Enterprise
0
0 votes   0 comments
add
Why is MySQL better for you?
(log in to add)
Why is PostgreSQL better for you?
(log in to add)

External Resources

Comments

d

Regarding argument "MySQL: Easy to use" by mmutsuzaki at Feb 18, 2008 11:17:23 PM

Why is MySQL easier to use than Postgres??

Regarding argument "MySQL: Easy to use" by john_beatty at Aug 4, 2007 5:52:43 PM

from an ansi-sql viewpoint, i'd say that mysql is HARDER to use

Regarding argument "MySQL: Easy to use" by igkins at Jan 24, 2008 11:53:57 AM

d

by mmutsuzaki at Feb 18, 2008 11:13:11 PM

e

by mmutsuzaki at Feb 18, 2008 11:13:51 PM

f

by mmutsuzaki at Feb 18, 2008 11:14:00 PM

g

by mmutsuzaki at Feb 18, 2008 11:14:08 PM

h

by mmutsuzaki at Feb 18, 2008 11:14:16 PM

d

by mmutsuzaki at Feb 18, 2008 11:14:26 PM

d

by mmutsuzaki at Feb 18, 2008 11:14:33 PM

d

by mmutsuzaki at Feb 18, 2008 11:14:42 PM

d

by mmutsuzaki at Feb 18, 2008 11:14:49 PM

d

by mmutsuzaki at Feb 18, 2008 11:15:03 PM

d

by mmutsuzaki at Feb 18, 2008 11:15:12 PM

d

by mmutsuzaki at Feb 18, 2008 11:15:27 PM

d

by mmutsuzaki at Feb 18, 2008 11:15:36 PM

d

by mmutsuzaki at Feb 18, 2008 11:15:47 PM

d

by mmutsuzaki at Feb 18, 2008 11:15:58 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:07 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:14 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:21 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:31 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:38 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:46 PM

d

by mmutsuzaki at Feb 18, 2008 11:16:53 PM

d

by mmutsuzaki at Feb 18, 2008 11:17:00 PM

d

by mmutsuzaki at Feb 18, 2008 11:17:07 PM

d

by mmutsuzaki at Feb 18, 2008 11:17:16 PM

e

by mmutsuzaki at Feb 18, 2008 11:13:26 PM

In the mysql console, there's a silly short limit on how many characters (or is it lines) that can be in a query. I routinely cut-and-paste queries from my editor into the console and I get "beep-beep-beep-..." for every character I've pasted over the limit. Ctrl-C!

Regarding argument "PostgreSQL: psql console better than mysql console" by john_beatty at Aug 10, 2007 11:43:56 AM
Regarding argument "PostgreSQL: Independent of Commercial Compromises" by john_beatty at Aug 11, 2007 5:24:18 PM