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