Technical
Finding the Virtualization Sweet Spot with Proxmox and Ansible
What to choose in physical servers, virtual machines/VMs, Docker containers/LXC, Kubernetes, and hyperscalers like GCP/AWS? Proxmox, apparently.
Technical
Posts about the technical design and architecture of the Blasphemess game.
Technical
Python Celery Task Queue For My Browser Game
Outside the HTTP request cycle, I need something that handles asynchronous tasks, like periodically running NPC actions. Enter Celery.
Technical
SQLAlchemy, Race Conditions, And PostgreSQL Advisory Locks
Race conditions and game state consistency are a hard problem in the concurrent world of FastAPI. Can SQL locks be an easy solution?
Technical
Game Server Sharding: Blasphemess Clusters and the Portal
Vertical scaling servers can only get you so far; horizontal scaling and sharding is a great complement to support massive scale.
Technical
SQL Check Constraints: Ensuring One Item Has One Owner
Items can be referenced in several tables in the database, which means they have multiple foreign keys. How do I ensure ownership of an item?