How does Thomas' memory work?

I've been thinking about how to the AI agent's(I'm calling Thomas) what memory should look like. So far I've come up with these requirements.

ChatGPT pointed me toward Postgres, and I agree - it’s the clear winner. Here’s why:

Where I diverged from ChatGPT was in the schema design. Their sketch felt too vague, so I put together my own.

The CoreMemory table will store data related to personality, safety protocols, and the principles that define who the bot “believes” it is. I’ll also create a Persona table to capture all interactions with new entities, which allows me to manage or blacklist troublesome ones. The memory model loosely mirrors human cognition - short-term and long-term memory separated. It’s an intentional oversimplification to keep the MVP lightweight; I’d rather build something functional now than over-engineer. Over time, I can refine it further, but this foundation gives the system a clear psychological architecture: identity, memory, relationships, and reflections.

Anyways, I'm back from my vacation and should make progress on this again.