Nowadays I am trying to answer questions about SQL, PL/SQL and Oracle on StackOverflow . You can see my profile card below :
Recently I am seeing a new web site link in answers, while I am navigating through as much questions as possible. That site called SQLFiddle where you can create an online database and try your codes.
As you can see above it is pretty simple, and it is really easy to use. There is different products and different versions for some products you can choose between. While I am writing this post, exact list was like below:
- MySQL 5.5.30
- MySQL 5.6.6 m9
- MySQL 5.1.61
- Oracle 11gR2
- PostgreSQL 9.1.8
- PostgreSQL 9.2.1
- PostgreSQL 8.4.12
- PostgreSQL 8.3.20
- SQLite (WebSQL)
- SQLite (SQL.js)
- MS SQL Server 2008
- MS SQL Server 2012
Jake Feasel, creator of SQLFiddle, explains why he built the site as :
How to use
So let’s talk about how to use SQLFiddle,
First of all, you select the product you want to use from combo box on top-left corner, next to site logo. Then you should create your schema, in left editor you can create tables and insert data to your tables. When you are done with coding click Build Schema button to run your code. Now you have your tables and data. You can write your queries in the right editor and run them. Results will appear below editors.
There is a limitation with MySQL, that Jake Feasel explains in About page. On the right editor you can only use select if you are using MySQL, with other products feel free to use all DML operations.
There are around 12 different log-in options like G+ and OpenID. When you login to site, you can see your Fiddle history, and your favorite fiddles. There is no other advantages of logging in yet.
That’s all for today. Do not hesitate to comment.
P.S. I am preparing new ODI post but I am really busy with my work these days. So follow my blog for updates.