Lighter-weight deployment options without a full Postgres setup?

[DomLynch]

Been exploring Hindsight for local agent memory in a dev and research context. Really liked the design approach overall.

Wanted to ask about the Postgres dependency. Is there appetite for a lighter embedded backend option (SQLite or similar) for local-only use cases, or does the architecture fundamentally need Postgres for the entity extraction and graph storage layers?

Genuinely curious about the design constraints rather than pushing a specific direction. Happy to dig into the internals if useful.

[nicoloboschi]

we have pg0 embedded which is the default installation mode