While I was performing my usual duties on the forums, I received a response regarding one of the examples that I had used for an answer (I love providing examples). But the tool in question was SQLFiddle, which is an online tool that allows you to create databases and perform queries within the confines of a browser to share with others. The user was overjoyed at discovering the tool and several other users also chimed in, so I thought I would go over a few of the tools that I find myself commonly using to assist others online.
You can find some of JSFiddle’s major features listed below:
- Account creation to monitor, save and share your existing Fiddles
- An extensive collection of available frameworks and extensions, which can easily be integrated
- Naming, Descriptions and other options for individual Fiddles
- Ajax Request Simulation in multiple flavors (such as JSON, JSONP, HTML and XML)
- TidyUp and JSHint integration to keep your code clean
JSFiddle is still in the alpha stage of development, where it has been for quite some time, but I think everyone that has used it can safely agree that beta and beyond should be exciting.
JSBin is another alternative to JSFiddle that I surprisingly discovered while JSFiddle was performing a major update to their site, but that maintenance actually worked against JSFiddle. Ever since I began to use JSBin, I have found it quite difficult to part from it. I think that it provides a more bare-bones approach as opposed to JSFiddle and allows you to throw together an example much quicker in slightly simpler interface.
Much like its competitor, JSBin also features a majority of the components that assisted in making JSFiddle as successful as it is:
- User accounts to create and manage your JSBin examples.
- Autosaving and autorunning for your examples, which can make development much quicker.
Overall, JSBin and JSFiddle are very similar and it is ultimately up to personal preference for which one you choose to use, but I highly recommend both of them for throwing together quick examples, proof of concepts and helping troubleshoot issues.
It has full support for a huge range of different browsers, resolutions, environments and also allow you to even run code from your local machine through one of the virtual servers. You can see some of the major features below:
- A huge assortment of environments are supported (both desktop and mobile)!
- Operating System support includes Windows XP, Windows 7, Windows 8, OSX Snow Leopard, OSX Lion, OSX Mountain Lion and Mobile support for OSX Safari, Mobile Android and Mobile Opera.
- Unparalleled Browser support options
Your Browser’s Developer Tools (F12)
Tools for Server-Side Languages and SQL
Compilr is a cloud-based development tool that allows you to create, compile, debug, run and share applications in a wide assortment of languages and environments all from the comfort of your browser. After creating an account and logging in, it takes just a matter of seconds to actually get started in the language of your choice.
Some of the features that are included:
- A flexible, easy-to-use interface that allows you to throw together examples and actual projects all within the comfort of your browser
- Support for creating both public and private projects to easily share your projects with others
Compilr is still fairly young and is still continuing to grow but has proven that it can be an incredibly useful tool, especially if you aren’t around a development environment and want to try something out in one of your favorite languages.
SQLFiddle functions as a JSFiddle or JSBin but for the SQL world. It allows you to easily throw together and share examples using actual SQL to troubleshoot issues, compare and contrast how queries react in different environments and basically tinker with nearly anything SQL-related all from within your browser. SQLFiddle features a very simple three pane system (one for schema, one for your query and one for your output) to allow you to get things up and running very quickly (especially if you are helping a user that is kind enough to provide some sample table data).
Major features include:
- Account creation to save and manage your fiddles along with a very easy system to share them with others
- Simple table creation and querying using an intuitive interface
- Examples to help you get started working with the environment
- Support for a variety of SQL-oriented environments such as MySQL, Oracle, PostgreSQL, SQLite and Microsoft SQL Server
SQLFiddle is honestly a great tool for debunking random SQL issues that a user may be encountering or if you just want to throw together a very basic proof-of-concept for an upcoming project and aren’t around a full database environment. I’d highly recommend giving it a try if you know your way around SQL.
These were just a few of the tools that I find myself using often when answering questions online and even throwing together simple mock-ups for solving real-world problems of my own prior to implementing them within projects. If you have any other recommendations, please feel free to leave a comment below as I am (and I am sure everyone else is) always looking for tools to make their lives easier.
Filed under: CodeProject