feat: require live infrastructure for event store and inference, removing offline mode

feat: update dependencies for durable Postgres event store and ensure core requirements are met

feat: env-gated Postgres event store via SQLAlchemy (layered)