Bakas

How to play

• Bakas means trace, or footprint. Every case comes with a brief and its own small database: incident reports, gate logbooks, a sari-sari store's utang notebook, office receipts, cargo scans. Write real SQL queries to read them, follow the clues from table to table, and type the culprit's name to accuse them.
• Start with the tutorial if you've never written SQL. Each case teaches a little more: SELECT, WHERE and ORDER BY, then LIKE, IN and BETWEEN, then COUNT, GROUP BY and HAVING, then JOINs, and finally subqueries and dates.
• Tap a table or column name to add it to your query, and press Ctrl (or ⌘) + Enter to run it. Clues you uncover go into your notebook automatically. If you get stuck, hints unlock one at a time.
• The databases are read-only, so you can't break anything: only SELECT queries run. It's real SQLite, running in your browser. It needs an internet connection the first time, to download the SQL engine. Your progress and notes stay in your own browser only.
• All the cases are made up and family-friendly: nobody gets hurt, though one lechon loses an ear.