Magic Cipher Video: Steganography (Hiding Data in Images)

http://www.magiccipher.com

Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications. Contact Us

Magic Cipher Video: File and Folder Encryption

http://www.magiccipher.com

Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications. Contact Us

Magic Cipher: Usage Scenarios and Examples

Example 1: One to One Private Communications

Bill and Ted are ready to start making plans for their next Excellent Adventure. Knowing that their email discussions could be intercepted and easily read, they use the Magic Cipher Shared Secret Generator with it’s Strength Meter to create a Shared Secret they can use together.

They type their discussions into Magic Cipher and email the contents as encrypted text directly from within Magic Cipher. They are now secure in the knowledge that no­-one can obtain access to their plans and attempt to put a spanner in the works!

Example 2: One to Many Private Communications

Bill and Ted decide they want to involve the Historical Babes in some of their plans, but not all. The four of them agree a Shared Secret and now Bill and Ted can communicate between themselves using their own Shared Secret and if they wish to include the Historical Babes they use the second Shared Secret previously agreed between the four of them.

Example 3: One to Many Private Communications over a Public Medium

Frodo is setting off on his next adventure and as is the fashion nowadays he wants to update the world with his travels via an online blog. With his new Macbook Pro this will be easy enough, however there is certain information he wishes only to be read and understood by Merry and Pippin who are holding the fort for him back in Hobbiton.

Before he sets off the three of them agree on a Shared Secret and as Frodo updates the world via his blog he uses Magic Cipher to append an encrypted entry on the end of his posts, in a separate paragraph, knowing that the world can see but not read or understand his instructions, which are only for the eyes of Merry and Pippin. Frodo uses the built in Virtual Keyboard to add a little bit of extra security to his posts.

Example 4: The Benefits of Cross Platform

Unfortunately, small, slim and gorgeous though it is, the Macbook Pro is just a little bit too big ­ and let’s face it, expensive ­ to take across Middle Earth, what with the danger from the Orcs and other dark forces.

At the last minute Frodo decides to switch to a small Linux notebook which he obtained free of charge with his mobile broadband card. Luckily Magic Cipher works as well on Linux as it does on macOS or Windows, so Frodo has no need to change his plans, or his choice of encryption software.

Example 5: Magic Cipher, Not Just for Men

While Frodo is off on his travels his wife, feeling lonely, takes a lover. Knowing that the local Hobbiton ISP takes quite an interest in emails to and from the villagers, they both use Magic Cipher to arrange their rendezvous. Even hobbits need loving.

Besides it was rather selfish of Frodo to disappear like that for months at a time ­ and who knows what he got up to with Sam on that epic journey?

Example 6: A Picture is Worth a Thousand Words …

Sat on his sofa safe back at home several months after his epic journey to Mordor, Frodo dreams of his next challenge. With Sam on board, who now lives several miles away in Bree, Frodo and Sam use the Steganography features of Magic Cipher to enable them to swap ideas and plans which they have hidden in pictures which they upload to their Facebook pages.

With no evidence that their pictures are anything more than rather boring pictures of Sams garden or Frodos wine collection, nobody has any clue that there is another adventure being planned. In fact nobody has any reason to suspect Sam and Frodo are even in communication regularly. Problem Solved!

Magic Cipher Video: Text / Email Encryption

http://www.magiccipher.com

Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications. Contact Us

Magic Cipher: The Story [1/2]

In 2007 I’d just launched my first application for the Mac, macVCR and I was looking for inspiration for my next project. I had long recognised the need for a simple and easy to use encryption program and hadn’t been able to find one. I decided my goal should be to create one.  Not only would this ‘scratch an itch’ it would hopefully go on to become a successful product in its own right.  If I needed this then so did others.

The problem was that I used, and still do, macOS, Windows and Linux on a regular basis, and so would some of my customers. If they, for example, use Windows now – they may use macOS in the future.  For this to be a worthwhile endeavour my product would have to run on those three major operating system platforms and provide transparency and compatibility between them. This was no longer a small project.

R10Cipher: Supported Operating Systems

To make this product a reality I chose Xojo as a development platform, or REALStudio as it was then known, and set to work creating R10Cipher.

The first thing I needed was a Vision Statement, something to guide me during development and help focus my thoughts. I settled on the following:

