0

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?

Alessandro
  • 11
  • 4
  • Are you talking about the web site http://sqlfiddle.com/? – The Impaler Oct 05 '20 at 11:53
  • While this is no particular training tool and does not give you an already filled database for testing, you could use XAMPP or LAMP to locally host a database server and then for instance use the Webserver to include and use a tool like phpmyadmin. – andrbrue Oct 05 '20 at 11:53
  • 2
    Best install mysql locally - I have experienced some odd behaviours in sqlfiddle and alternatives eg db-fiddle, and the fiddles won't necssarily exactly match your production environment (version) anyway. – P.Salmon Oct 05 '20 at 11:53
  • 1
    The various database fiddles are all labors of love by their creators. Having a beefy enough infrastructure to handle all sorts of different dbms server makes and versions is expensive, and the operators of those fiddles pay for it themselves.. You could consider donating. – O. Jones Oct 05 '20 at 11:58
  • @TheImpaler Yes, Sorry if I didn't specify it – Alessandro Oct 05 '20 at 13:59

1 Answers1

0

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.

O. Jones
  • 103,626
  • 17
  • 118
  • 172
  • Thanks for your help, I've already installed MAMP to practice with PHP, and there I saw phpmyadmin that I used fo some wordpress project in local. I tried to create a new database and it work perfectly for my didactics purposes, I can wrote code and do query. – Alessandro Oct 05 '20 at 14:08