[deleted]
Building a DOOM-like multiplayer shooter in pure SQL
11–20 of 42 posts
Re: Building a DOOM-like multiplayer shooter in pure SQL
#12Author of the mentioned DuckDB-DOOM here! This is awesome - multiplayer is a great addition. Really like the cone in the mini-map too
This is pretty neat. I was expecting a WAD file to get loaded, but this was still pretty neat, even better than Windows XP in JS.
Re: Building a DOOM-like multiplayer shooter in pure SQL
#13Feel 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#
"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.
Re: Building a DOOM-like multiplayer shooter in pure SQL
#14It’s a very cool accomplishment. As a nerd of early shooters, I do wonder whether it’s fair to call it Doom-like. It’s clearly more untextured Wolfenstein 3d. Are we sufficiently far from 1993 to just “round” it all to being Doom-like? certainly it’s better for eyeballs.
Yeah, it is definitely Wolfenstein 3D in my opinion. Many Doom-clones are. Maybe Wolfenstein 3D is a Doom-clone in itself? I dunno, I do not know the history. Can anyone enlighten me?
Re: Building a DOOM-like multiplayer shooter in pure SQL
#15Author of the mentioned DuckDB-DOOM here! This is awesome - multiplayer is a great addition. Really like the cone in the mini-map too
Re: Building a DOOM-like multiplayer shooter in pure SQL
#16It’s a very cool accomplishment. As a nerd of early shooters, I do wonder whether it’s fair to call it Doom-like. It’s clearly more untextured Wolfenstein 3d. Are we sufficiently far from 1993 to just “round” it all to being Doom-like? certainly it’s better for eyeballs.
Yeah, it is definitely Wolfenstein 3D in my opinion. Many Doom-clones are. Maybe Wolfenstein 3D is a Doom-clone in itself? I dunno, I do not know the history. Can anyone enlighten me?
Wolfenstein came first, Doom followed from the same team. While some doom clones at the time continued to use the Wolfenstein engine it was fairly brief. Rise of the triad is I think the most impressive one using basically the Wolfenstein model?
Re: Building a DOOM-like multiplayer shooter in pure SQL
#17Feel 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#
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!
Re: Building a DOOM-like multiplayer shooter in pure SQL
#18This is a clever ad! I had not heard of them so I looked up the technology behind it: https://cedardb.com/docs/technology/ A Postgresql-compatible HTAP. It appears to be single server and closed source. Roadmap: https://cedardb.com/docs/roadmap/
Would this multiplayer work on Postgresql?
Re: Building a DOOM-like multiplayer shooter in pure SQL
#19Author of the mentioned DuckDB-DOOM here! This is awesome - multiplayer is a great addition. Really like the cone in the mini-map too
Love that you liked it! Your project was the inspiration and showed me the insanity was actually feasible :D
Re: Building a DOOM-like multiplayer shooter in pure SQL
#20I'd say this is more like Wolfenstein 3D :)
That's just my age showing, I guess. For me, all 2.5D shooters are DOOMlikes.
I was actually first thinking about calling it a Quake-like since IMHO that is much more well known for its multiplayer, but then I never got around to implement powerups and all the other stuff people might have expected.