DEV Community

Cover image for Practice SQL using Cricket Dataset (Moneybowl)
il3ven
il3ven

Posted on

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

Top comments (3)

Collapse
 
jeck_leach_7c0571f62a1009 profile image
Jeck Leach

Wow Ahmed, I totally agree with you! The combination of cricket stats + SQL practice on MoneyBowl is just genius β€” it really keeps both the data and cricket fans engaged. I love the idea of using historical match data to make predictions, especially with the Asia Cup 2025 right around the corner!

By the way, if you or anyone here wants to watch the Asia Cup 2025 live, I recommend checking out the RBTV77 APK β€” it’s the best free sports streaming app I’ve found so far. It offers free HD live streaming of cricket, football, and more, perfect for following the action while you analyze the stats. 🏏πŸ”₯

Looking forward to seeing what insights everyone digs up on MoneyBowl!

Collapse
 
ahmed_raza_c2649b8b48a14c profile image
Ahmed Raza

This is absolutely brilliant! πŸ‘ As a cricket fan and SQL enthusiast, MoneyBowl sounds like the perfect platform to combine both passions. Practicing SQL using real-world cricket data β€” especially with delivery-level detail β€” makes learning so much more engaging and relevant. The fact that it all runs in-browser with sqlite-wasm is seriously impressive from a tech standpoint too.

With the Asia Cup 2025 approaching, this could even be a fun way to dig into historical performance data and make some data-driven predictions! Looking forward to trying it out. πŸπŸ“Š

Some comments may only be visible to logged-in visitors. Sign in to view all comments.