{"id":1499,"date":"2018-01-19T19:22:54","date_gmt":"2018-01-19T19:22:54","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/mysql-and-postgresql-compared-page-5\/"},"modified":"2018-01-19T19:24:50","modified_gmt":"2018-01-19T19:24:50","slug":"mysql-and-postgresql-compared-page-5","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/mysql-and-postgresql-compared-page-5\/","title":{"rendered":"MySQL and PostgreSQL Compared Page 5"},"content":{"rendered":"
\n
\n
By Tim Perdue<\/div>\n
on July 30, 2000<\/div>\n<\/p><\/div>\n
\n

Conclusion<\/h2>\n
\nThese tests pretty much confirmed what I already knew – both databases serve
\nquite well for the vast majority of web sites out there. Both are actually
\nextremely fast when compared to desktop databases like FileMaker and MS Access.
\nBoth are now free and supported by an active developer community.<\/div>\n
\nTo choose between the two databases, you first need to understand your
\nscalability limits and whether you need the transaction support of Postgres or
\nthe large-text-area support in MySQL. You may need both, in which case you have
\nto wait for future stable releases of both databases.<\/div>\n
\nIt’s interesting to note that the two databases appear to be converging to meet
\nin the middle somewhere. While MySQL is working on adding transaction support
\nand slowly adding features like subselects, Postgres is making headway in the
\nperformance and stability departments. <\/div>\n
\nFinally, for the hardest-core developers, Postgres could be pretty slick.
\nForeign keys, views, subselects, and transactions can all be pretty cool — if
\nyou need them and you will make any use of them. If you don’t need them or
\nwon’t use them, then you’re probably better off with MySQL and its superior
\nperformance.<\/div>\n
\n–Tim<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
| <\/div>\n
5<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Tim Perdue on July 30, 2000 Conclusion These tests pretty much confirmed what I already knew – both databases serve quite well for the vast majority of web sites out there. Both are actually extremely fast when compared to desktop databases like FileMaker and MS Access. Both are now… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1499","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1499"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1499\/revisions"}],"predecessor-version":[{"id":3343,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1499\/revisions\/3343"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}