+ 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?
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...)
+ 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
+ 22
Then. .Why get certified in a language we can't practice ?🤷♂🤷♂🤷♂🤷♂🤷♂🤷♂🤷♂🤷♂🤷♂🤷♂
+ 18
Best answers ive seen are on this thread of the same topic:
https://www.sololearn.com/Discuss/1853767/?ref=app
+ 12
Please add one Sololearn!
+ 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!!
+ 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? : )
+ 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.
+ 8
Set up your own database on your PC and use that if you wanna play around with SQL queries :-)
+ 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.
+ 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😁👍
+ 5
This can create a huge security vulnerability.
+ 4
Abraham(I. Aychoua) sql challenges would be a bit easier to implement than adding sql to the code playground.
+ 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. 🙏
+ 2
wow, i've just started the sql course too. didn't knew about that :0
+ 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).
0
PoloLadyCoder you can use Sqlite3 in the code playground
https://code.sololearn.com/cwuIN14vDXHv/?ref=app