---
title: "SQLite"
description: "How to use SQLite as the Corridor Platform's metadata database for testing purposes."
---

This section describes how to use SQLite ([https://sqlite.org/](https://sqlite.org/)) as the
metadata database. SQLite is intended for small scale applications as it cannot be used efficiently
with multiple connections. Hence, it does not scale well as a larger number of users use the
application. But it can be used for basic testing.

Supported versions: SQLite 3+

We use sqlalchemy's SQLite dialect - this can be set up using multiple methods that are described in [https://docs.sqlalchemy.org/en/13/dialects/sqlite.html](https://docs.sqlalchemy.org/en/13/dialects/sqlite.html).

We recommend using the builtin `sqlite3` module that comes with python. This requires no additional setup.

## Configurations

In the API configurations, the following configurations need to be set:

- `SQLALCHEMY_DATABASE_URI = 'sqlite:///<filepath>`  
  Needs to be set to create SQLite database.
- Also, check the other configurations that may be required as described in
  [API - Configurations > SQLAlchemy section](/technology/installation/configuration-setup/api/)