{"id":1360,"date":"2006-12-09T00:11:02","date_gmt":"2006-12-09T04:11:02","guid":{"rendered":"http:\/\/www.hoogervorst.ca\/arthur\/?p=1360"},"modified":"2006-12-09T08:35:30","modified_gmt":"2006-12-09T12:35:30","slug":"from-databases-to-other-bunnies","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=1360","title":{"rendered":"From databases to other bunnies"},"content":{"rendered":"<p><span class=\"dropcap\">Y<\/span>ou may have noticed that the Postgres developers released a new version of the <a href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-8-2.html\">PostgreSQL database server<\/a>. There are particular reasons why I like working with Postgres: trivial data import and export is one of them. Take for example the following command (issued in psql):\n<\/p>\n<pre>COPY users FROM '\/home\/arthur\/ascii_users.csv' WITH DELIMITER AS ',' \r\n  NULL AS 'null';\r\n<\/pre>\n<p>In case your ODBC driver goes kaboom, there you have the solution!\n<\/p>\n<p><a id=\"p1361\" rel=\"attachment\" class=\"imagelink\" href=\"http:\/\/www.hoogervorst.ca\/arthur\/?attachment_id=1361\" title=\"O M G.\"><img decoding=\"async\" class=\"alignright\" src=\"http:\/\/www.hoogervorst.ca\/arthur\/wp-content\/uploads\/2006\/12\/bun_nie_s.thumbnail.jpg\" alt=\"O M G.\" \/><\/a>This week two other announcements stood out: First, OpenOffice&#8217;s OpenDocument <a href=\"http:\/\/www.iso.org\/iso\/en\/CatalogueDetailPage.CatalogueDetail?CSNUMBER=43485&#038;ICS1=35&#038;ICS2=240&#038;ICS3=30\">format became an ISO standard<\/a>. And then <a href=\"http:\/\/news.com.com\/Microsoft+sails+through+document+standard+vote\/2100-1013_3-6141777.html\">Microsoft Office&#8217;s Open XML<\/a>, by way of the ECMA, made it to the ISO body too. Saillant detail is that IBM apparently voted against this: as a vocal supporter of the other format, IBM said that a vote for Open XML was a vote about the past.\n<\/p>\n<p>I read that some US mapmakers, <a href=\"http:\/\/www.cnn.com\/2006\/US\/12\/08\/map.deletions.ap\/index.html\">are planning to exclude communities<\/a> with fewer than 2,500 people. I guess, there is always Google Maps or Microsoft Live Map Earth Something uh-huh to find these communities, provided that you have high-speed.\n<\/p>\n<p>And then, I heard about some Hydro One problem, apparently related to a CEO overcharging a creditcard (<a href=\"http:\/\/www.canada.com\/topics\/finance\/story.html?id=af358c1b-b6f2-4857-8aa7-52f36afd1b7c&#038;k=71430\">his secretary&#8217;s<\/a>) and I thought by myself &#8220;Hey, this Hydro One, <a href=\"http:\/\/www.cbc.ca\/money\/story\/2002\/07\/19\/hydroone_020719.html\">it rings a bell<\/a>&#8220;. And bunnies. Lots of bunnies, as you can tell from the picture above.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You may have noticed that the Postgres developers released a new version of the PostgreSQL database server. There are particular reasons why I like working with Postgres: trivial data import and export is one of them. Take for example the &hellip; <a href=\"http:\/\/www.hoogervorst.ca\/arthur\/?p=1360\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/1360"}],"collection":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1360"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/1360\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1360"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}