SQL web interface for your own data?

#1

Post by bkj123 » Thu, Jul 30, 2015, 4:25 PM UTC

I'm writing a SQL tutorial for a bunch of marketing friends. I'd like for them to code as they go.

They've told me that I'll lose them if I ask them to set up SQLite, MySQL, etc. on their laptops. So, I’d like to use a web-based interactive console like that on W3schools (http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all) with my own data. Basically load up some tables and point the users to the interface. Is anyone aware of this functionality or how to roll our own?

Thank you.

Re: SQL web interface for your own data?

#2

Post by wyldfire » Thu, Jul 30, 2015, 4:31 PM UTC

deprecated-but-supported-for-now feature in browsers might be adequate? http://www.html5rocks.com/en/tutorials/webdatabase/todo/

Re: SQL web interface for your own data?

#3

Post by bkj123 » Thu, Jul 30, 2015, 5:33 PM UTC

wyldfire wrote: post #2

deprecated-but-supported-for-now feature in browsers might be adequate? http://www.html5rocks.com/en/tutorials/webdatabase/todo/

Thank you. very interesting. Helped me find other Google queries including SQLFiddle.

Re: SQL web interface for your own data?

#4

Post by jrpt » Fri, Jul 31, 2015, 4:21 AM UTC

Honestly I'd just push back and have them set up MySQL, assuming they have Macs. It's pretty simple to install. If Windows, IDK if it's easy or hard.

Or you could try using a CSV plus textql

https://github.com/dinedal/textql