News for hackers. Stuff that matters.

A comment on Chess in SQL. Parent comment

Re:Chess in SQL by ctippett on Wednesday April 01, 2026 @01:59PM (#47604271)
I started playing World of Warcraft at the same time I was studying database systems at university and had a similar curiosity. Twenty years later the AzerothCore project pretty much satisfies this curiosity, they've done an incredible job reverse engineering the game server and its database.

https://www.azerothcore.org/wiki/database-world

[ Parent | on HN ]
Re:Chess in SQL by vakrdotme on Wednesday April 01, 2026 @02:47PM (#47604881)
That’s fascinating. I didn’t realize the WoW server was so database heavy. do you know if the original game logic was implemented mostly in stored procedures, or was it just used for persistence and the engine handled the rules elsewhere?
[ Parent | on HN ]
Re:Chess in SQL by ctippett on Wednesday April 01, 2026 @03:00PM (#47605039)
I don't know I'm sorry. I'm not involved in the project, just a curious bystander!
[ Parent | on HN ]
Re:Chess in SQL by StilesCrisis on Wednesday April 01, 2026 @05:43PM (#47606910)
It's not, no. The data you see in these files is reconstituted from the data that shipped with the game client, but they're not a perfect match for the real data.

The game servers are all C++ and don't use stored procedures for general gameplay management. They do handle inventory management so that item duping is generally not possible, and complex things like cross-server character transfer use stored procedures.

[ Parent | on HN ]