A Simple and Easy Method to Safely Encrypt your Email Correspondence and Document Files.  It’s like your emails and documents are carried by a SWAT team rather than being written on a Postcard !  R10Cipher is for Individuals. For Businesses. For You. For Me. For Mum and Dad. For Teachers. For Professionals. For Journalists. For Executives. For Everybody.  Because our Privacy and Security have never been more important.

The next thing I needed to do was decide on what encryption technology to use. AES was relatively new at the time and was still looked at suspiciously by many Americans following the whole ‘Clipper Chip‘ incident.  In the end I settled on a UK invented encryption technology called Blowfish.  Blowfish is a keyed symmetric block cipher which was invented by ‘Security Guru’ and renowned author Bruce Schneier in 1993. It provides excellent encryption and will continue to do so for the foreseeable future. Blowfish is free of patents and back doors, and Bruce has placed Blowfish in the public domain.

Version 1 of R10Cipher was released in 2008 and sold only a few dozen copies.  Using the feedback from these early customers Version 2 was released with some significant enhancements including drag and drop batch encryption of files and documents.

When Version 2 was released, Version 1 was featured as a free edition on the DVD Cover Disks for the glossy UK editions of MacFormat and MacWorld magazines, on consecutive months.  Since then I have agreed for it to be distributed on several foreign editions of the magazines.  Hundreds of new users were gained through the distribution of the free edition, and many of those went on to pay for an upgrade to Version 2.

Macworld and MacFormat Magazines featuring R10Cipher 1 on the Cover DVD

Direct Sales of Version 2 were excellent, with good feedback and testimonials. New customers means new ideas and feature requests and so Version 3 was scheduled.

Version 3 released 2nd August 2009 was a major new version that addressed all user requests from Versions 1 and 2. The main advantages of Version 3 were an increase in encryption strength to 384 Bit, an encryption strength indicator and a full Key Management capability which creates an encrypted local database which contains the ‘Shared Secrets’ that you use to communicate with your different contacts.

Interest in Version 3 was phenomenal, it far exceeded my expectations. I had many upgrades from Version 2 to Version 3 and as I offered an upgrade policy even from the free edition, I have had a few upgrade from Version 1 to Version 3 also.

2009 also saw R10Cipher become a Finalist in the UK IT Industry Awards, Technology Excellence / Information Security Product category.  The UK IT Industry Awards are held annually by Computing Magazine and the British Computer Society.

R10Cipher: Finalist UK IT Industry Awards

In April 2010 in conjunction with MacFormat Magazine I offered a free Version 2.5 SE on the DVD Cover Disk with a discounted upgrade to Version 3. This promotion was not as successful as earlier promotions, possibly because 2.5 SE was a ‘designed to be free’ product, rather than an actual previously sold version. In addition Version 3 had at this stage been out for a while.

Version 4 of R10Cipher was released in June 2010, with Version 5 being released in July 2012.

Commercially R10Cipher has been a great success for me with several thousand users and it is a product I am very proud of. Just as importantly, my customers have had immediate and measurable benefits through the use of R10Cipher. Previously they knew they needed something to protect their communication and documents, but they could not find a product that seemed easy and simple enough for them to use.  R10Cipher filled that requirement.

IT Security and Data Protection were and are high on many peoples agendas at the moment, or at least they should be, and yet the majority of people are left exposed because until R10Cipher came along there was not a product simple and easy and complete enough for them to consider using it.

Here are some paragraphs about R10Cipher, back in the day:

R10Cipher is unique in that this is the first cross platform end to end encryption product that real people can and will use for day to day encryption purposes. R10Cipher does not attempt to encrypt a complete volume, R10Cipher does not try and involve the user with complex Public Key encryption, R10Cipher does not need a complicated install, in fact R10Cipher does not need installing at all. R10Cipher concentrates on being the easiest to use and most reliable End to End, Text and File Encryption software.

The lack of an installation makes R10Cipher unique in that you can copy the Windows (XP, Vista and 7), Mac OSX and Linux versions of R10Cipher to a USB drive or external device, along with your documents and carry your data about with you knowing that a) You can access that data on any computer and b) It is secure, so if you lose it or leave it in a taxi then the information is unreadable and no harm is done.

Because of it’s simplicity and ease of use R10Cipher pioneers new ways of working. Backup your important data to the web, iCloud, Dropbox or similar – encrypted by R10Cipher, and retrieve the information later, wherever you happen to be. Your data is secure – secured by you not by your web hosting company. If your hosting company is enforced by law to hand over your information, that information is useless to the recipient unless *you* agree to provide access.

