Introducing MoneyBowl!
Hello world! I have built a website where you can practice SQL on cricket stats. It's called 🏏 MoneyBowl.
If you are a fan of cricket and a data enthusiast, please visit. You can explore the data to find answers to questions you've always had or try to solve predefined queries.
Tech behind MoneyBowl
The website is built with Next.js. Users submit SQL queries, which are executed in the browser. If the results match the predefined answers, you earn points.
In-Browser SQLite
The database is loaded into memory using sqlite-wasm. All queries are executed in the browser, with no server involved.
Loading the Database into the Browser
The SQLite .db file loaded into memory is around 500MB. To load the database, users only need to download a pre-compressed Brotli file of around 50MB.
About the Data
The dataset is sourced from cricksheet.org and inserted into a SQL database by me. It contains information about players, teams, and matches. For each match, we have detailed information about each delivery, wicket, and run.
Top comments (0)