Is there a console or a a place on the coding playground you can practice your SQL.

Question

from sololearn

Answer 1

Nope.

Answer 2

There is one here, though http://www.dofactory.com/sql/sandbox

Answer 3

And another: https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in

Answer 4

Also this one https://hexdocs.pm/ecto/Ecto.Adapters.SQL.Sandbox.html ;)

Answer 5

SQL is a database that uses code, you HAVE to have a code attached.

Answer 6

Another one here: http://sqlfiddle.com

Answer 7

I suppose you could set something up to connect to an SQL database with C# or JavaScript etc, but that solution would likely require significant maintainance and effort to make it usefully available to the community. Short answer no.

Answer 8

@Pegasus I think you mean SQL is a query language that utilises existing data.

Answer 9

@Pegasus you can manipulate database without code, directly from command line by typing query.

Answer 10

Hey @Peter Carter , I created a free web host on byet and I cannot interact with sql. Do you know any way to interact with it?

Answer 11

@Peter Carter Wow thanks for replying! at byethost it came all installed mysql so I just created an account 🤣. AFAIK I should have access to it and it gave me a link for db and username and pword too. I will check it out in a few secs

Answer 12

yes it's on https, so this counts as SSH enabled? If I have a mistake please correct me because I am unexperienced on these things.

Answer 13

@Arda Aydin Do you have direct SSH access to the server? What method did you use to setup the SQL database? If there really is sufficient interest I might get chance to setup access to a user area on my PostgreSQL server, but that's potentially a pretty big job, so if you've got part of a solution and I can help link it to a SoloLearn sandbox that might be better? I'm working from home today and need to do proper work stuff and attend a few web meetings but after I finish I'm willing to lend a hand.

Answer 14

@Arda Aydin Still at work for three-four hours, but quickly: 1) No. HTTPS enables the browser to communicate with the server securely (loosely speaking), while SSH allows secure access to the server shell (e.g. the command line, or BASH). 2) It may be easier if we remote on to my server (email me at [e-mail] and I'll send you a login once I have finished work, and help you to setup SSH), but basically what we'll need to do is write a simple API to allow code entered inside a web form in the sandbox in SoloLearn to be sent to my sandbox SQL server and to communicate with it in two directions. A non-trival but particularly interesting task. Or there's Swagger...