{"id":1512,"date":"2018-01-19T19:22:55","date_gmt":"2018-01-19T19:22:55","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/open-source-databases-as-the-tables-turn\/"},"modified":"2018-01-19T19:24:50","modified_gmt":"2018-01-19T19:24:50","slug":"open-source-databases-as-the-tables-turn","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/open-source-databases-as-the-tables-turn\/","title":{"rendered":"Open Source Databases: As the Tables Turn"},"content":{"rendered":"
\n
\n
By Tim Perdue<\/div>\n
on November 12, 2000<\/div>\n<\/p><\/div>\n
\"picture<\/p>\n
\nMy July Article<\/a> comparing PostgreSQL and MySQL
\ncaused a stir that really surprised me. Of course, users of both databases
\ncalled the tests rigged one way or the other, even though I noted that
\nboth databases had their strong points under various circumstances. <\/div>\n
\nAll that aside, we’ve been running into some rather grim and serious
\nMySQL problems on SourceForge<\/a> –
\nmost of which are directly related to MySQL’s table-level locking mechanism.
\nTo give us some breathing room, we’ve been running a Beta version of MySQL
\nwith pretty good success.<\/div>\n
\nThose problems and other MySQL limitations have caused me to evaluate
\ndatabase alternatives, first Interbase (apparently a dead end), then PostgreSQL.<\/div>\n
\nIt didn’t take long to rule out Interbase after discovering that it
\nlacked replication, full text indexing, and had serious community
\nand corporate issues around its “Open Sourceness”.<\/div>\n
\nPostgres also lacks replication and full text indexing (MySQL’s latest
\nbetas include both features), however the postgres people issued a press
\nrelease about replication (currently vaporware) and it will be coming
\nsoon.<\/div>\n
\nI’ve worked with Postgres quite a bit in the past and had occasional but
\nserious problems with reliability under some circumstances (Geocrawler.com
\nruns on Postgres and had a tendency to melt down every few months, losing
\nsome data in its 10GB database). So I began evaluation of Postgres 7.1 with
\nsome trepidation. My benchmarks in July showed PG 7.0 to be clearly slower
\nthan MySQL and I outlined several limitations that I found annoying. Still,
\nPostgres has dozens of advanced features that MySQL lacks (triggers, foreign
\nkeys, rules, subselects, views…) and was well worth investigating.<\/div>\n<\/div>\n

<\/p>\n

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

By Tim Perdue on November 12, 2000 My July Article comparing PostgreSQL and MySQL caused a stir that really surprised me. Of course, users of both databases called the tests rigged one way or the other, even though I noted that both databases had their strong points under various circumstances…. <\/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-1512","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1512","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=1512"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1512\/revisions"}],"predecessor-version":[{"id":2260,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1512\/revisions\/2260"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}