This latest update to the DataViewer components for Xojoand 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.
I’m gradually starting to build up the XojoBuildingBlocks resources. Suggestions, links and advice all gratefully received. So far I have built the outlines, with minimal content, for the following pages;
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 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.
In my ongoing quest to reinvent myself this year I’ve been sorting out my Software Products and archiving Source Code, Documentation, Images, Demo Movies etc. The image below is most of the software products I have written since 2009, mostly in Xojo / Realstudio, some in VB.Net, C#.Net and a couple in CoronaSDK.
I would never have guessed there would be quite so many 🙂
I’m currently changing direction with my business and moving into some different, but clearly defined areas – all will be revealed soon – although I think some of my plans have already been ‘leaked’ due to my excitement about the future and my inability to keep quiet 🙂
In fact here I go again – these are some products and areas that I will be involved with in 2014 and beyond: