New Pinterest Account

We now have a Pinterest account. Still in it’s infancy and only a few dozen images so far, but if you want a peek, here it is:

Follow Steven’s board chol.technology on Pinterest.

 

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: DataViewer

Visual Guide to oneSql: Part 2

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql

Results Tab Selected

dataviewerwindowexplained1

Database Objects Tab Selected

dataviewerwindowexplained2

Statement History Tab Selected

dataviewerwindowexplained3

 

busbannerAffiliate Links

Software Licensing and Software Piracy: Part 3

If you’ve made it Part 3 then you either find this subject really interesting or else you have difficulty sleeping at night ūüôā¬†¬†This final part of my article on Software Licensing discusses some of the ‘nitty gritty’ and gets down and dirty with some real code samples. All code samples¬†are taken from oneSql.

The value of Part 3 of this article¬†will be mainly to developers using the Xojo Programming Language for Cross Platform Software Development, although developers in any language can benefit and in fact anybody with an interest in going ‘behind the scenes’ of software development.

One thing very noticeable when preparing this article is just how much ‘behind the scenes’ work is necessary sometimes to give the customer a simple, slick¬†experience. Simple is hard ! The way this article is structured with a Customer Experience section followed straight after by a Behind the Scenes section, makes this very clear.

CUSTOMER EXPERIENCE [1]

When the customer decides that your product is for her, as far is as she is concerned the following two events take place:

  • The customer clicks the Buy Now button and is taken to the Paypal login page.
  • The customer decides whether to pay via Card or Paypal, then fills in the form and submits the document.

BEHIND THE SCENES [1]

chol.technology receive the Order Confirmation via Paypal. The chol.technology LicenseBoss Software automates the following sequence of events:

  • Product and Edition Information fetched from the LicenseBoss Database
  • The Encryption Key for the Product Editon is retrieved. Abbreviated as Key1
  • LicenseBoss parses and Inputs: User Name, Email Address, TimeStamp and Transaction ID
  • LicenseBoss combines the input into a string with appropriate delimiters and identity markers
  • We¬†now have a ClearTextLicenseString
  • The ClearTextLicenseString is then encrypted using Key1. We now have¬†the EncryptedLicenseString
  • The¬†ClearTextLicenseString and the¬†EncryptedLicenseString are then concatenated
  • We now have the¬†FirstPassLicenseFileString
  • FirstPassLicenseFileString is then encrypted using the License File Encryption Key =¬†Key 2
  • We now have the EncryptedLicenseFileContentsString
  • An email is then generated from a Template and the¬†EncryptedLicenseFileContentsString¬† is appended
  • The email is sent to the customer

CUSTOMER EXPERIENCE [2]

The customer receives an email which looks similar to this:

licenseemail

The instructions are Clearly Documented for the customer in an email as a Four Step Process. After Step 4 the product is fully licensed, and the window below is displayed briefly before closing automatically:

onesqllicensewindow

BEHIND THE SCENES [2]

The Software License window, accepts the email pasted into it and immediately strips the unnecessary information and displays the encrypted license. The actual encrypted license is contained between the <CHOLTECH> and </CHOLTECH> tags, therefore the only part of the pasted email that is displayed and then processed is the part taken from between those two tags.

When the Save button is pressed the encrypted license is created as a text file and stored in the SupportFiles folder within the oneSql folder. The newly created license file is called oneSqlLicense.lic

At this point the License File Decode method is called with the license file contents as a string parameter. Multiple flags are altered and adjusted within the program to indicate that the product is now licensed. Further details on that wouldn’t be prudent for me to discuss publicly ūüôā

The actual license file decode method is straightforward. All the Encryption and Decryption routines are pre-build, based on my R10Cipher File and Text Encryption product, (shameless plug Р developer licenses are available for the Encryption modules, contact me for details) and imported into my products as a module whenever I start to develop a new program.

Obviously the DecodeLicenseFile method basically reverses the work done by the EncodeLicenseFile method in the LicenseBoss program as described in step by step detail earlier.

