{"id":261,"date":"2008-06-20T15:05:12","date_gmt":"2008-06-20T14:05:12","guid":{"rendered":"http:\/\/www.malcolmhardie.com\/weblogs\/angus\/?p=261"},"modified":"2025-02-01T03:04:15","modified_gmt":"2025-02-01T03:04:15","slug":"sqleditor-15","status":"publish","type":"post","link":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/2008\/06\/20\/sqleditor-15\/","title":{"rendered":"SQLEditor 1.5"},"content":{"rendered":"<p>SQLEditor 1.5 is making good progress. The latest thing that I&#8217;m currently working on is to extract SQL Views from a database. In theory this should be just like extracting tables, but it&#8217;s looking much harder to work out than I ever expected.<\/p>\n<p>The new SQL parser is mostly finished. It&#8217;s been completely rewritten using <a href=\"http:\/\/www.antlr.org\">ANTLR3<\/a>. This offers a number of really good improvements, the most important one being that it&#8217;s not running in Java anymore. The parser is now completely native code.<\/p>\n<p>Also pretty much finished is the new document model code, the new document export code and the new JDBC handling code. I&#8217;m hopeful that it will now be possible to run JDBC drivers that use AWT (which I&#8217;m informed the IBM DB2 driver may do).<\/p>\n<p>SQLEditor 1.4 is just about finished too. There is one change that needs to get beta tested and then the 1.4 final release should be available.<\/p>\n<p>Watch out for a new 1.5 download soon and of course the final candidate for 1.4<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLEditor 1.5 is making good progress. The latest thing that I&#8217;m currently working on is to extract SQL Views from a database. In theory this should be just like extracting tables, but it&#8217;s looking much harder to work out than I ever expected. The new SQL parser is mostly finished. It&#8217;s been completely rewritten using [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-261","post","type-post","status-publish","format-standard","hentry","category-sqleditor"],"_links":{"self":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/comments?post=261"}],"version-history":[{"count":1,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/261\/revisions"}],"predecessor-version":[{"id":1439,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/261\/revisions\/1439"}],"wp:attachment":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/media?parent=261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/categories?post=261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/tags?post=261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}