The main innovation of R10Cipher therefore is not in the technology but the way in which the product is designed to be easy and simple to use for everybody – not just IT Professionals.

This brings us nearly up to date.  I should perhaps mention that R10Cipher took a back seat for me, as did my other commercial products, between 2012 and 2016.  This was due to personal and health problems involving, amongst other things, Motorcycles and Air Ambulance Helicopters.

R10Cipher was never forgotten and when the chance came to resurrect it through an acquisition by Area51 Limited I was extremely pleased.  Not only could the product be re-written, updated and enhanced and once again made available, but I would be backed up by others who could step into my shoes and continue development, should the worse ever happen.

2016: Magic Cipher was born.  Press Release

Magic Cipher

Part 2 of this post will detail how Magic Cipher was built, its initial goals as well as the way it will change over time and the additional functionality we will be adding in the near future.  For now, you can obtain a copy of Magic Cipher with a 20% discount using the coupon code: MCBL20 which can be entered at checkout: http://www.magiccipher.com

Contact us for further information:

Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications. Contact Us

The Best SQL Tool for Mac: Updated

oneSql 1.0.1 was released earlier today and I'm very pleased to say that there was not a single bug fix 🙂 Surely a testament to the guys and girls who participated in the Beta program earlier this year. So a very big 'thanks' to them 🙂

This update consists of a change to the way the SQL Keywords mechanism works. Previously the file SQLKeywords.sjc was loaded from the application folder or the SupportFiles folder and all the SQL keywords were loaded into an array and this array was accessed after each keystroke when typing occured in the SQL Text Area. If a match was found then the appropriate action was taken, ie: the word was capitalised, or coloured etc.

In version 1.0.1 the array of SQL keywords is built internally without reference to the SQLKeywords.sjc file. However if this file is present any words within this file are added to the SQL keywords array. So for example any words that you wish to be treated as keywords for your own purposes, or any keywords you find that I have missed when building the keyword array, can be added in a file called SQLKeywords.sjc which needs to be located in the same folder as the oneSql application or in the SupportFiles subfolder.

In addition to the changes described above there are half a dozen small interface tweaks which just tidy things up very slightly.

Easy to Use SQL Tool | oneSql 101: Connections

Visual Guide to oneSql: Part 1

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql oneSql Connection Window   busbanner Affiliate Links

oneSql Database Tool 1.0: Press Release

[prMac.com] Ripley, Derbyshire. United Kingdom – chol.technology are pleased to announce Version 1 of a brand new MySQL, PostgreSQL, MariaDB and SQLite SQL Query and Data Import / Export program for Mac OSX, Windows and Linux. Three Operating Systems, Four Databases and Five Languages Supported including in addition to English; French, Spanish, Italian and German. Clear and unrestrictive Software Licensing, putting customers needs first.

oneSql is a stand alone, lightweight, no install neededSQL Database Tool for OSX, Windows and Linux.

The target audience for oneSql is initially technical people, Database Administrators, Developers, or ‘power users’ who need a simple, efficient, cross platform SQL Tool on their computer, or in the Utilities folder of their portable USB Drive. DBA’s, System Admins, Developers, Accountants – all have a need for oneSql.

These users may currently have a favourite tool for each operating system platform they use. I’d like to supplement or even replace their existing tools with oneSql. I hope to do this by focusing on the features that are most important to them and eliminating those that seek to overcomplicate competing products.

We have also introduced new functionality that will likely interest those same individuals who can now get additional benefits from using oneSql. For example the ability to put the Mac, Windows and Linux versions of oneSql onto a USB Drive and then connect the drive to virtually any computer and load and use oneSql, without installation, is fairly unique and extremely useful.

With the unique ‘User Prompt Fields’ functionality, use within an organisation can extend far beyond the Technical User and to the desktop of the End User. Scripts written by the Technical User can be run as Reports by the End User without modification as each variable, for example Data Start and Date Finish, is prompted for appropriately. The End User needs to know nothing about SQL or the script.

