Logo

dev-resources.site

for different kinds of informations.

Practice SQL using Cricket Dataset (Moneybowl)

Published at
12/31/2024
Categories
sql
showdev
Author
il3ven
Categories
2 categories in total
sql
open
showdev
open
Practice SQL using Cricket Dataset (Moneybowl)

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.

ER Diagram

Featured ones: