DataViewer in the Xojo Store

I got notice yesterday that my DataViewer components for Xojo and REALStudio Developers are now available to purchase online from the Xojo store. Check it out :-)

https://www.xojo.com/store/#addons

icon_dataviewer

 

Blogfooter

 Affiliate Links

 

Certified Ethical Hacker: C|EH

I am a Certified Ethical Hacker. I have been for many (12 ?) years. Hacker in the correct and original usage of the word not the mainstream or Hollywood interpretation. A CEH is trained to harden computers, systems and networks learning the techniques of the ‘Cracker’ or ‘Black Hat Hacker’ in order to protect against them. Similar in fact to the idea behind using a thief to catch a thief.

It is often hard enough educating the general public to understand that a Hacker can be, and often is, the ‘Good Guy’, without images such as this one appearing very prominently recently. Ethical Hackers DEFEND, not ATTACK. Therefore the message ‘Don’t Mess With Me’ is entirely inappropriate.

bewareceh2

Maybe you think I am over-reacting ?  It’s a difficult and complex (and expensive) subject in which to achieve any level of mastery, and to become Certified is not trivial. To me a statement like this undermines the very real value of the C|EH and other Security Experts.

Stepping off my Soapbox now. Rant over :-)

Blogfooter

 Affiliate Links

 

Android UK LinkedIn Group: Top Contributor

I get around a bit it seems, that’s three groups so far this year in which I’ve been Top Contributor :-)

androiduktopcontrib


Blogfooter

 Affiliate Links

 

The oneSql Story: [1] Prologue

Prologue

icon_onesql_sml

To understand oneSql it is necessary to first be introduced to DataViewer. DataViewer is a small collection of software objects available for Xojo and RealStudio Developers to purchase and use within their own programs. DataViewer is a self contained window which can connect to any MySQL or SQLite database and perform SQL Queries and execute SQL commands against that database. Lots of features are supported including Export in several formats. DataViewer works on Mac OSX, Microsoft Windows and Linux.

Initially oneSql was created as a demonstration of what could be created using the DataViewer components. This is still the case and all the main functionality from oneSql will make it into the DataViewer component, and vice versa.

In addition however I’ve decided to make oneSql a Stand Alone, LightWeight, No Install Needed – SQL Database Tool for OSX, Windows and Linux – and possibly iOS and Android.

oneSql currently supports MySQL and SQLite. I intend to add support for PostgreSQL, Oracle and ODBC in future releases.

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

These users probably currently have a favourite tool for each operating system platform they use. I’d like to 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 the typical SQL product.

I also hope to introduce new functionality that will interest those same individuals who can 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.

Multi Language Support – English / Spanish / French and German, will all be featured in the initial Version 1.0 release. This will be the first time I have designed and written software from scratch to incorporate multiple language support.

Some of the Key Features and Benefits of oneSql available in the initial 1.0 Release are noted below:

  • Support for English / American / French / German / Italian and Spanish Languages
  • Native Support for Windows, Mac OSX and Linux
  • Support for SQLite and MySQL Databases
  • Simple, Fair and Inexpensive Licensing
  • Corporate Site Licensing Options
  • Half Price Licensing Option for Education and Non Profits
  • Simple, Easy to Use Design
  • High Quality of Software Engineering
  • Consistent use of Fonts and Icons
  • Small Size (14Mb) with No Installation Required
  • User Configurable User Interface Elements
  • Results Grid Customisation, Font Size, Stripe, Separator
  • Maintain a Session Connection Log
  • Maintain a Session History of SQL Statements
  • Double Click to Recall from SQL History
  • Option to Maintain a Permanent SQL History Log
  • Maintain a Database of Connections with Descriptions
  • SQL Syntax Highlighting (Caps, Bold and Colour)
  • User Editable Keyword List
  • Each Statement Execution Timed in Seconds / Microseconds
  • DB Objects Window to Choose Tables, Views and Columns
  • Data Export Facility, CSV (,), CSV(;), Tab Delimited and JSON
  • Save and Load External SQL Scripts
  • One Click Record Count – Any Table
  • One Click Fetch 20 Records – Any Table
  • One Click Fetch All Records – Any Table
  • Insert a SQL Query Template
  • Option to Automatically Prefix Columns with Table Name
  • Option to Automatically Append a Comma to the Column Names
  • Window Sizes and Positions Saved on Exit
  • User Interface Customisations Saved on Exit
  • Multiple Statements Parsed and Executed Sequentially
  • Unique ‘User Prompts’ Facility
  • A Social Menu, Easily Connecting You to Me
  • One Click Email Support

