2026-11-10•4 min read
Lessons Learned from Building the Cloudpass System
Architecting a fast game catalog and account management system with serverless edge databases and zero runtime latency.
#Cloudpass#Cloudflare D1#Architecture#Full Stack
The Cloudpass project was designed to solve a very specific problem: handling a rich, structured catalog of games, accounts, and server state without paying for expensive always-on server infrastructure.
The Stack Architecture
Instead of spinning up a dedicated VPS or Docker container:
- Frontend & Static Pages: Served via Cloudflare Pages global CDN.
- Data Layer: Cloudflare D1 (distributed serverless SQLite at the edge).
- Functions: Serverless Workers running on the edge to process queries securely.
Key Takeaways
- Edge databases change the equation: Traditional SQL databases introduce latency if your server is in US-East and the client is in Asia. Edge-replicated SQLite queries return in single-digit milliseconds.
- Simple beats clever: Keeping the client interface lightweight and modular makes debugging trivial compared to maintaining massive state machines.
- Automate data pipelines: Pre-rendering structured items and automating metadata sync saves dozens of hours of manual database maintenance.
Published by Apurbo (@apurbothea1)
Feel free to reach out with thoughts or questions.