> ## Documentation Index
> Fetch the complete documentation index at: https://arivu.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# SQLite

> Use SQLite for lightweight, serverless local databases.

<img src="https://mintcdn.com/arivu/piekGGEpY74vFGfF/images/sqlite.png?fit=max&auto=format&n=piekGGEpY74vFGfF&q=85&s=2fd09b7f313cda5202621546ff5a4362" alt="SQLite Integration" width="1919" height="899" data-path="images/sqlite.png" />

## 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.

<CardGroup cols={2}>
  <Card title="Zero Configuration" icon="gear">
    No setup or administration needed.
  </Card>

  <Card title="Serverless" icon="computer">
    Reads and writes directly to ordinary disk files.
  </Card>
</CardGroup>

## Configuration

<Steps>
  <Step title="Find your Database Path">
    Decide where your database file will live (e.g., `data/local.db`).
  </Step>

  <Step title="Configure">
    Point Arivu to your database file:

    <CodeGroup>
      ```bash .env theme={null}
      SQLITE_PATH="sqlite:///data/local.db"
      ```
    </CodeGroup>
  </Step>
</Steps>

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