I replaced Home Assistant's built-in database with PostgreSQL, and my smart home finally feels snappy
… Why is SQLite not good enough? It starts to struggle There's a reason why SQLite struggles at scale, and this is down to its architecture. …
Tracked topic
… Why is SQLite not good enough? It starts to struggle There's a reason why SQLite struggles at scale, and this is down to its architecture. …
… MCP Memory Service is the episodic layer: SQLite with the sqlite-vec extension, local ONNX embeddings, semantic search, and niceties like semantic deduplication — it flatly refused when my model tried to store the same fact twice. …