I recently tried the SQLite database for the AI memory. It works so smooth I barely have any need for storing the memory in any other database.
However life means you have to keep on trying for the new options. So I found the Duckdb useful while testing some of the sample data analysis apps.
So I decided to make use of the Duckdb for the Hermes agent. And this process video is my way of testing the integration. I also managed to do CRUD operations. Check the below video for the hermes agent with Duckdb as a memory.
Take an example. You have certain analysis specific data that you work with Hermes agent for everyday work. I think Hermes agent can use any database and get its essential work done across.
But with the Duckdb and the Python script is how I made the workflow work there. Like you do the CRUD operations and that would be a good direction for your work to be done. Duckdb just gets the work done in this sort of flow.
Hermes agent can get your integration with the Duckdb. And you ask it to create variety of python scripts that would help you connect with duckdb and then later you can make a query to get the data out.
So the best approach would be adding the duckdb option into memory providers list. After that we create python script to do the CRUD work with the duckdb. And finally we setup process to do this on recurring basis. So hermes agent can actually do the process required for this.