Benefits Include:

  • One SQL Tool for Mac, Windows and Linux
  • One SQL Tool for SQLite, PostgreSQL, MariaDB and MySQL
  • Unlimited Time Limit for the Trial Edition
  • Unrestricted Features for the Trial Edition
  • Small and Lightweight, Approx 20Mb for all Versions
  • Speed with Reliability
  • Scripts Library to Store Your Scripts for Future Use
  • Easy and Simple to Use
  • No Installation Required
  • Save Time with Data Import Templates
  • Saved Connections Stored Safely using Encryption
  • Get Started Quickly with the Examples Database
  • Productivity with User Prompt Fields
  • Increased Database Security
  • Full Manual Included as a PDF
  • Written and Supported in the United Kingdom
  • Simple, Fair and Inexpensive Licensing
  • Zero Effort Corporate Licensing
  • Corporate Licensing Available
  • 50% Discount for Education Establishments and Students
  • 50% Discount for Charities and Non Profits

Features Include:

  • SQLite, MariaDB, PostgreSQL or MySQL
  • Objects Tab – Tables, Views and Columns
  • Fully Customiseable Results Grid
  • Auto Highlighting of SQL Keywords
  • User Editable SQL Keywords List
  • Built in Script Library
  • Example Database Supplied
  • Export Data in Tab Delimited Format
  • Export Data in CSV (Comma) Format
  • Export Data in CSV (Semicolon) Format
  • Export Data in JSON Format
  • Save and Load SQL External Scripts
  • One Click for Record Count, any Table
  • Quick Query One Click to Fetch 20 Records
  • One Click to Fetch All Records
  • Insert a SQL Template
  • SQL History List – Double Click to Recall
  • Window Sizes and Positions Saved on Exit
  • List View Configurations Saved on Exit
  • Option to prefix Columns with Table Name
  • Option to append a Comma to the Columns
  • User Input Prompts
  • Enhanced Connection Encryption Options
  • Parsing of Multiple Statements
  • Sequential Statement Execution
  • Highlighted Statement Execution

Taking Security Seriously:

There are two choices for how encryption is used to secure your database connection information. The first 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 onto a USB Drive, run it from that USB Drive on any Mac, Windows or Linux machine you plug it into.

Licensing:

With the development of oneSql came the development of a new Software Licensing scheme, designed to put customers first and to ensure they we never punish the genuine, fee paying customer for the actions of the software pirate. Our customer friendly, super simple software license is shown below:

‘You can copy and use oneSql on your own personal computers with one instance of oneSql allowed to be in use at any one time. You can put oneSql on a USB device and plug that into anyones computer and use oneSql from the USB device for as long as you need. All Licenses are valid for all supported Operating Systems, all supported Languages and all supported Databases.’

Half price licenses are available to Educational Establishments and Students also Charities and Non Profit Organisations.

Software Referral Scheme:

Also new with oneSql is a Software Referral Scheme. Payment will be made to an existing customer thirty days after a new customer makes a purchase based on an existing customers referral, and quoting the existing customers referral ID within forty eight hours of purchase. The payment amount is ten percent of the new customers spend (before taxes) and the payment will be made via Paypal.

Pricing:

oneSql is available from $30 for the Single User Edition

Availability:

oneSql is available now.

Testimonial:

‘I believe oneSql has found its niche; simple and powerful. Unlike many other SQL Tools oneSql is slim and easy to work with’ – Dennis, Beta Tester

Something Different:

We wanted to do something different to mark the release of oneSql, so we have decided that the first 10 people to purchase any edition of oneSql, with the exception of 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 and 10% cash back after 30 days. We’ll ship these bonus items anywhere in the world.

The first 100 purchasers of oneSql Single User Standard Edition receive 10% cash back after 30 days.

oneSql is dedicated to Alison Fowler RIP. See ‘ya Ali B. We miss you.

onesqlscreenshot1

chol.technology is the trading name for Steven Cholerton. Since the late 1980’s Steven have been heavily involved in Software Development and Information Technology.

He is a Chartered Information Technology Professional, awarded by the British Computer Society, a Fellow of the Institution of Analysts and Programmers, a Certified Ethical Hacker, an Oracle Certified Professional, author of several eBooks and many Commercial Software Products, and a committed and passionate developer of Custom and Bespoke software for Mac, Windows, Linux, iOS and Android.

Steven personally designed and wrote the R10Cipher file encryption software used by Leeds Institute of Molecular Medicine, Cancer Research UK.

###

busbanner

Affiliate Links

Software Licensing and Software Piracy: Part 2

Part One of this article finished with the following question:

