summaryrefslogtreecommitdiff
path: root/docs/content/configuration/storage/sqlite.md
blob: 60790404a2af124eeb42cc65d57015217b2949b4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
---
title: "SQLite3"
description: "SQLite3 Configuration"
summary: "The SQLite3 storage provider."
date: 2022-06-15T17:51:47+10:00
draft: false
images: []
weight: 107500
toc: true
aliases:
  - /docs/configuration/storage/sqlite.html
seo:
  title: "" # custom title (optional)
  description: "" # custom description (recommended)
  canonical: "" # custom canonical URL (optional)
  noindex: false # false (default) or true
---

If you don't have a SQL server, you can use [SQLite](https://en.wikipedia.org/wiki/SQLite).
However please note that this setup will prevent you from running multiple
instances of Authelia since the database will be a local file.

Use of this storage provider leaves Authelia [stateful](../../overview/authorization/statelessness.md). It's important
in highly available scenarios to use one of the other providers, and we highly recommend it in production environments,
but this requires you setup an external database such as [PostgreSQL](postgres.md).

## Configuration

{{< config-alert-example >}}

```yaml {title="configuration.yml"}
storage:
  encryption_key: 'a_very_important_secret'
  local:
    path: '/config/db.sqlite3'
```

## Options

This section describes the individual configuration options.

### encryption_key

See the [encryption_key docs](introduction.md#encryption_key).

### path

{{< confkey type="string" required="yes" >}}

The path where the SQLite3 database file will be stored. It will be created if the file does not exist.