DataViewer Components for Xojo

Here’s a chance to get my Dataviewer Components for Xojo at a 20% Discount:

All Xojo Add-ons and Videos are 20% off through July 16th! Use coupon code SPASH and expand your toolbox now: http://bit.ly/2bAciyX #sale

Click here for more information on DataViewer

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 Me

oneSql Multi Database Tool: Final Beta

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:

onesqlcoverimages

Note that for this final Beta you should delete both your Settings and your Preferences file as there have been changes involving encryption.

For information on Software Licensing for oneSql, have a look at my recent blog posts on this subject, here and here.

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.

busbanner

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

 

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.

DataViewer 1.3.0 [Update]

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

  • List View Configurations Saved on Exit
  • DB Objects Now Available from the Tab Area
  • Database Objects List, Now Double Click to Insert
  • Option to prefix Columns with Table Name
  • Option to append a Comma to the Column Names
  • User Input Prompts [[T-xxxxx]]
  • DML now Supported as well as Queries
  • Parsing of Multiple Statements with Sequential Execution
  • Multiple Small Bug Fixes

DataViewer is a small collection of components that allow a Xojo or RealStudio Developer to put a full featured SQL Query and DML tool into their own applications for a one time payment. There are no restrictions on use. The images below are from the latest version.

Click here to download the Demonstration App for Mac, Windows and Linux.

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] 2301

This latest update to the DataViewer components for Xojo and REALStudio contain the following enhancements, in addition to a few bug fixes:

The size and position of the windows are saved and recalled next time the windows are opened. In addition the Results List and History List visual configurations are saved and also automatically recalled next time.  This includes the Font and Font Size, the Line Type (None, Dotted or Full) and the Background Colour of the Alternating Rows (if used).

Also new is the SQL History List. Every statement and the results are recorded in this list for the duration of the session. To execute a particular statement again, double click the appropriate History List row.

History is not saved between sessions, although this would be trivial to do. If there is any demand for this feature I will add it in a future update.

I hope these enhancements are in keeping with the direction you’d like to see these components evolve. Please get in touch with your feedback and requests.

steve@zombielabs.net

DataViewer

DataViewer

blog_footer.png

Products
Affiliate Links

DataViewer [Update] 1701

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

An additional Menu Option which will fetch all Rows and all Columns for the currently selected Table.

An additional Menu Option which will create a SQL Statement ‘Template’ for the currently selected Table, see the example shown below:

DataViewer

The updated libraries are available for download now.

blog_footer.png

Products
Affiliate Links

jSql: Final Beta

jSql is a MySQL and SQLite Query Tool for Windows and Mac OSX.

jSql is built using REALStudio / Xojo and the DataViewer Components.

jSql is Small, Simple, Fast and Cross Platform for a seamless experience whether using Mac or Windows as your platform of choice.

Final Beta was sent out to ‘Early Adopter’ Customers today and depending on feedback from them, the final release will almost certainly be early next week.

At this moment in time I am still unsure regarding pricing. How much to charge – or should I give it away – using it as an example of what can easily be achieved using the DataViewer components. Maybe add a load more features and benefits and release a chargeable Pro version later ?

Here’s a couple of screenshots to be going on with 🙂

jSql by Steven Cholerton

jSql by Steven Cholerton

Any comments or feedback:  scholerton@gmail.com