There used to be a multiplayer space game called Schemaverse that was played by writing sql, but it seems to have gone away. https://schemaverse.com/
Found this on GitHub: https://github.com/Abstrct/Schemaverse
Ask HN: Are there any websites for SQL puzzle games?
21–30 of 49 posts
Re: Ask HN: Are there any websites for SQL puzzle games?
#22www.sql-ex.ru + the book on that site are by far the best SQL exercises I have seen.
PS. I know you asking about just RAW SQL, but I highly suggest you get into understanding how particular DBMS works in depth, what plans it builds, what concurrency mechanisms it uses. Writing raw SQL will get you only so far, making those queries actually production ready is completely different ballgame and for that, you don't need to be super proficient in SQL.
Re: Ask HN: Are there any websites for SQL puzzle games?
#23UPDATE POSTS SET VOTE_COUNT = VOTE_COUNT + 1 WHERE POST_ID = CURRENT_POST_ID();
CREATE TABLE SQL_GAMES blah blah blah
INSERT INTO SQL_GAMES many invited users blah blah blah
SELECT * FROM SQL_GAMES WHERE users are having fun blah blah blah
PROFIT blah blah blah
ENJOY even more blah
-- TODO: drastically restructure above schema and SQL statements to make more sense blah blah blah
-- there's your game blah blah blah
Re: Ask HN: Are there any websites for SQL puzzle games?
#24UPDATE POSTS SET VOTE_COUNT = VOTE_COUNT + 1 WHERE POST_ID = CURRENT_POST_ID(); CREATE TABLE SQL_GAMES blah blah blah INSERT INTO SQL_GAMES many invited users blah blah blah SELECT * FROM SQL_GAMES WHERE users are having fun blah blah blah PROFIT blah blah blah ENJOY even more blah -- TODO: drastically restructure above schema and SQL statements to make more sense blah blah blah -- there's your game blah blah blah
[deleted]
Re: Ask HN: Are there any websites for SQL puzzle games?
#25Not a game but a great way to learn SQL is https://sqlbolt.com
+1 I like this one a lot.
Re: Ask HN: Are there any websites for SQL puzzle games?
#26www.sql-ex.ru + the book on that site are by far the best SQL exercises I have seen. PS. I know you asking about just RAW SQL, but I highly suggest you get into understanding how particular DBMS works in depth, what plans it builds, what concurrency mechanisms it uses. Writing raw SQL will get you only so far, making those queries actually production ready is completely different ballgame and for that, you don't need…
The connection times out to the website. Any links of same exercises and book available more generally?
Re: Ask HN: Are there any websites for SQL puzzle games?
#27Others have given you excellent suggestions; I will simply offer an addition -- a side quest, if you will:
Remember that the local single-user databases SQLite and DuckDB exist, and that you can use them to wrangle data without even having to set up a separate server. You just create a database file on your machine and go from there.
Re: Ask HN: Are there any websites for SQL puzzle games?
#28I’ve had fun going through SQL Murder Mystery ( https://mystery.knightlab.com/ ) I even use it for hiring exercises.
While it was not challenging SQL, it does require paying attention to the prompt, writing the queries, and following the clues. I could easily see myself blowing it in an interviewing situation with someone staring me down. In the zero pressure environment at home, I almost tripped on the fact that the license plate clue said it "included XYZ" while I initially queried `like 'XYZ%'`
Re: Ask HN: Are there any websites for SQL puzzle games?
#29At beginner level, there is SQL Island https://sql-island.informatik.uni-kl.de, with versions in German, English and French.
Re: Ask HN: Are there any websites for SQL puzzle games?
#30At beginner level, there is SQL Island https://sql-island.informatik.uni-kl.de , with versions in German, English and French.
Where is the English language version? Would love to use with my son!