murder-mystery

Solving the murder mysteries available on the internet

Solutions available

• gitstery
• clmystery
• SQL Mysteries

gitstery

• You can take a look in progress.txt to see my logic flow to solve the mystery (it's randomly structured, sorry)
• search_murder.sh it's a hacking way to solve this: it collects all residents available and crack the solution by brute-force (I swear I did this AFTER solving normally first :p)
• To try it yourself you need to clone the original git repository too, since all the metadata of git it's important to solve the problem
• This murder-solving it was my first, so it's documented very poorly
• the commands git rev-list, git grep and git hash-object it was a interesting discover

clmystery

• I have a did.txt log file about my thought process in details
• In the script commands.sh it contains all the shell commands to cross data and info to find the fucking murder. It combine the clues individually until just one suspect remains in the end.
• Basically a lot of grep and pipes, though (learn about grep context (-C|-B-A) too)

SQL Mysteries

• I solve each one SQL query per once locally using a SQLite Browser that has capabilities to run SQL queries.
• Take a look in the queries directory to understand the flow.
• You can execute each one individually to understand all the solution.

Author

Manoel Vilela, 2020