{"id":1441,"date":"2007-03-12T20:44:05","date_gmt":"2007-03-12T23:44:05","guid":{"rendered":"http:\/\/www.hoogervorst.ca\/arthur\/?p=1441"},"modified":"2007-10-06T10:10:38","modified_gmt":"2007-10-06T13:10:38","slug":"techhed","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=1441","title":{"rendered":"tech>he>d"},"content":{"rendered":"<p><span class=\"dropcap\">L<\/span>ast week, I read about the Canadian Tax problems, which forced the Revenue centre to shutdown operations because of &#8216;inconsistent&#8217; data. I hear that they expect to be up and <a href=\"http:\/\/www.cbc.ca\/money\/story\/2007\/03\/12\/taxfiling.html\">running starting next Thursday<\/a>. Earlier, via the Postgres mailing-list, I read that the problems were more in the &#8216;design&#8217; of some of <a href=\"http:\/\/www.thestar.com\/News\/article\/189175\">the internal tables<\/a>, which (of course) started a whole discussion about the lack of professionalism in the industry:\n<\/p>\n<p class=\"quote\">CRA spokesperson Jacqueline Couture said the problem resulted in scrambled information in electronic tax returns. For instance, <strong>in some cases the field for the social insurance number was instead filled in with a birth date<\/strong> <em>(ed. What, you mean, these weren&#8217;t strongly typed fields?)<\/em>\n<\/p>\n<p>If your stomach can bear it, the postgres thread follows <a href=\"http:\/\/archives.postgresql.org\/pgsql-general\/2007-03\/msg00400.php\">right here<\/a>.\n<\/p>\n<p>Alfons reminded me of XSLT, <a href=\"http:\/\/en.wikipedia.org\/wiki\/Xslt\">which is an XML language used for transformations<\/a>. XSLT comes in handy when you have to convert from one XML format to another. Obviously, his choice of flavour nowadays is XML and (good for you), <a href=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/0610k0w4(VS.80).aspx\">C# comes with good XSLT support too<\/a>. Earlier last year, I was looking into the <a href=\"http:\/\/www.xbrl.org\/Home\/\">XBRL standard<\/a>.\n<\/p>\n<p>I also found out that <a href=\"http:\/\/www.oracle.com\/database\/berkeley-db\/xml\/index.html\">Berkely DB has been a part of Oracle (since when?)<\/a>. Better yet, Oracle released the Berkeley DB XML as open source too. It&#8217;s a good 52 MB download.\n<\/p>\n<p>On the flipside, recently, I have played with <a href=\"http:\/\/www.sqlite.org\/\">SQLite<\/a>, which is a highly portable (multi-platform) embedded database engine. It&#8217;s so good, that it has been thrown in the Public Domain. And yes, apparently, the designer was heavily inspired by Postgres.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last week, I read about the Canadian Tax problems, which forced the Revenue centre to shutdown operations because of &#8216;inconsistent&#8217; data. I hear that they expect to be up and running starting next Thursday. Earlier, via the Postgres mailing-list, I &hellip; <a href=\"http:\/\/www.hoogervorst.ca\/arthur\/?p=1441\">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":[162,127,173],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/1441"}],"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=1441"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/1441\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1441"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}