Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ask HN: Are there any websites for SQL puzzle games?

news.ycombinator.com

Post reply on HN
Print view View original

41–49 of 49 posts

Re: Ask HN: Are there any websites for SQL puzzle games?

#41

Post by awesomeMilou »

leifhka wrote: post #40

Not quite puzzles, but since someone else mentioned Schemaverse, I have made a similar but Elite inspired SQL-game called Datastar [1]. It features a simulated economy with traders and miners, and the goal is to make as much money as possible. Everything is done via SQL (or other PostgreSQL features), and the player need to make and manage a database of information about the planets and their economies. I teach uni.…

I'm trying this out right now, since I'm writing a database exam on thursday. Is there a way to provide feedback?

I feel like the game has a lot of potential but some stuff feels kinda painful.

Like figuring out all constants for example.

Re: Ask HN: Are there any websites for SQL puzzle games?

#44

Post by rahimnathwani »

cronopios wrote: post #38
quickthrower2 wrote: post #37

Earlier quoted context omitted.

Postgres running local has good ROI. You can reuse that knowledge on a remote server. More than SQL you can learn about setting up databases and schemas etc.

Can you recommend any good book/resource to pick up PostgreSQL? I'm familiar with MySQL/MariaDB, but have no experience with Postgres.

The best I've seen is The Art of PostgreSQL: https://theartofpostgresql.com/

Re: Ask HN: Are there any websites for SQL puzzle games?

#45

Post by leifhka »

awesomeMilou wrote: post #41
leifhka wrote: post #40

Not quite puzzles, but since someone else mentioned Schemaverse, I have made a similar but Elite inspired SQL-game called Datastar [1]. It features a simulated economy with traders and miners, and the goal is to make as much money as possible. Everything is done via SQL (or other PostgreSQL features), and the player need to make and manage a database of information about the planets and their economies. I teach uni.…

I'm trying this out right now, since I'm writing a database exam on thursday. Is there a way to provide feedback? I feel like the game has a lot of potential but some stuff feels kinda painful. Like figuring out all constants for example.

Feedback would be great, thank you! For concrete pains I welcome making issues on the repo. Otherwise you could comment here or DM me :) Also note that the game is far from finished, with lots of remainong TODOs.

Regarding constants, which are you thinking of?

Re: Ask HN: Are there any websites for SQL puzzle games?

#46

Post by prometheon1 »

mrtimo wrote: post #33
NortySpock wrote: post #27

Others 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.

You don't even need a database file if you use Malloy, just a .parquet file or .csv file will work. Think of a .parquet file as a python dataframe saved as a file. DuckDB combined with Malloy are a powerful combo. If you like writing SQL queries for fun, you should like writing Malloy queries even more (at least I do). If you are looking to compare timeframes, Malloy does this well: https://docs.malloydata.dev/docume…

You don't even need Malloy if you use DuckDB, just a .parquet file or .csv file. https://duckdb.org/docs/data/overview

Re: Ask HN: Are there any websites for SQL puzzle games?

#48

Post by cronopios »

rahimnathwani wrote: post #44
cronopios wrote: post #38

Earlier quoted context omitted.

Can you recommend any good book/resource to pick up PostgreSQL? I'm familiar with MySQL/MariaDB, but have no experience with Postgres.

The best I've seen is The Art of PostgreSQL: https://theartofpostgresql.com/

Thank you, sir!

Re: Ask HN: Are there any websites for SQL puzzle games?

#49

Post by awesomeMilou »

leifhka wrote: post #45
awesomeMilou wrote: post #41

Earlier quoted context omitted.

I'm trying this out right now, since I'm writing a database exam on thursday. Is there a way to provide feedback? I feel like the game has a lot of potential but some stuff feels kinda painful. Like figuring out all constants for example.

Feedback would be great, thank you! For concrete pains I welcome making issues on the repo. Otherwise you could comment here or DM me :) Also note that the game is far from finished, with lots of remainong TODOs. Regarding constants, which are you thinking of?

I don't have my Gitlab credentials set up on my Laptop but I'll open an issue in the Gitlab Repo once I'm finished with my exams.
Post reply on HN