What is it fair to expect your customer to do to license their copy of your product, and so help protect your product, your sales, your livelihood and the future investment and development in a product that is important to both you ?

I believe that it is fair to expect the customer to do something to help the software developer protect their product, after all if the developer doesn’t stay in business then the product doesn’t have a future and the customer could be left high and dry.

That’s not to say the customer can be expected to jump through any hoops … the emphasis is on the developer to provide a method of licensing their product that can be done quickly and easily and thus encourage the customer to purchase and use a legitimate copy of the software rather than paying a visit to **insert name of dodgy virus ridden download sites here** or similar.

My opinion is that if I, as a user, purchase a piece of software for my own use, then I should be entitled to copy it onto my PC and my Mac and my Laptop for use whenever I like. I should also be able to copy it onto a USB Drive, connect the drive to a friends computer and use the product there also. I should not however copy the software to my friends computer thereby giving them the ability to use it in my absence. I expect to have to follow a documented procedure to identify to the software that I am the legitimate owner. This should be a simple and one off process.

I believe the previous paragraph is fair to both the customer and the software developer. I believe most people are honest and do not mind paying a reasonable price for a quality product. The software industry has in some ways become its own worse enemy with some companies having complex and unworkable, illogical and unfair licensing practices. ‘We need the customer more than they need us’ is something developers should be bearing in mind.

What prompted me to look into Software Licensing and then to write about it and to ask for feedback from other colleagues, professionals and interested parties, is that I have a new product soon to be released. In my opinion every new product is an opportunity to improve the purchasing and licensing experience for your customer. You only really get the one chance to get it right.

oneSql (www.onesql.uk) runs natively on Windows, Mac and Linux. It supports five languages and four databases. It is a tool that some DBA’s and Developers will want to put on a USB drive and carry around. Does (should?) 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 of Utility software. Utility software which in my humble opinion is the Developers or DBA’s equivalent of the 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.

The Software License I have settled on for oneSql is simple, and is basically per User / Concurrent. It is so simple it is summed up in the following, single, paragraph.

The oneSql Software License

You can copy and use oneSql on your own personal computers with one instance of oneSql allowed to be in use at any one time. You can put oneSql on a USB device and plug that into anyones computer and use oneSql from the USB device for as long as you need. All Licenses are valid for all supported Operating Systems, all supported Languages and all supported Databases.

I am making it easy for the customer to know if they are infringing the spirit of the Software License agreement. I am not stopping them, or even making it particularly difficult for them to disregard the license, but I am asking them for honesty. If that fails then there are several other incentives to help the customer make the right decision …

Active Incentive: Referral Fee
With a referral fee paid to a oneSql customer when they recommend someone else, it is in the customers financial interest to get their friends and associates to purchase a oneSql license.

The following short and simple (can you see a theme here?) paragraph explains.

The oneSql Software Referral Scheme

A payment is made to an existing customer 30 days after a new customer makes a purchase based on an existing customers referral, and quoting the existing customers referral ID within 48 hours of purchase. The payment amount is 10% of the new customers spend (before taxes) and the payment will be made via Paypal.

Passive Incentive 1:
The licensed user name is displayed in the titlebar of the startup window as well as on the main window. Hopefully this is a deterrent as the original purchaser does not want their name showing up elsewhere and the user doesn’t want to see someone elses name where theirs should be.

Passive Incentive 2:
oneSql is fairly priced. That’s self explanatory. Customers do not want to feel they are being ‘ripped off’ or being taken advantage of.

Passive Incentive 3:
Offer a choice of license types and schemes that not only give the user choice, but also offer additional discounts for worthy establishments, education and charities for example.

The different types of software license that are necessary in order to give the customer the choice they require, can also bring additional and unwanted complexity. In order to also give the customer the licensing choice as well as the simplicity they desire the additional license types are all costed at N * x. N is the Single User Standard Price, here shown as $30 and x is the multiplier. An example is shown below:

onesqlpricinggrid

Trial Mode

The above incentives are for a potential customer who has obtained an illegitimate license from somewhere and I am trying to attract them into the fold. What about a customer who has downloaded a Trial Edition of the software ? For them we have to give them the chance to see the full capabilities of the software, while also convincing them to reach for their wallet. Trial Mode restrictions can make or break a product. For oneSql I have implemented the following:

  • Restricted the Saved Connections to Four
  • Generated a Nag Message after Every Query

