+ 32

Why Isnt SQL offered in the Playground?

I just spent 2 hours learning on SQL on my laptop. Then I went to my playground and saw every language but Structured Query = SQL Language What am I overlooking?

18th Aug 2019, 2:57 AM
Gwendolyn Phillips de Ashborough
Gwendolyn Phillips de Ashborough - avatar
17 Respuestas
+ 43
PoloLadyCoder Indeed... it would be nice if SoloLearn could support this. However, having worked with many different databases since I started in this profession, I can only imagine the challenge of making this work well. A REPL for an online SQL playground would be the most resource intensive on the server compared to all other languages combined. The reason is each run would require creating a new instance of a database, a script for creating the database tables, a script for populating the tables, and then a script for the test SQL. The strategy would likely need to involve persisting the database between runs and perhaps between sessions, which would take up much more hard drive space and memory. High volume, concurrent runs across many users would become a scalability challenge that would involve creative handling of each request to overcome a usage scenario never intended for database engines. Ideally, the best way to practice would be to setup a database on your local PC. (continued...)
18th Aug 2019, 5:01 AM
David Carroll
David Carroll - avatar
+ 34
That said, SQL REPL websites have begun to emerge, which I imagine weren't easy to achieve. In fact, they aren't nearly as common as code REPLs. Perhaps, these would be good to use until SoloLearn ever attempts to pursue this themselves. - http://sqlfiddle.com - https://repl.it/languages/sqlite - https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
18th Aug 2019, 5:03 AM
David Carroll
David Carroll - avatar
+ 22
Then. .Why get certified in a language we can't practice ?🤷‍♂🤷‍♂🤷‍♂🤷‍♂🤷‍♂🤷‍♂🤷‍♂🤷‍♂🤷‍♂🤷‍♂
18th Aug 2019, 3:26 AM
Gwendolyn Phillips de Ashborough
Gwendolyn Phillips de Ashborough - avatar
+ 18
Best answers ive seen are on this thread of the same topic: https://www.sololearn.com/Discuss/1853767/?ref=app
18th Aug 2019, 3:05 AM
Jason Thomas
Jason Thomas - avatar
+ 12
Please add one Sololearn!
20th Aug 2019, 2:09 PM
[No Name]
[No Name] - avatar
+ 11
Ethan7 No. I will stick to the Creation Content Guidelines. I will take side with the Moderators. For the last time! Do not call me a noob!!
20th Aug 2019, 9:05 PM
JTLZ
+ 10
PoloLadyCoder Probably because handling and responding millions of requests from SoloLearners practicing SQL would be too much to bear for SoloLearn server(s). Even as it is now, the server(s) are already dealing with overload occasionally, you know sometimes things don't work smoothly right? : )
18th Aug 2019, 4:30 AM
Ipang
+ 10
Ethan7 If you want to have your original account back, you need to send an email to SoloLearn (info@sololearn.com) to reactivate your account.
20th Aug 2019, 9:01 PM
JTLZ
+ 8
Set up your own database on your PC and use that if you wanna play around with SQL queries :-)
18th Aug 2019, 6:15 AM
haydenki
haydenki - avatar
+ 6
I imagine its a storage/cost issue; if you were allowed to create your own database through this site Sololearn would have to store the information which is costly to them as it would be considerably bigger than a small bit of code. If they had a premade database that you were allowed to edit it would be open to both abuse and also to being deleted by anyone who isn't well versed enough in SQL.
30th Aug 2019, 5:46 AM
Water Mary♥
Water Mary♥ - avatar
+ 5
I also thought why isn't there any SQL challenges in the beginning to! Now i understand why and the answers make sense to me😉 Though i am looking forward for the online playground for SQL to😁👍
18th Aug 2019, 4:44 PM
Abraham(I. Aychoua)
Abraham(I. Aychoua) - avatar
+ 5
This can create a huge security vulnerability.
19th Aug 2019, 3:33 PM
Sarthak
Sarthak - avatar
+ 4
Abraham(I. Aychoua) sql challenges would be a bit easier to implement than adding sql to the code playground.
19th Aug 2019, 2:09 PM
Sonic
Sonic - avatar
+ 2
Hi ------- (edit) Message from David Carroll: ---- Hi Abbey Olasunkanmi... Please only post messages that are relevant to the topic of the current Q&A thread. Messages like "Hi" are considered to be a distraction and are therefore disruptive. I've also removed the code link you shared for the same reason. Thank you and I hope you understand. 🙏
18th Aug 2019, 4:41 PM
Abbey Olasunkanmi
Abbey Olasunkanmi - avatar
+ 2
wow, i've just started the sql course too. didn't knew about that :0
18th Aug 2019, 4:52 PM
Jessica Campos
Jessica Campos - avatar
+ 1
I Agree with @PoloLadyCoder and @David Carroll, @Sololearn, Since (in my opinion) the premium version of Sololearn App is very expensive. How about implementing a SQL Playground and a more complete web interface, at least for $ Premium users? (If there are interested people enough, Make a SurveyMonkey about it).
20th Aug 2019, 7:24 PM
Ronaldo Marques
Ronaldo Marques - avatar
0
PoloLadyCoder you can use Sqlite3 in the code playground https://code.sololearn.com/cwuIN14vDXHv/?ref=app
31st Aug 2019, 7:41 PM
Paul K Sadler
Paul K Sadler - avatar