Skip to main content

Storages considerations

Formance abstracts storage behind a single interface, and storage plugins are responsible for implementing them in the most efficient way possible.

SQLiteโ€‹

SQLite is the default storage shipped with Formance. It is ideal for testing and single-node installations. It will use the data directory defined in config, which defaults to $HOME/.numary/data.

Postgresโ€‹

Postgres compatibility is shipped with Formance out of the box as well. It is not the default storage and can be used by updating the configuration variables storage.driver and storage.postgres.conn_string. Environments variables or file can be used.

NUMARY_STORAGE_DRIVER=postgres \
NUMARY_STORAGE_POSTGRES_CONN_STRING=postgresql://localhost/dbname \
numary server start

or use config file :

storage:
driver: postgres
postgres:
conn_string: postgresql://localhost/postgres