News for hackers. Stuff that matters.
Re:Ask HN: Are there any websites for SQL puzzle games? by NortySpock on Friday March 01, 2024 @10:30PM (#39569549)
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.

Re:Ask HN: Are there any websites for SQL puzzle games? by mrtimo on Saturday March 02, 2024 @02:45AM (#39570780)
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/documentation/patterns/yoy
Re:Ask HN: Are there any websites for SQL puzzle games? by prometheon1 on Saturday March 02, 2024 @03:46PM (#39575609)
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? by sfn42 on Saturday March 02, 2024 @04:10AM (#39571209)
There's also nothing stopping you from running postgres, sql server, MySQL etc locally.
Re:Ask HN: Are there any websites for SQL puzzle games? by quickthrower2 on Saturday March 02, 2024 @04:28AM (#39571300)
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.
Re:Ask HN: Are there any websites for SQL puzzle games? by cronopios on Saturday March 02, 2024 @04:42AM (#39571357)
Can you recommend any good book/resource to pick up PostgreSQL?

I'm familiar with MySQL/MariaDB, but have no experience with Postgres.

Re:Ask HN: Are there any websites for SQL puzzle games? by quickthrower2 on Saturday March 02, 2024 @06:31AM (#39571830)
I always google what I need. I admit I haven’t gone deep into it. Just the basics for side projects.
Re:Ask HN: Are there any websites for SQL puzzle games? by rahimnathwani on Saturday March 02, 2024 @01:32PM (#39574660)
The best I've seen is The Art of PostgreSQL: https://theartofpostgresql.com/
Re:Ask HN: Are there any websites for SQL puzzle games? by cronopios on Monday March 04, 2024 @02:20AM (#39587854)
Thank you, sir!