Skip to main content

​
SQLite

SQLite requires no server setup and stores data in a local file. It is built into Python, so it works out of the box.

​
Install

No extra packages needed — SQLite is built into Python. 
pip install memori openai

​
Quick Start

from memori import Memori
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

engine = create_engine("sqlite:///memori.db")
SessionLocal = sessionmaker(bind=engine)

mem = Memori(conn=SessionLocal)
mem.config.storage.build()

​
Connection Strings

Path TypeConnection StringDescription
Relativesqlite:///memori.dbFile in current directory
Absolutesqlite:////home/user/data/memori.dbAbsolute path (four slashes)
In-Memorysqlite:///:memory:Temporary, lost on exit

​
Complete Example

import os
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from memori import Memori
from openai import OpenAI

# Setup SQLite
engine = create_engine("sqlite:///memori.db")
SessionLocal = sessionmaker(bind=engine)

# Setup Memori with OpenAI
client = OpenAI(api_key=os.getenv("OPENAI_API_KEY"))
mem = Memori(conn=SessionLocal).llm.register(client)
mem.attribution(entity_id="user_123", process_id="my_agent")
mem.config.storage.build()

# First conversation - establish facts
response = client.chat.completions.create(
    model="gpt-4o-mini",
    messages=[{"role": "user", "content": "My favorite language is Python."}]
)
print(response.choices[0].message.content)

# Wait for augmentation and recall facts
mem.augmentation.wait()
facts = mem.recall("favorite programming language")
print(facts)

​
Multi-Threading

For web servers or multi-threaded apps, disable the same-thread check: 
engine = create_engine(
    "sqlite:///memori.db",
    connect_args={"check_same_thread": False}
)
SQLite handles concurrent reads well but serializes writes. For high-concurrency production environments, use PostgreSQL instead.

Build docs developers (and LLMs) love

Get started for freeTalk to us