Why SQL Fiddle doesn't work during "Building schema" and "Run SQL" functions?

1.9k views Asked by At

I'm practicing learning MySQL code with SQL Fiddle, it worked sometimes but now I get errors all the time when I use the "Build schema" or "Run SQL" functions. After a while, the error printed is "Unable to get host connection: Connections could not be acquired from the underlying database!"

Anyone know how to solve the problem? Is there another tool I can use to do practice with queries to my schema?

1

There are 1 answers

1
O. Jones On

Install your MariaDB or MySQL database server on your local machine. Install a decent native SQL client program. HeidiSQL is great on Windows. There are plenty for Mac. Any modern laptop computer (since about 2014) can handle a student- or developer- scale database server and client without breaking a sweat.

You can install phpmyadmin. But that's a php web app, so you also have to install a web server and php to get it working. Hence the suggestions for XAMPP or LAMP stack packages. I prefer the native clients; less to go wrong; less stuff in your laptop.

It's best to reserve the database fiddles for sharing SQL demos with other people. Like for Stack Overflow posts.