blackdogCRM: New Movie

bdBanner

This new movie available to view below, or via my YouTube account, shows you just how simple it is to upgrade from a single user edition of blackdogCRM to a multi-user MySQL Server edition using our upgrade tool. A four step process that does all the heavy lifting including populating the server database with all the data from the existing single user SQLite database.

Blogfooter

 Affiliate Links

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 (8?) 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

 

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