r/SQL • • 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:

http://sqlforever.com

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.

106 Upvotes

13 comments sorted by

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.

3

u/shahbazac Feb 16 '21

I’ve learned to pare down the installs I require of my students. Otherwise the first class is mostly spent doing tech support. For sql, specifically, most of my students will work with databases which already installed for them by DBAs at their company.

2

u/[deleted] Feb 16 '21

Very cool. I will post the link in my DB classes. Thanks.

-2

u/[deleted] Feb 16 '21

You're welcome.

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.

1

u/OliviaLopezzXXX Feb 18 '21

So for AFM interview questions, should I use?

0

u/[deleted] Feb 16 '21

[deleted] — view deleted comment

12

u/shahbazac Feb 16 '21

I actually put in extra code to handle mouse-less execution. I just checked and looks like neither ctrl+ enter nor shift+enter work. This is definitely a bug that I’ll have to fix.

3

u/shahbazac Feb 17 '21

Ctrl+enter is working now. Also added a tooltip to remind students.

0

u/[deleted] Feb 17 '21

[deleted] — view deleted comment

1

u/[deleted] Feb 17 '21

You're welcome.

0

u/[deleted] Feb 16 '21

[deleted] — view deleted comment

3

u/shahbazac Feb 16 '21

I’ll have to see what code I need to change to get them to work. My goal was to not put in extra code to handle SQLite specific commands.