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
Author
6 person written this
il3ven
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

showdev Article's
30 articles in total
Favicon
Automate vCluster Management in EKS with Sveltos and Helm
Favicon
Breweries App
Favicon
Build Your Perfect Roadmap with Roadmap Creator - A Simple and Intuitive Tool
Favicon
Building a Developer-Focused Search Engine in Rust: Lessons Learned and Challenges Overcome 🚀
Favicon
Sample Programs Repo Celebrates 1,000 Code Snippets
Favicon
Bag: A header-only, simplistic, C++20, zipping & unzipping library.
Favicon
[Boost]
Favicon
I built Zeet. A Git-like version Control System
Favicon
AnyAppStart
Favicon
App for sharing time slots for meetings
Favicon
Rust-Powered Password Decrypter: Find the String Behind the Hash! 🦀🔒
Favicon
Turn Your Life into a Real-Life RPG and Level Up Like a Pro
Favicon
Building a webhook tester from scratch
Favicon
Built a todo app
Favicon
366 days of launch weeks
Favicon
How to Enhance Notion Templates with AI for Smarter Workflows
Favicon
Promoting my project https://github.com/oitcode/samarium in this year 2025. Happy new year all.
Favicon
vogen - Value Object Generator in golang
Favicon
Building a No Code AI Platform and the BFS Algorithm
Favicon
Practice SQL using Cricket Dataset (Moneybowl)
Favicon
🎁 The Dev-First OpenGraph (OG) Image Tool You Need (50% Off Lifetime Access!)
Favicon
Config-file-validator v1.8.0 released!
Favicon
Rusty Journal: A Minimal and Efficient CLI Journal & ToDo App
Favicon
Plangs! Your Guide to Programming Languages
Favicon
Introducing an AI Reels Creator with Stock Assets
Favicon
working on my drawing board app. + 1 screenshot. Will share more soon
Favicon
🤯 #NODES24: a practical path to Cloud-Native Knowledge Graph Automation & AI Agents
Favicon
Meet Your New Productivity Partner: NoteBook-App
Favicon
Initial commit
Favicon
Festive New Year Celebration with Fireworks, Confetti, and More! 🎉

Featured ones: