Databases
Flowise supports 3 database types:
SQLite
MySQL
PostgreSQL
SQLite will be the default database. These databases can be configured with following env variables:
SQLite
A database.sqlite
file will be created and saved in the path specified by DATABASE_PATH
. If not specified, the default store path will be in your home directory -> .flowise
MySQL
PostgreSQL
If none of the env variables is specified, SQLite will be the fallback database choice.
Synchronize in Production
Flowise uses Typeorm to configure database connection. By default, synchronize is set to true. This indicates if database schema should be auto created on every application launch.
However, we have to be careful with this option and don't use this in production - otherwise you can lose production data. This option is useful during debug and development.
To override the value, set the following env variable
Tutorial: How to use Flowise databases SQLite and MySQL/MariaDB
Last updated