Free Social Bingo
Free Entertainment Events Platform
FreeSocialBingo/free-social-bingo|TypeScript 95.5%|Private Repository
A full-stack event management platform built from scratch using AI, featuring a 22-page admin panel, 50+ tRPC API procedures, 10-table relational database, and 6 automated email/notification systems — all with comprehensive test coverage across 28 test files.
Full Technology Stack
Every technology used to build Free Social Bingo, from frontend to infrastructure.
Frontend
Latest React with concurrent features
Utility-first CSS framework
Animation library for React
Accessible component library
Lightweight React router
Icon library
Backend
Server runtime and HTTP framework
End-to-end typesafe API layer
Runtime schema validation
Type-safe serialisation (Date, BigInt)
Database & Storage
Distributed SQL database
TypeScript-first ORM with migrations
Object storage for images and files
Auth & Infrastructure
OAuth 2.0 authentication
Secure session management
Build tool and dev server
Unit testing framework
End-to-end type safety
Under the Hood
A deep dive into the server-side architecture, database design, admin panel, and automation systems.
Authentication
server/routers.tsFull auth lifecycle with profile management, email preferences, and account deletion
Events
server/routers.tsPublic event listing with capacity tracking, admin CRUD with bulk operations
Bookings
server/routers.tsFull booking lifecycle with QR codes, status tracking, and customer portal
Newsletter
server/routers.tsSubscriber management with segmentation, email composition, and delivery analytics
Feedback
server/routers.tsPost-event feedback collection with automated email triggers
Gallery
server/routers.tsPhoto upload to S3, event galleries, and user-submitted photos
Reviews
server/routers.tsCustomer review submission with admin moderation and bulk operations
Email System
server/email.tsTransactional emails with HTML templates for confirmations, reminders, and automation
The Challenge
Free Social Bingo needed a complete platform to manage free entertainment events across the UK — not just a website, but a full business operations system:
- A complete admin panel to manage events, bookings, and attendees at scale
- Automated email systems for confirmations, reminders, and post-event feedback
- QR code check-in system for live events with mobile support
- Newsletter and email marketing with subscriber segmentation
- Customer portal for users to manage their own bookings and preferences
What We Built
We delivered a production-grade platform with enterprise-level backend features:
- 22-page admin panel with real-time dashboard, bulk operations, and analytics
- 50+ API procedures in a type-safe tRPC layer with Zod validation
- 6 automation systems — welcome emails, booking reminders, event reminders, feedback requests, waitlist notifications, and scheduled tasks
- Drag-and-drop email builder with templates, scheduling, and delivery analytics
- Mobile QR check-in with manual attendee lookup fallback for live events
Public-Facing Features
18 public pages built with React 19, Tailwind CSS 4, and Framer Motion.
The Backend That Powers Everything
Behind the public-facing website sits a comprehensive admin dashboard and content management system built with React 19, tRPC, and Drizzle ORM. Every feature below is powered by type-safe API procedures with Zod validation, connected to a 10-table TiDB database.
Click any screenshot to view it full-size. Use arrow keys or click the arrows to navigate between images.
Admin Dashboard — Real-Time KPIs & Event Capacity
React 19 + tRPC useQuery hooks + TiDB aggregation queries
Quick Actions Panel with Interactive Onboarding Tour
Custom tour engine + React state machine + localStorage persistence
Events Manager — Full CRUD with Publish/Archive Workflow
tRPC mutations + Zod validation + bulk operations + optimistic updates
Event Cards with Status Badges & Capacity Tracking
Drizzle ORM joins + real-time booking count aggregation
Bookings Manager — Search, Filter, Check-In & CSV Export
tRPC + server-side filtering + CSV generation + QR code integration
All Bookings — Date Range Filtering & Status Overview
Date-fns + Drizzle date queries + status enum tracking
Mobile Check-In App — QR Scanner & Manual Lookup
html5-qrcode library + responsive mobile-first design + tRPC mutations
Live QR Code Scanner with Camera Integration
Browser MediaDevices API + html5-qrcode + real-time validation
Feedback Analytics — Ratings, Distribution & PDF Export
Aggregation queries + rating distribution charts + PDF report generation
Email Template Builder with Live HTML Preview
Drag-and-drop editor + HTML email rendering + template CRUD via tRPC
API Layer
1,748 lines of tRPC procedures in server/routers.ts handling authentication, events, bookings, newsletters, feedback, gallery, reviews, and email delivery.
Database
518-line schema in drizzle/schema.ts defining users, events, bookings, waitlist, newsletter subscribers, feedback, photos, reviews, and email templates.
Automation
6 automation modules handle welcome emails, booking confirmations, event reminders, feedback requests, waitlist notifications, and scheduled task execution.
Want a backend like this for your business?
We build custom admin dashboards, booking systems, and CMS platforms — powered by AI, delivered in days.
Built in 7 Days, Not 7 Months
AI-enhanced development — guided by our expert team — compressed what would traditionally take 4–6 months of agency work into just 7 days — without sacrificing quality, test coverage, or production readiness.
AI-Powered Development
7 Days
Traditional Agency Development
4–6 Months (Estimated)
Public Website Screenshots
Vibrant Hero Section
Eye-catching neon pink and cyan design with crowd photography, live countdown timer to next event, 'Book Free Tickets' CTA, floating ticket card, and key stats.
Event Finder & Booking System
'What's On' section with search bar, advanced filtering by Location, Month, Event Type, and Sort options. Event cards display dates, '100% FREE' badges, and prominent 'Get Free Tickets' buttons.
What To Expect Section
Four feature cards highlighting the experience — Completely Free Entry, Live Entertainment, Classic Games With A Twist, and Unique Performances.
Event Timeline & Community
Detailed event timeline from 5:30pm to 11:00pm, Food & Drinks information, 'How It Works' explanation of the free entry model, and Community Spirit section.
How AI Transformed This Project
7-Day Delivery
This entire platform — 22-page admin panel, 50+ API procedures, 10 database tables, and 6 automation systems — was built and launched in just 7 days using AI-enhanced development guided by our expert team.
Cost Efficient
The entire platform — frontend, backend, database, email system, and admin panel — was built at a fraction of the cost of traditional agency development.
Production Quality
28 test files ensure reliability. Type-safe tRPC with Zod validation catches errors before they reach production. Role-based access control protects admin features.
"The AI-enhanced development process was incredible. Our team and AI working together delivered a feature-rich platform with a complete admin panel, automated emails, and QR check-in — faster than we ever expected."
Free Social Bingo Team
Founders, Free Social Bingo
They Own Their Code
Free Social Bingo owns their entire platform — frontend, backend, admin panel, and database — in a private GitHub repository. They can extend features, hire any developer, or migrate hosting at any time. No lock-in, no gatekeepers.
Need a Full-Stack Web Application?
We build complete platforms with admin panels, automation, and production-grade backends. Get a free consultation to discuss your project.