SQLite

This section describes how to use SQLite (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.

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