{"id":166,"date":"2004-07-07T11:52:30","date_gmt":"2004-07-07T09:52:30","guid":{"rendered":"http:\/\/10.0.0.2\/wordpress\/?p=166"},"modified":"2004-07-07T11:52:30","modified_gmt":"2004-07-07T09:52:30","slug":"postgresql","status":"publish","type":"post","link":"https:\/\/www.switchbl8.nl\/blog\/2004\/07\/postgresql\/","title":{"rendered":"PostgreSQL"},"content":{"rendered":"<p>Since I participate in the RC-72 contest of <a href=\"http:\/\/www.distributed.net\/\">Distributed.net<\/a>, I regularly visit the <a href=\"http:\/\/stats.distributed.net\/team\/tmsummary.php?project_id=8&amp;team=1070\">stats pages<\/a>. A while ago, the guys switched from Sybase to PostgreSQL as their database of choice. On the statspages the PostgreSQL-logo is displayed, so I clicked it recently.<\/p>\n<p>PostgreSQL looks like a good choice if you are, like me, accustomed to Oracle. I hope version 7.5 will bring a decent Windows version, since Cygwin is not something I like very much. But tablespaces, replication, foreign-keys and subselects are things I do like. I&#8217;ll let you guys know when I installed it, and what my findings are.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since I participate in the RC-72 contest of Distributed.net, I regularly visit the stats pages. A while ago, the guys switched from Sybase to PostgreSQL as their database of choice. On the statspages the PostgreSQL-logo is displayed, so I clicked it recently. PostgreSQL looks like a good choice if you are, like me, accustomed to <a href='https:\/\/www.switchbl8.nl\/blog\/2004\/07\/postgresql\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,27],"tags":[],"class_list":["post-166","post","type-post","status-publish","format-standard","hentry","category-business","category-software","category-5-id","category-27-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=166"}],"version-history":[{"count":0,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/166\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}