SQL Fiddle is a new tool that allows you to experiment with SQL queries without even having a dbms.
Following the footsteps of the online web editor jsFiddle, SQL Fiddle is a web based tool where you create a database by utilizing your schema and choosing an underlying engine amongst MySQL, PostgreSQL, MS SQL Server, Oracle, and SQLite; and then run queries against it.
(Click to enlarge)
As it is web-based, you don’t need to install a dbms, and it also has the advantage of allowing you to compare the syntax of a variety of SQL flavours (although all products follow the standards there are differences in the implementation as well as proprietary features) inherent in these diverse dbms. It enables you to engage with functionality that might exist in one but not in another, so serving as a "product shootout", as well as letting you look at how your query is going to be executed by observing the query execution plans it provides.
This also helps with optimizing and comparing queries. In addition, you can post a link to your fiddle to forums like Stackoverflow when looking for help.
The past month has seen an explosion in the use of the term "bot". Simply using the word imbues almost magical qualities in apps that would otherwise seem mundane. So what should we expect from the ne [ ... ]
A new CodinGame Contest opens on Saturday April 30th. The aim of Smash The Code is to program an autonomous bot and send it fight other players' bots. Another aim for many contestants is to be no [ ... ]