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

Imagine monitoring actually built for developers

Billboard image

Join Vercel, CrowdStrike, and thousands of other teams that trust Checkly to streamline monitor creation and configuration with Monitoring as Code.

Start Monitoring

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay