oneSql Latest Beta 3006c with Encryption

Updated 02/07/2014-1740: The bug in 3006b which causes an intermittent crash when attempting to logon to a Database Connection, has been fixed along with the following tweaks in Release 3006c:

  • New Preferences Option to Hide the External SQL File Load and Save Buttons
  • Adding to the Script Library no Longer Clears the Script List
  • Double Clicking the Script List now Populates the SQL Text on the Main window
  • A little bit of Refactoring

onesql3006b

This latest Beta Release of oneSql comes very close to the official Version 1.0 release, which I expect to be within the following two weeks, definitely before the end of July. I have one more language to add (Spanish) and I already have the translations so that should be relatively straightforward.

I also have a few tweaks to the software to do, the Manual to finish and some more testing and then hopefully we will be good to go with a Version 1.0 release. There are a couple of features that make this a fairly major release, so read on 🙂

I’m always keen for more Beta Testers, so if you are interested please CLICK HERE!

Release Notes:

One major change in this release is that the stored Password Credentials for the Connections are now stored in an encrypted manner. This stops someone snooping your database password by querying the connection record from the settings database.

There is more to this however. See the image below of the Preferences window from oneSql.

onesqlprefs3006b

There are two choices for the encryption. The top choice encrypts the Connection Password in such a way that it is then specific to your computer. If you copy oneSql and the Settings Files onto another computer then the Stored Credentials will not work. This choice is ideal for use in a more secure environment, where for example access to databases is only permitted from select computers and / or locations.

The second choice encrypts the Connection Password in such a way that you can copy the oneSql folder from your computer, put it onto your laptop, or another computer, and your stored credentials will work fine.

This also means that you can copy (oneSql does not need an installation, nor does it put any files on your computer outside of the oneSql folder) oneSql onto a USB Drive, run it from that USB Drive on any Mac, Windows or Linux machine you plug it into. Did I mention it will render itself in your native language as well – as long as your native language is either English, Spanish, French, German or Italian ?  🙂

Does copying oneSql to a USB Drive go against the Software License ?  No. Restricting access to a single computer either by the installation of Configuration Files or Registry Entries goes against the design remit of Utility software which in my (not so!) humble opinion is the Developers or DBA’s equivalent of a tradesmans tools.

Can you imagine a screwdriver being licensed to only be used on a given object ? What if you had to pay for another license for every object on which you used your screwdriver ? Forget the expense, it’s just not convenient. I don’t want to punish legitimate users of my software in a vain attempt to stop people stealing my software.

My software License for oneSql is simple, and is based on Concurrency. You can use oneSql on one device at once. If you install it on more than one device then you owe me a few extra $$$, which the software is obviously worth or you wouldn’t be bothering to install it multiple times. Site Licenses,  Educational Licenses etc. are all available – contact me for further details: scholerton@gmail.com

Ok, so I diversified slightly(!) in the last paragraph, (in fact, I’ll rewrite the last paragraph and make it its own blog post as I’m sure the licensing question will be asked often.) back to the 3006b release of oneSql.

Please Note that once you have chosen your preferred type of Encryption, you will need to Select Each Connection and Re-input the Password, then Save. This is a one off procedure that is absolutely necessary or else your Stored Credentials will not work.

This release also includes a new Menu – Actions. From the Actions Menu you currently have the following choices available, which are I think self explanatory:

  • Execute SQL: Ctrl / Cmd R
  • Clear SQL Script
  • Clear Results List
  • Clear History List
  • Clear All

One feature that I put in, took out and have now put back into oneSql is the ability to select a portion of the SQL text and execute just the highlighted selection. I have found this facility very advantageous in similar products and believe it is a worthy addition to the oneSql feature set.

The other fairly major addition in this release is the Script Library. The picture below has been annotated so I’m sure you can see where I’m going with this.

onesql3006scriptlibrary

The ability to store SQL Scripts within the SQL database tool, categorised by Connection (or not – if that’s what you prefer) is I believe very important.

