A new video has just been uploaded to YouTube. This video demonstrates how simple and straightforward it is to insert and print a Sales Invoice using blackdogCRM, currently in Beta. (There is only so many hours in the day!) 🙂
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:
Note that for this final Beta you should delete both your Settings and your Preferences file as there have been changes involving encryption.
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.
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.
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.
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.
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:
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!
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.
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: email@example.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:
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.
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.
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.
If you are interested in becoming a Beta Tester for oneSql, especially if you speak Italian 🙂 , then CLICK HERE. oneSql will be gaining support for Spanish over the next few days and within a couple of weeks Version 1.0 will be available to Purchase.
The Latest Beta Version of oneSql was uploaded earlier today. The main difference with this version is that PostgreSQL is now a supported database. This is in response to many requests from Beta Testers, Friends and Colleagues.
oneSql now supports MySQL, SQLite, MariaDB and PostgreSQL.
Additional changes in this version include the following:
If you are an existing Beta Tester then please Trash your existing Settings and Preferences files before using this version.
If you would like to become a Beta Tester than CLICK HERE.
Version 1.0 will be available very shortly, assuming this Beta Version doesn't suffer with too may bugs or issues 🙂 If you are a Beta Tester then let me know if you require your 30% Discount coupon and I'll get it sent over to you as soon as possible 🙂
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:
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.
There is a new Beta Edition of oneSql available. This update to oneSql adds an Import Data option to the Tools menu. This new menu option opens the Import Data window where you can setup your import structure.
This is done in the Configure tab of the Import Data window. You can select the type of file that you will be importing (delimited by Tab, Comma or Semicolon), you then select the Database Table you wish to import into.
The next thing is to Double Click the Columns that you wish to update. Double Clicking in the Available Columns list moves the Column to the Selected Columns list. Double Clicking in the Selected Columns list moves the Column back out to the Available Columns list.
You can reorder columns by selecting the column and dragging it within the list.
Once you have configured the import to match your import file, click the Import tab. Here you can see we have two buttons. The first button loads your text file into the import list and the second button marked Save creates the necessary import statements behind the scenes and writes your import file to your database.
Once the import is complete the import list is cleared and you are told how many rows have been processed.
Note the Checkbox options to ignore the first line (if you are using column headings in your source file) and to remove double quotes (often seen in badly formed import files).
The third tab option, Templates, is not yet implemented. This is where you will be able to save your import configurations and give them a name so that you can retrieve them quickly and use them again at a future time. A potentially very useful facility. Let us know if you would find this feature useful.
If you are interested in becoming a Beta Tester for oneSql, please click here: http://bit.ly/1lq3kk8
The latest version of oneSql Beta Edition now supports French as well as English. German, Spanish and Italian coming very soon 🙂 We are still keen for more Beta Testers, especially those who are running French Operating Systems on their PC’s or Macs.
A couple of images 🙂
Products and Affiliate Links
The latest Beta version of oneSql has additional Help Tags added, some small bug fixes, and much more significantly it has the infrastructure added to allow for a Multi-Language Interface. So for example if you are running a French Operating System on your computer then oneSql will have it’s User Interface shown in French, the same for German, Spanish and also Italian.
Currently it supports English(UK) (English) and English (American) – seriously! – where the USA drops a ‘u’ from Colour or puts a ‘Z’ where an ‘S’ belongs then this version will reflect that 😉
I’ve commissioned the other translations and so far have them available in German and Italian, once I have the other translations I will import them into oneSql and release a true Multi Lingual Beta version for testing.
Products and Affiliate Links
oneSQL is now available to download, free of charge. This is a Beta Version of oneSQL which means that it is nearly ready for general release but may still have some bugs, be incomplete in some areas, have a lack of documentation or other issues.
This current version appears stable and working well – but I welcome your feedback.
In particular if you use Linux I would love your feedback as so far I have been unable to test on Linux.
I only ask for your Name and Email Address and I will send you the current version of oneSQL. Your email address will not be sold or abused in any way – so don’t feel uncomfortable giving me that information. Your email address will only be used for communication regarding oneSQL unless you agree otherwise.
Having got the above out of the way I perhaps ought to explain what oneSQL is and why you should care;
oneSQL is a Software Program that allows you to send SQL Query SELECT‘s and other SQL Commands to either a SQLite or MySQL database. oneSQL is written using the DataViewer Components for Xojo and RealStudio.
oneSql is a Stand Alone SQL Query and Data Export Tool for SQLite and MySQL on Windows, Mac OSX and Linux.
Why Use oneSQL ?
Some More Benefits
Q: What is the difference between oneSql and DataViewer ? A: oneSql is a stand alone application for querying, editing and manipulating SQLite and MySQL databases. DataViewer is the necessary Modules and Windows to allow you to incorporate the querying functionality into your own software, and restrict access for the end user to the database(s) you need them to access only.