Local (Lightweight/Transactional) DB Support.

[farzbood]

Is your feature request related to a problem? Please describe.
Hi Everyone,
As an Enhancement, it would be nice to have support for popular local/proprietary DBMS installations to be used as Long-Term Memory Storage.

Describe the solution you'd like
Since we already store our apps. transactional/business data in a DBMS e.g: PostgreSQL , it would be nice to have the ability to use that as the AI-Assistance Memory Storage too, for sake of consistency and ease of use/deployment.
So adding support for PostgreSQL (pgvector) in combination with Chromadb specifically, will be appreciated.
On the other hand, having the ability to use some lightweight storage like SQLite will be a good option for prototyping/test development scenarios.

Describe alternatives you've considered
Letta (formerly MemGPT) has this feature by default.

Additional context
All The Best

[rolandtannous]

@farzbood this repo is now deprecated. It was initially intended as a POC but has been left unmaintained since 2023. For any feature requests, please refer to the original haystack repo at a haystack . Best