Show HN: SQL Noir – Learn SQL by solving crimes

Re:Show HN: SQL Noir – Learn SQL by solving crimes by fodkodrasz on Friday February 14, 2025 @06:52AM (#43047440)

The idea is good, but the UI is all but immersive.

Things that would it make more immersive:

- autocomplete

- and/or the ability to view the schema alongside the query (on a wide enough screen)

- a way to copy table and column names easily with a click (table names cannot be selected at all!)

- ability to just add more queryies under/over the already executed ones, instead of only being able to replace them.

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by tiu on Friday February 14, 2025 @08:46AM (#43048180)

Agree with all but autocomplete should either be a hidden feature or disabled by default since I think it takes away from the immersion as well forces you to recall.

Maybe enabled on a NG+?

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by jkubicek on Friday February 14, 2025 @08:55AM (#43048285)

Commenting out blocks of code with command-/ would be super useful as well

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by chrisBHappy on Friday February 14, 2025 @09:17AM (#43048509)

Thank you for the suggestions. I have just implemented the following: - Side by Side view to open up two different tabs at the same time - Copy button to copy table names

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by fodkodrasz on Friday February 14, 2025 @12:31PM (#43050730)

Great job! I'm happy if I could provide useful feedback. I wish you luck, this is a fun learning tool!

[ Parent | on HN ]