Settings

Theme

SQL web interface for your own data?

3 points by bkj123 10 years ago · 3 comments · 1 min read


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.

jrpt 10 years ago

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

wyldfire 10 years ago

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

  • bkj123OP 10 years ago

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

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection