How to easily test SQL Codes online and share them with others ?

I am looking for some online service like - SQL Fiddle - http://sqlfiddle.com but with better features. SQL Fiddle limits the database size to a small sample and does not have any proper user features to manage the fiddles systematically "like having a method of proper tags or comments about each fiddle etc."

It should allow me to quickly create a demo database online and then experiment with various queries on it. I did some searching online and found that there are quite a lot of such services available, like -

http://www.hongkiat.com/blog/tools-to-coding-online/
http://techslides.com/30-code-playgrounds-and-sharing-tools

But it is not possible for me to manually tryout all of them. So I was looking for some tried and tested solution, which is already being used by a lot of users here.

Please suggest the best options in this regards, from your own experience.

Thanks a lot
happy 1001Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark BullockQA EngineerCommented:
If you want to experiment with queries just for yourself, you can install
- MySQL on your Windows/Mac/Linux PC
- SQL Server Express Edition on your Windows PC
happy 1001Author Commented:
@ Mark Bullock
If you want to experiment with queries just for yourself, you can install
- MySQL on your Windows/Mac/Linux PC
- SQL Server Express Edition on your Windows PC

Thanks for your comment Mark.
I would like to clarify that I am not looking for doing it on my PC. I am looking for some online method for doing such testing and I should be able to share that test /demo database and query with others easily. Please have a look at SQL Fiddle to understand the main concept behind it.

Thanks
PortletPaulEE Topic AdvisorCommented:
I would enjoy finding a good alternative to SQLfiddle but have not found one yet, and I have looked more than once.  SQLfiddle is deliberately limited in size, and that can be frustrating, but a free service cannot afford to give you massive dbms size.

The vast majority of those "playpen" environments like JSfiddle, CodePen etc  do not give access to a dbms at all, and if they do they probably allow just one dbms type (such as MySQL) and also in a very limited way.

Here is an example (SQLite)
http://www.tutorialspoint.com/execute_sql_online.php
note that one (of many) limitations here seems to be that you don't get a dedicated URL (which you do get at SQLfiddle)


There is also an Oracle console at the same site, but don't ask me how it is useful, as it does not seem to do much.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Need More Insight Into What’s Killing Your Network

Flow data analysis from SolarWinds NetFlow Traffic Analyzer (NTA), along with Network Performance Monitor (NPM), can give you deeper visibility into your network’s traffic.

happy 1001Author Commented:
Thanks for your reply Paul. I agree completely. SQLfiddle is definitely good, but the size limit is causing lot of trouble for me. That's why I was thinking if I could find a better alternative with better features.

Hopefully, someone might be knowing about such an alternative, if that exists !

Thanks and regards
Vitor MontalvãoMSSQL Senior EngineerCommented:
happy 1001, do you still need help with this question?
happy 1001Author Commented:
Yes Victor.
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think that something better than SQLFiddle exists.
I usually creates a VM and install MSSQL Developer edition and use AdventureWorks as demo database since it has plenty of tables with a good number of records. I know, is not online but it's somehow quick to set lab environments like this.
PortletPaulEE Topic AdvisorCommented:
Old questions rarely attract new answers either.

I have been involved in this for some time now, and can lay claim to having "introduced" use of sqlfiddle into EE, and as I stated before I have looked for alternatives. I just do not believe that right now a better alternative exists.
happy 1001Author Commented:
Thanks again Paul. Yes, I too got introduced to SqlFiddle by looking at your posts only :)

Thanks Victor
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.