Some of the Features and Benefits I envisage for future editions of oneSql are noted below:

  • Information Cleansing and Conversion Scripts
  • Command Line Scripted Access
  • Piped Output Options
  • Add Support for PostGres
  • Add Support for Oracle
  • Add Support for ODBC
  • Test Support for MariaDB
  • Option to Publish the Results as HTML, to a Web Server
  • Access Privileges and Restrictions
  • Autocomplete for SQL Keywords
  • Online Manual
  • Store Scripts in the Settings Database
  • Option to Attach a Script to a Specific Connection
  • iOS and Android Versions

Summary

At the time of writing oneSql is just a few weeks from Version 1.0 Release.  Release will be via my website initially (www.stevencholerton.com) followed by the Apple Mac Store.

It’s interesting to me that my idea to release this product was met by a lot of anger and derision by someone who helps develop a product with which oneSql potentially competes.

At the end of the day the SQL Tool market is fragmented, and without any clear market leader there are opportunities for all.  As a recently passed friend of mine was fond of saying, ‘Even a Mouse can look at the Queen !’ Live and Let Live I reckon, there are enough wars in the world without starting any more, and let’s just agree to let our products do the talking.

oneSQL Legend

 

Steven Cholerton
April 2014

Dedication: oneSql is dedicated to Alison Fowler. RIP.

 

Blogfooter

 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.

Heartbleed: This Could Hurt

Heartbleed is the name given to the recently confirmed bug found in the OpenSSL Cryptographic Software Library. This vulnerability affects SSL/TLS encryption which is used to obtain a ‘Private’ connection between your computer and a server located elsewhere on the Internet.

heartbleed

This is a serious vulnerability and you are more than likely to be affected either directly or indirectly.  For further information go to this site: heartbleed.com

 

Blogfooter

 Products and Affiliate Links

 

Funniest Review Ever :-)

THIS IS AN ACTUAL CUSTOMER REVIEW FROM A MAN ON AMAZON.CO.UK AFTER USING VEET HAIR REMOVAL CREAM FOR MEN ...

After having been told my danglies looked like an elderly Rastafarian I decided to take the plunge and buy some of this as previous shaving attempts had only been mildly successful and I nearly put my back out trying to reach the more difficult bits. Being a bit of a romantic I thought I would do the deed on the missus's birthday as a bit if a treat.

I ordered it well in advance and working in the North Sea I considered myself a bit above some of the characters writing the previous reviews and wrote them off as soft office types...Oh my fellow sufferers how wrong I was. I waited until the other half was tucked up in bed and after giving some vague hints about a special surprise I went down to the bathroom. Initially all went well and I applied the gel and stood waiting for something to happen. I didn’t have long to wait.

At first there was a gentle warmth which in a matter of seconds was replaced by an intense burning and a feeling I can only describe as like being given a barbed wire wedgie by two people intent on hitting the ceiling with my head. Religion hadn't featured much in my life until that night but I suddenly became willing to convert to any religion to stop the violent burning around the turd tunnel and what seemed like the the destruction of the meat and two veg. Struggling not to bite through my bottom lip I tried to wash the gel off in the sink and only succeeded in blocking the plughole with a mat of hair.

Through the haze of tears I struggled out of the bathroom across the hall into the kitchen, by this time walking was not really possible and I crawled the final yard to the fridge in the hope of some form of cold relief. I yanked the freezer drawer out and found a tub of ice cream, toe the lid off and positioned it under me. The relief was fantastic but only temporary as it melted fairly quickly and the fiery stabbing returned. Due to the shape of the ice cream tub I hadn’t managed to give the starfish any treatment and I groped around in the draw for something else as I was sure my vision was going to fail fairly soon.

I grabbed a bag of what I later found out was frozen sprouts and tore it open trying to be quiet as I did so. I took a handful of them and an tried in vain to clench some between the cheeks of my arse. This was not doing the trick as some of the gel had found its way up the chutney channel and it felt like the space shuttle was running its engines behind me.

This was probably and hopefully the only time in my life I was going to wish there was a gay snowman in the kitchen which should give you some idea of the depths I was willing to sink to in order to ease the pain. The only solution my pain crazed mind could come up with was to gently ease one of the sprouts where no veg had gone before.

Unfortunately, alerted by the strange grunts coming from the kitchen the other half chose that moment to come and investigate and was greeted by the sight of me, arse in the air, strawberry ice cream dripping from my bell end pushing a sprout up my arse while muttering “ooooohhh that feels good” Understandably this was a shock to her and she let out a scream and as I hadn’t heard her come in it caused an involuntary spasm of shock in myself which resulted in the sprout being ejected at quite some speed in her direction.

I can understand that having a sprout fired against your leg at 11 at night in the kitchen probably wasn’t the special surprise she was expecting and having to explain to the kids the next day what the strange hollow in the ice cream was didn’t improve my status…so to sum it up, VEET removes hair, dignity and self-respect ~ Cerys