SQLite

Use SQLite for lightweight, serverless local databases.

Overview

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. It is perfect for local testing and lightweight state storage.

Zero Configuration

No setup or administration needed.

Serverless

Reads and writes directly to ordinary disk files.

Configuration

1. Find your Database Path

   Decide where your database file will live (e.g., data/local.db).

2. Configure

   Point Arivu to your database file:

   .env

   SQLITE_PATH="sqlite:///data/local.db"
   

SQLite is heavily restricted in concurrent write access. It is not recommended for heavy multi-user production applications.