The Beta Test for oneSQL has been going well and I am very grateful for the feedback received. I still want additional Beta Testers however, so if you are interested please let me have your details here.
Since the start of the Beta barely a fortnight ago the product has changed in many subtle (and sometimes not so subtle) ways. I have documented the highlights below:
To start with the Database Logon and Connection Setup windows were combined into one single window that works in a far more intuitive fashion. Thanks primarily to Sasha Schneppmueller for his suggestions and feedback concerning the Logon and Connection Setup windows.
A Log ‘tab’ has been added to the Logon window and this records the history of the various database actions performed during the current session.
Thanks to Trisha Duke for thoroughly testing the CSV Export routine, which unfortunately had a couple of small bugs that had gone unnoticed. These were fixed and additional CSV export added using a ; rather than a Comma, in order to satisfy the standard in various Northern European countries.
The connection detail is now shown in the Titlebar of the main window. Still not sure if I like this …
The SQL can now be executed using a Shortcut Key. Cmd+R on the Mac and Ctrl+R on Windows.
James Sweiderk can up with some comments and issues, one of which is still outstanding (already implemented – just needs uploading). I have however fixed the issue with the USE command on MySQL and the list of Database Objects is now updated accordingly.
Peter Fargo mentioned some issues with inconsistency with the User Interface and Selection. I have now removed the Drag and Drop from the Database Objects lists and implemented Double Click which works faster / better and feels ‘cleaner’.
A bug with executing more than one statement from the same block of SQL text has been fixed. Another bug concerning the SQL History has been fixed. You can now double click any item in the list and it is copied back into the SQL Text area.
The Mac OSX version is now a 100% Cocoa product so plays extra nicely with the latest Apple Operating System updates.
In the latest Beta (0203) there is also the option to automatically prefix the Column Names with the Table Name and additionally to automatically insert a Comma after the insertion of a Column Name. These improvements help with Readability and Fast Query Composition respectively.
Some Images 🙂
Products and Affiliate Links