Note that I have not restricted the Trial to 30 days or similar, nor have I restricted the functionality in any way. The potential customer can still see and access the full capabilities of the product, I have just made it a little bit less convenient than if they had purchased a licence.

In order for the Trial Mode to be successful for you and the potential customer it is necessary to again pay attention to the overall customer experience.

For oneSql I supply a configured sample database so that the user can experiment with the product immediately. I also supply a full, quality manual. Something missing in the vast majority of software products available today. Will every customer read it ? No. Will a high percentage of customers notice if it’s not there? Probably. The customers experience is what will get you a sale,  or not. I believe that is how it should be.

Part Three of this document discusses some of the technical methods, issues and problems involved with Software Licensing.

busbanner

Affiliate Links

oneSql New Beta Goes Italian

onesqlitalian

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.

Affiliate Links

oneSql: New Beta Available

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.

imp1

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.

imp2

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.

madewithxojo

If you are interested in becoming a Beta Tester for oneSql, please click here: http://bit.ly/1lq3kk8

oneSQL Legend

 

 

Blogfooter

 Affiliate Links

oneSql: Multi Language Support

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.

www.stevencholerton.com

Blogfooter

Products and Affiliate Links

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

oneSQL Now Available

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 ?

  • One SQL Query Tool for Mac OSX, Windows or Linux
  • One SQL Query Tool for both SQLite and MySQL
  • No Installation Required
  • Very Lightweight, Approx 6Mb
  • Simple, Fair and Inexpensive Licensing
  • Easy and Simple to Use
  • Written and Supported in the United Kingdom

Some More Benefits

  • Shows All Database Objects, Tables, View and Columns Etc.
  • Drag and Drop Database objects into the SQL
  • Double Click Database objects to Copy to Clipboard
  • Customised Results Grid, Font, Size, Stripe, Divider Etc.
  • Dynamic SQL Keyword Highlighting
  • User Definable Keywords List
  • Each Select Reporty the Time Taken
  • Export Results Data in Tab Delimited, CSV or JSON Formats
  • Save and Load SQL Scripts
  • One Click for Record Count, any Table
  • One Click to Fetch 20 Records for Quick Query
  • One Click to Fetch All Records
  • Insert a SQL Template
  • Reactive Results List – Auto ‘Fit to Grid’ or ‘Show Horizontal Scrollbar’
  • SQL History List – Double Click to Recall
  • Windows Sizes and Positions Saved on Exit
  • List View Configurations Saved on Exit

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.

oneSQL Legend oneSQLoneSQL3

blog_footer.png

Products and Affiliate Links

 

 

DataViewer [Update] 1802

This latest update to the DataViewer components for Xojo and REALStudio contains the following enhancement:

  • The Database Objects Viewer window has been redesigned.

DV DBObjects 121

blog_footer.png

Products and Affiliate Links

DataViewer [Update] 2101

Another couple of additional features added to the DataViewer Components for Xojo and REALStudio:

  • Reactive Results – Auto ‘Fit to Grid’ or ‘Show Scrollbar’
  • Results List now inside inside a Tab Control: For Future Use

Download:

http://bit.ly/KR2ePp

DataViewer by Steven Cholerton

 

blog_footer.png

Products
Affiliate Links

Free: macsFileMover

This is the second of my products that I have decided to release , free of charge for personal, non-commercial use. This is a  small utility product for Mac OSX and Windows.

If you find my software useful and you feel you’d like to help with my personal quest for a USA PRS Guitar then feel free to make a donation via Paypal. My address is scholerton@gmail.com 🙂

Click Here for Further Information …

Product: macsFileMover
Purpose: Automated File Moving and Copying
Platform: Windows and Mac OSX
Size: 5Mb
Copyright: Steven John Cholerton
Download: http://bit.ly/1eFuO0w
YouTube: http://youtu.be/Pi_kL7j-Yto

License:

Supplied Free Of Charge for Non Commercial Use Only
Businesses and Other Organisations Contact Us:

license@zombielabs.net

Summary

macsFileMover allows you to setup multiple file Source and Destinations and at a user determined interval the contents of the SOURCE folder will be COPIED or MOVED to the DESTINATION.

That is pretty much all it does.  Where it excels is when used on servers particularly when regular archiving of logs etc. is required. Once setup the Source and Destinations can be saved to a preferences file and then reloaded when you next use the software.

macsFileMover

blog_footer.png

Products
Affiliate Links