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
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.
Dedication: oneSql is dedicated to Alison Fowler. RIP.