Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there any 'web-based' sql test environment?

Tags:

sql

database

In HTML+CSS+JS world, http://jsfiddle.net/ is very helpful tool for asking / making example about web development. And I also saw several browser(javascript)-based programming language compilers and REPLs. But I can't find online / web-based test environment for database operations( especially for RDBMS ).

Is there any open/free database service with web-based interfaces for testing queries?


Added: This tool will be good for this situation; If I'm troubling with complex queries, then create a sample table via web interface and ask it on stackoverflow with the 'sample table URL'. Anyone can access to the URL and test their queries on web site. (Yes, queries are running on 'real' database system) And also the query results can be tracked, then we can even make 'ranking' for it :)

like image 463
lqez Avatar asked Jan 09 '12 22:01

lqez


2 Answers

Try SQL Fiddle.

You can try your SQL query and execute/test it.

like image 105
user1409437 Avatar answered Sep 23 '22 15:09

user1409437


There are free "disposable" database servers like db4free and even MonoQL.

As far as the web-based interfaces and short URLs go, I don't think you'll have much luck.

To manage your data you have to stick to what is provided (usually phpMyAdmin or similar) and there is no short-URL to query mapping. One other caveat of such system is that (without the appropriate user permissions) one user could easily destroy all your test data -- and remember that (relational) database versioning is much more expensive than plain text versioning, so that's pretty much out of the question.

For non-RDBMS, I can think of try.mongodb.org -- but it suffers from the same problems.

Almost forgot, the Stack Exchange Data Explorer, lets you practice T-SQL queries (with permalinks).


PS: As a personal side-note, I think it's a cool idea and I would love to see something like that implemented, perhaps even mashed-up with SchemaBank or similar - that would be just awesome.

like image 36
Alix Axel Avatar answered Sep 25 '22 15:09

Alix Axel