Fork us on GitHub

SQL Demo Revisited

Bringing the SQL demo to the appstores
Post Image

SQL Demo Revisited

The SQL demo has been on my "todo" list for months. It’s really hard to create a compelling demo for something as boring (by design) as SQL so this was a big procrastination target. After we built the SQL explorer tool for the developer guide it became apparent to me that this could be the basis for the new SQL demo, just provide the ability to type in arbitrary SQL and see it work…​

However, this doesn’t provide enough as beginners might not grasp the full scope of the capabilities, so to make this interesting we added a special tutorial mode that just shows you the queries you can execute. I initially wanted to do something more elaborate like a walkthru tutorial but time constraints blocked that option.

You’ll notice that I’m not embedding the JavaScript version of the demo into this post although you can see it from the demo page. The reason for that is unique.

Browsers don’t support SQL, there was an attempt at getting a standard out but it didn’t last and all vendors deprecated their respective SQL support although some still kept it (notably Chrome & Safari). So the demo works well on Chrome & Safari but not on Firefox (no idea about IE/Edge). There are also a couple of bugs in the SQL support in the JavaScript port making the situation slightly worse.

One of the things we were able to achieve is to make the demo submittable to app stores and as a result it’s already on Google Play, Microsoft Store and on itunes.

Check out the full source code in the github repository for the project.

Share this Post:

Posted by Shai Almog

Shai is the co-founder of Codename One. He's been a professional programmer for over 25 years. During that time he has worked with dozens of companies including Sun Microsystems.
For more follow Shai on Twitter & github.