> Markdown version of https://yucca.app/en/docs/guides/DB/. Documentation index: [llms.txt](https://yucca.app/en/llms.txt), full text in one file: [llms-full.txt](https://yucca.app/en/llms-full.txt). Any page is available as Markdown: append `.md` to its URL without the trailing slash.

# Database

## Overview

Yucca requires a database to operate; by default this is SQLite, and the database file is stored in the [state_dir](https://yucca.app/en/docs/configuration.md#path) directory. SQLite is sufficient for working with a small number of cameras and motion events, plus there's nothing extra to configure. But when operating in production environments with a large number of cameras (more than 10) and motion detection enabled, we recommend using [PostgreSQL](https://yucca.app/en/docs/guides/DB/postgres.md) as the database, since it's more performant.

## Next

* [Installing PostgreSQL](https://yucca.app/en/docs/guides/DB/postgres.md)
* [Migrating from SQLite to Postgres](https://yucca.app/en/docs/guides/DB/migration.md)