14 votes

Why it is time to start thinking of games as databases

6 comments

  1. [4]
    rmgr
    Link
    I think where the article veers in to ChatGPT LLM stuff is neither here nor there but I've been designing an ECS-based game lately and thinking about how to apply the pattern to NPC AI to achieve...

    I think where the article veers in to ChatGPT LLM stuff is neither here nor there but I've been designing an ECS-based game lately and thinking about how to apply the pattern to NPC AI to achieve a FEAR-style Goal Oriented Action Planning system. Maybe this is simple and I've just been missing the point of ECS but I found it interesting!

    5 votes
    1. [3]
      CommonDreads
      Link Parent
      I'm currently re-playing the game again and the AI is something else. To think it's a 18 years old game blows my mind. I'd love a remaster/remake with today's tools and tech!

      to achieve a FEAR-style Goal Oriented Action Planning system.

      I'm currently re-playing the game again and the AI is something else.

      To think it's a 18 years old game blows my mind.

      I'd love a remaster/remake with today's tools and tech!

      1 vote
      1. rmgr
        Link Parent
        Oh man I enjoyed FEAR 2 and 3 as a dumb turn your brain off shooter but neither of them were anywhere near as great as the original!

        Oh man I enjoyed FEAR 2 and 3 as a dumb turn your brain off shooter but neither of them were anywhere near as great as the original!

        1 vote
      2. [2]
        Comment deleted by author
        Link Parent
        1. CommonDreads
          Link Parent
          Apart from the "spooky" moments (which are engraved in my memories forever... damn ladders!) the AI is really fun to play against (except the robots), after reading the article I played some more...

          Apart from the "spooky" moments (which are engraved in my memories forever... damn ladders!) the AI is really fun to play against (except the robots), after reading the article I played some more and paid attention to the enemies behaviour.

          Seeing them really react to my playstyle was fun, trying to spot me or to push me when stationary behind cover or them retreating when I was playing nade-shotgun-aggressive. It's not something that you notice when playing as kid, that's for sure, all I cared back then was shooting my weapons and kill them all.

          Speaking of gunplay the weapons are very satisfying for me, rifles recoil hits hard and you have to control it or time your sprays in order to secure kills for targets further away.

          Won't lie, some aspects of the game didn't age that well for example: models and textures are very simple and repetitive, weapons animations (like some rifles just "disappear" when you reload) or some levels' design but overall I still really enjoy the game.

  2. [2]
    skybrian
    Link
    One thing I wonder about: Prolog wasn't fast. The backtracking tends to result in performance that scales badly, particularly with recursive queries, so as you make your searches more...

    One thing I wonder about: Prolog wasn't fast. The backtracking tends to result in performance that scales badly, particularly with recursive queries, so as you make your searches more sophisticated, at some point it hangs with a query that takes forever.

    This is similar to how you can write a regexp that performs badly if the regexp engine does backtracking and you wrote it the wrong way, or a database query that performs badly if you don't have the right indexes or it came up with a bad query plan. Actual databases have sophisticated query engines to try to avoid this, but it can still happen.

    So, it seems like dynamically generated queries could make game performance unpredictable? Or maybe computers have sped up so much since I played with Prolog that it's not a problem anymore.

    And I guess we're used to seeing games that slow down when things get complex.

    2 votes
    1. rmgr
      Link Parent
      Yeah I can imagine the performance requirements would be pretty staggering for this sort of game. I'm mainly thinking about doing it from the perspective of a roguelike so I've got plenty of time...

      Yeah I can imagine the performance requirements would be pretty staggering for this sort of game. I'm mainly thinking about doing it from the perspective of a roguelike so I've got plenty of time between actions for processing :D

      1 vote