Building a DOOM-like multiplayer shooter in pure SQL

Re:Building a DOOM-like multiplayer shooter in pure SQL by valorzard on Tuesday September 09, 2025 @02:41PM (#45186613)

Feel like the logical extreme of this is a database built for multiplayer games, something like: https://github.com/clockworklabs/SpacetimeDB

Though there, you are still writing the main game logic in Rust or C#

[ Parent | on HN ]

Re:Building a DOOM-like multiplayer shooter in pure SQL by crooked-v on Tuesday September 09, 2025 @03:54PM (#45187846)

"Just build all the logic directly in the DB" is something I've thought about before for simple multiplayer online RPGs and the like, where quite a lot of things are effectively just a direct mapping from database to screen. But, using the general idea for 'twitch' gaming is really wild.

[ Parent | on HN ]

Re:Building a DOOM-like multiplayer shooter in pure SQL by lvogel on Tuesday September 09, 2025 @04:41PM (#45188661)

Yea, I actually thought of the viability of SQL for games while working on DOOMQL. It's just so easy to express a lot of game logic in SQL queries. As an avid OSRS player I was thinking about doing a simple MUD/MMO next.

Thanks for the pointer to SpacetimeDB - haven't heard of it before!

[ Parent | on HN ]

Re:Building a DOOM-like multiplayer shooter in pure SQL by all2 on Tuesday September 09, 2025 @07:09PM (#45190728)

My understanding is that Spacetime db embeds the "system" component of an ECS into a DB. The rest of the ECS is in there too.

I briefly looked into it, but never got past that fundamental piece.

[ Parent | on HN ]