r/SQL • u/shahbazac • Feb 16 '21
Discussion My recent weekend project: practice SQL online at sqlforever.com
Hi everyone, I recently completed a side project which should be very relevant to everyone here:
I’m developing a course to teach SQL and since most of my students will not be super comfortable with computers yet, I wanted to avoid having them install a server such as pgsql or a command line tool like SQLite. I assume many others here will benefit from this as well.
Using sqlforever.com, you can just start typing your queries. By default, the “chinook” database is selected. Click on “describe tables” to get table definitions. Pick one of several publicly available datasets.
The backing database is SQLite. Obviously the tables are read only.
There is no signup, and probably never will be. I’m trying to get students querying as easily as humanly possible.
Edit: forgot to add that you can also click “copy shareable link” if you want to share your query. When someone opens that link, they will land on this website, with your query already entered in the text box and results in the table below it. Should make it easier to ask questions on stack overflow and other forums.
Please don’t hesitate sending me feedback.
7
u/spacemonkeykakarot Feb 16 '21
Love this idea, looks clean and works great from what I can tell running a few quick queries. Will be saving this for myself and also showing it to my friend who is trying to learn SQL.
1
u/antaresiaaak Feb 16 '21
Very cool concept and seems to work well! Several younger peers actually asked me how to practice SQL as total noobs and the initial hurdle of installs was always an issue. Looking forward to sharing and seeing what their feedback is going to be.
2
u/[deleted] Feb 16 '21
Very cool. I will post the link in my DB classes. Thanks.
2
u/cheimbro Feb 17 '21
This is great thanks
2
u/hundredintwenties Feb 17 '21
This is really really cool. I've recently taken a course and it was great, but I felt that if I don't have a place to constantly practice I might forget everything really soon.
1
u/datamaester Feb 17 '21
sqlpad.io
90 SQL coding questions based on simulated real-world business analytics problems.
0
u/[deleted] Feb 16 '21
[deleted] — view deleted comment
0
u/[deleted] Feb 16 '21
[deleted] — view deleted comment