Memory with SQLite

Code

cookbook/memory/db/mem-sqlite-memory.py

from agno.agent import Agent
from agno.db.sqlite import SqliteDb

# Setup the SQLite database
db = SqliteDb(db_file="tmp/data.db")

# Setup a basic agent with the SQLite database
agent = Agent(
    db=db,
    enable_user_memories=True,
)

agent.print_response("My name is John Doe and I like to play basketball on the weekends.")
agent.print_response("What's do I do in weekends?")

Usage

1. Create a virtual environment

   Open the Terminal and create a python virtual environment.

   Mac

   python3 -m venv .venv
   source .venv/bin/activate
   
2. Set environment variables

   export OPENAI_API_KEY=xxx
   
3. Install libraries

   pip install -U agno openai
   
4. Run Example

   Mac/Linux

   python cookbook/memory/db/mem-sqlite-memory.py