I know some of you out there are Xojo Developers, so here’s a commented example of the code. You can see how straightforward it actually is:

decodelicensefile1

decodelicensefile2

decodelicensefile3

 

NOTE: Licensing in this fashion has an additional benefit. It caters for Zero Effort Configuration.

In a corporate environment if you were rolling out oneSql to dozens of computers, you could have a centrally situated Corporate or Site License which could be copied to each persons computer using a script. Very Fast, Very Simple and Damned Convenient ūüôā ¬†Essentially zero interaction required from the user. That’s got to be a good thing ūüôā

busbanner

Affiliate Links

oneSql Multi Database Tool: Final Beta

The Final Beta of my Cross Platform, Multi¬†Language, Multi¬†Database Tool –¬†oneSql is now available. Hopefully I’ve got everything right and it performs as expected with no (major!) bugs. Existing Beta Testers can download from the usual place, and new Beta Testers can sign up HERE.

Prior to release I have to finish the Manual, finalise Pricing, setup Paypal and also setup a Sample Database for new users to use during their Trial Mode. I also need to put¬†the oneSql website live … mmm more than I realised … ūüôā

The final artwork has arrived back for the oneSql box and the oneSql manual, you can see the images below:

onesqlcoverimages

Note that for this final Beta you should delete both your Settings and your Preferences file as there have been changes involving encryption.

For information on Software Licensing for oneSql, have a look at my recent blog posts on this subject, here and here.

I wanted to do something different to mark the release of oneSql, so I am toying with the following idea of a bonus or incentive, I’d love to know your opinions:

The first 10 people to purchase any edition of oneSql (except the Single User Standard Edition) will receive a Limited Edition oneSql mug (1 of only 20 in existence) as well as a goody bag of assorted promotional items. In addition they will receive a printed and signed edition of my computer security ebook, ‘Securing the Network’. I may even throw a T-Shirt in there as well ūüôā I will ship this bonus to anywhere in the world.¬†

The first 100 purchasers of oneSql Single User Standard Edition receive a voucher worth $5 off their next purchase from chol.technology.

As always – leave you comments below. If you don’t talk I can’t listen.

busbanner

Affiliate Links

Spanish Language Beta of oneSql Available

Finally !  English, French, German, Italian and now Spanish are all supported by the latest Beta of oneSql, our Cross Platform, Multi-Database SQL and Database Tool.

onesql_0907

Always interested in additional Beta Testers, if you are interested you can go to this page to register your interest.

Besides the addition of Spanish as a supported language, there are just a few more changes ‘under the hood’ so to speak.

  • New Default Logon for MariaDB: root
  • New Default Logon for PostGreSQL: postgres
  • New Windows Menu
  • Main Window Area Zoom Facility
  • Logon Window, Cleaner User Interface
  • Logon Window, Removed the Connections Log
  • Did I mention Spanish Language Support ?

Existing Beta Testers can download from the Build List in the Trello project as usual.¬†Please let me know of any issues as the Release Version is due very soon now … ūüôā Your time and efforts are much appreciated.

busbanner

Affiliate Links

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: New Beta Release for Cross Platform Tool

oneSql Beta Edition 1606 was¬†released earlier today. ¬†With one thing and another this release has been a while coming. I hope it’s considered worth it !

The main changes in this release are:

  • UI / Button Behaviour on Connection Window: Revised
  • MariaDB: Implemented as a Totally Separate Database Option
  • Data Import Templates: Complete
  • New Save Icon
  • Assorted Tweaks, Refactors and Bug Fixes

I have uploaded a couple of movies to YouTube that demonstrate how the Data Import Templates work. These templates could make your life much simpler and convenient should you need to import data often. For the Version 1.0 of oneSql their functionality will remain virtually unchanged, however future releases will include Update as well as Insert functionality, Programmable Column Values, Logically Calculated Column Values, Automation and much more.

oneSql: Creating an Import Template

Using an Import Template

Here are some screenshots taken from the latest version of oneSql.

onesql_1606_4