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
Posts about the technical design and architecture of the Blasphemess game.
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?