{"id":271,"date":"2008-08-25T21:19:36","date_gmt":"2008-08-25T20:19:36","guid":{"rendered":"http:\/\/www.malcolmhardie.com\/weblogs\/angus\/?p=271"},"modified":"2025-02-01T03:04:15","modified_gmt":"2025-02-01T03:04:15","slug":"sqleditor-progress","status":"publish","type":"post","link":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/2008\/08\/25\/sqleditor-progress\/","title":{"rendered":"SQLEditor Progress"},"content":{"rendered":"

It’s been a little while since I wrote about the release of SQLEditor so it’s time to write about what’s been happening with SQLEditor since then.<\/p>\n

SQLEditor 1.4.1.b2 (available now)
\n<\/strong><\/p>\n

There is a new bug fix release of SQLEditor available in beta right now. If the “Check for beta versions” box in the preferences window is checked then you’ll get the offer of the upgrade to 1.4.1b2.<\/p>\n

This is a minor bug fix release that fixes a few bugs that have been reported since the 1.4 release<\/p>\n

SQLEditor 1.4.1b3 (available soon)
\n<\/strong><\/p>\n

This release is going to fix a stupid bug that makes the file type selection in the export as image box not work correctly. The file types got mixed up in the code so the labels don’t match the output. It missed the b2 release, but it will be corrected in beta 3<\/p>\n

SQLEditor 1.5<\/strong><\/p>\n

This is the next big release of SQLEditor. It’s going to have an entirely new SQL parser (written in ANTLR 3<\/a>) and a major rewrite of the codebase (which moves almost all of the Java code to C or Objective C)<\/p>\n

The new parser replaces to the old Java based parser (written in Javacc) with a new one that runs entirely in C and Objective C. Although I have found JavaCC to be an excellent tool, this replacement reduces the amount of Java code in the application substantially.<\/p>\n

Plugins<\/strong><\/p>\n

The new code will also offer a much better api for plugins. The current api, which isn’t public, is used for the Rails import and export, but it’s annoying to work with, because the architecture wasn’t really built for it. The new codebase is much better for writing plugins.<\/p>\n

JDBC \/ JNI Library for Cocoa<\/strong><\/p>\n

SQLEditor 1.5 also uses a new Java JNI and JDBC library for Cocoa which I’m hoping to be able to make Open Source soon. It allows you to access a database using JDBC rather than ODBC. This may not be as efficient, but it’s much easier to install drivers. If you would like to try these new libraries in your own application please send me an email and I’ll send you some code to try out. The final libraries are probably going to be BSD licensed, but it’s still being worked out exactly how it will work.<\/p>\n","protected":false},"excerpt":{"rendered":"

It’s been a little while since I wrote about the release of SQLEditor so it’s time to write about what’s been happening with SQLEditor since then. SQLEditor 1.4.1.b2 (available now) There is a new bug fix release of SQLEditor available in beta right now. If the “Check for beta versions” box in the preferences window […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,12],"tags":[],"class_list":["post-271","post","type-post","status-publish","format-standard","hentry","category-general","category-sqleditor"],"_links":{"self":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/271","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=271"}],"version-history":[{"count":1,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/271\/revisions"}],"predecessor-version":[{"id":1431,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/271\/revisions\/1431"}],"wp:attachment":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/media?parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/categories?post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/tags?post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}