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?
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||