Future versions of oneSql will allow far greater capability and flexibility in the Script Library, for now however we have the basics on which to build something extremely useful.

The Script Library window can be accessed from the Tools Menu of oneSql.

IMPORTANT: If you are NOT creating a new oneSql folder from scratch then it will be necesary to update your oneSql Settings file (oneSqlSettings.db in the SupportFiles folder) by opening it with a SQL Tool (oneSql ?!) and executing the following SQL Statement:

CREATE TABLE csh_scr_main (scr_pk INTEGER PRIMARY KEY AUTOINCREMENT, scr_name VARCHAR(50) NOT NULL, scr_script VARCHAR(9999), scr_con_pk INTEGER DEFAULT 0)

This will create the necessary table to store Scripts. This table (and all others required) is automatically created if this is the first time you have used oneSql.

The previous oneSql Beta ran out yesterday (30th June 2014). This release will work during July only, as the commercial release of Version 1.0 will be out before the end of this month.

Purchase

If you would like to purchase oneSql for the pre-release price of £15 (valid until Version 1.0 arrives) then you can do so from here. You will receive the same upgrades and support as anyone who purchases Version 1.0 later at the more expensive (and as yet undecided) standard price.

onesql

Affiliate Links

 

oneSql: Now in German

The latest version of oneSql Beta Edition now supports German as well as English, American and French. Spanish and Italian coming very soon 🙂 We are still keen for more Beta Testers, especially those who are running German or French Operating Systems on their PC’s or Macs.

oneSql: Support Window

Available from the oneSql Help menu. This window will also appear in other products as a standard feature allowing customers to email support directly from within the application. From my point of view the email will automatically contain everything I need to know about the version of the software they are running, which will help me greatly.

www.stevencholerton.com

Blogfooter

 Products and Affiliate Links

 

oneSql: User Prompt Fields

oneSql Beta Update: 0402

Unique Prompt Fields are field templates that are setup in advance and saved with a SQL Script. When the script is executed the user is prompted for the necessary values to use. The video below shows how this works: 

UPFs are especially convenient when writing a query for use by yourself or a third party, and when the query will have to be executed several times, for example as part of a weekly / monthly reporting regime. The third party would need to know nothing about SQL to be able to load and execute a query with embedded UPFs. Consistency and Accuracy are maintained using UPFs.

Here is another example showing each stage of working with the User Prompt Fields. The first image shown below shows a SQL Query that has been loaded from an external file. You can see in the image that there are three UPFs, a Number Value, a Text String and a Date.

Onesql up 1

 

An explanation of the format for a UPF is shown in the next image:

Upf

The next image shows what happens when this query is executed; The query is parsed and all UPFs are pulled into a window and presented to the user asking for the required input.  There is no practical limit to the quantity of UPF’s that you can use in any given query,

Onesql up 2

This next image is the same as the one above, but with the required information having been entered by the user.

Onesql up 3

Pressing the Continue button on the User Input window reformats / rewrites the query using the information entered by the user and then immediately executes the query and displays the results in the Results Set.  See the image below:

Onesql up 4

UPFs are available in oneSql from Beta 0403.  To request a Beta Test copy of oneSql, please contact me: beta@zombielabs.net

Blogfooter

 Products and Affiliate Links

oneSql Beta Update

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.

Betatesting

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 🙂

www.stevencholerton.com

oneSQL Legend

Products and Affiliate Links

jSql == oneSql

As per the title, the beta product previously know as jSql has now been renamed oneSql. The main reason is that I did not want the unnecessary and undesirable association with Java.  Not that I have anything against Java, but I think when it comes to User Interface Java applications are overly compromised and I just didn’t want to foster that association.

It’s also just a better name and suits the future direction of the product.oneSQL Logon

oneSQL

oneSQL Legend

If you are interested in receiving a copy to play with before the official launch, then just leave your Name and Email Address below:

blog_footer.png

Products
Affiliate Links