Angus Thinks

Category: SQLEditor

  • SQLEditor 1.4.3b3

    So, it’s coming up to the holidays, but there is time for another SQLEditor release.

    1.4.3b3 (snappy numbering, yes?) is pretty much a bug fix release. I think that the index creation problems that were happening have now been fixed, plus better handling of when to create indexes. It should now correctly figure out if fields are indexed and shouldn’t now add duplicates (or worse attempt to add duplicates)

    There is also the addition of the simulate mode for database export. This isn’t exactly new, because it’s been available in some development builds, but it has now appeared in a release version. Simulate mode runs the entire export as normal, except that instructions that alter the database aren’t actually sent to the database to be executed. The instructions are recorded though, so you can see what would have happened in the status window log view.

    There is also a new feature which prevents fields and indexes being dropped (although it doesn’t prevent modification, use simulate if that’s what you want)

    SQLEditor also now adds a line in the status window when an export fails complete with the instructions that were actually executed and the error that occurred. This information was always in the log, but it should be easier to see how SQLEditor has gone wrong (in the event that it does of course)

    Finally some fixes for a few (hopefully unlikely) crashing bugs.


    Download

    3.6MB dmg File

    Change Log
    Product Notes
    Expires
    21st January 2009

  • MySQL before 4.1?

    This graph appears to show that most people polled (97%) are using MySQL 4.1 or later

    This second poll shows, again, that most people (89%) are using 4.1 or later.

    The thread at the PunBB forum gives 95% of people polled using 4.1 or later.

    The Mambo forum poll from 2006 gives 80% using versions after 4.1 (with 8.5% don’t know or other)

    Admittedly not scientific surveys (self selection, etc) but somewhat convincing.

    This has an obvious implication on how to handle MySQL support, in particular special casing to work around particular issues in early versions. This code adds complexity and in some unfortunate cases also bugs. The less there is, the better.

  • SQLEditor updates

    I’ve just released a new version of SQLEditor yesterday, mainly as a bug fix release, but it’s definitely recommended to upgrade.

    The new beta is 1.4.3b1 which was released 14th November. It fixes a number of bugs, including MySQL comments and some odd bugs relating to selecting tables using the drag selection method.

    Download 1.4.3b1 (3.6MB DMG)

    The current stable version is 1.4.2 which came out at the end of October. It fixed several significant bugs that people reported and made a few minor improvements.

    Download 1.4.2 (3.6MB DMG)

  • Django Support

    Several people have now asked for this, so it’s being really seriously looked at.

    Plus I’m hopeful that it will be able to support the somewhat different but quite similar Google app engine model class format too

    Having been working on this for the last few days, I can say that the Django plugin is moving towards a working state, the development version is now somewhat able to create and export a suitable python file.

    Although this mustn’t be taken to mean that it’s near to release, because there are still several major things that are needed before it will be complete.

    I think there will probably be two releases, the first will be export only, then a later release will add the import features.

    And it should be a free upgrade for SQLEditor 🙂

  • SQLEditor releases

    This is another quick update about SQLEditor releases in the near future.

    1.4.2b1

    Currently version 1.4.2b1 is in beta release, it offers a few specific improvements

    • Added support for editing MySQL character set and collation settings on fields and tables
    • Modified inspector on fields to use popup menu for selecting tabs
    • Fixed bug that prevented saving files after creating new foreign keys when referencing primary keys in tables with indexes under certain circumstances.

    1.4.2b2

    1.4.2b2 is due fairly soon. The following improvements should definitely appear

    • Modified MySQL exporter to use ENGINE instead of TYPE for better compatibility
    • Comments now attached to fields when exporting MySQL
      (i.e COMMENT ‘xyz’ style)
    • Connector inspector is now displayed automatically when a new connector is created
    • More padding added to line click detection to make it easier to click on connectors
    • Better parsing of comments attached to mysql field

    There is also a bug relating to identifying objects in Postgresql when there is no schema when using some versions of that database system.This is currently planned to be included but hasn’t actually been finished yet. If the work on this bug gets completed this week it will appear in 1.4.2b2, otherwise it will get pushed to the next release.

    I think that’s everything that’s coming in the near future, there are some other things that I’ve been working on, but they’re more long term (mainly for 1.5), so not much to say yet.

  • SQLEditor Progress

    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 is checked then you’ll get the offer of the upgrade to 1.4.1b2.

    This is a minor bug fix release that fixes a few bugs that have been reported since the 1.4 release

    SQLEditor 1.4.1b3 (available soon)

    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

    SQLEditor 1.5

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

    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.

    Plugins

    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.

    JDBC / JNI Library for Cocoa

    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.

  • SQLEditor 1.4 Final Released

    In case you missed it version 1.4 of SQLEditor was released back on July 8th.

    If you’re using 1.3.9 you might like to consider upgrading.

    The 1.3.9 upgrade system will be set soon to recommend this upgrade
    (though 1.3.9 doesn’t use sparkle, so it can’t actually do the upgrade for you)

    SQLEditor 1.4
    (3.6 MB DMG File)

    Lots of great new features and various bug fixes and improvements to the existing ones.

  • SQLEditor 1.4b26

    SQLEditor 1.4b26 is now available for download.

    It fixes only one problem which is related to auto increment and SQLite.

    This should hopefully be the final beta version for 1.4

    🙂

    The next version should be the 1.4 final release which will probably happen later this week or early next week (assuming no more problems are reported)

    SQLEditor 1.4b26 Download [3.6MB DMG]

  • SQLEditor 1.5

    SQLEditor 1.5 is making good progress. The latest thing that I’m currently working on is to extract SQL Views from a database. In theory this should be just like extracting tables, but it’s looking much harder to work out than I ever expected.

    The new SQL parser is mostly finished. It’s been completely rewritten using ANTLR3. This offers a number of really good improvements, the most important one being that it’s not running in Java anymore. The parser is now completely native code.

    Also pretty much finished is the new document model code, the new document export code and the new JDBC handling code. I’m hopeful that it will now be possible to run JDBC drivers that use AWT (which I’m informed the IBM DB2 driver may do).

    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.

    Watch out for a new 1.5 download soon and of course the final candidate for 1.4

  • 10.5 support

    At the moment I believe that both SQLEditor and HTMLValidator are compatible with Mac OS X 10.5 and should work without functional difficulty.

    A minor issue that I found is that the toolbar icons don’t look very good against the 10.5 window style. These have already been redrawn and the new icons will appear in the 1.4 release.

    This assumes that there weren’t any major changes between the version that I used to test and the release version of 10.5 which will be released on October 26th.

    Overall it looks good though.