Setup metabase jar to use SQLite DB

Get Help
#1

Hi everyone.
I have a task to setup standalone metabase jar to use SQLite database.
Currently I have the following configuration that uses PostgreSQL (windows batch file):
run.bat
@echo off
cls
set MB_DB_TYPE=postgres // -> sqlite?
set MB_DB_DBNAME=metabase // -> /path/to/my/metabase.db ?
set MB_DB_HOST=localhost // -> ? |
set MB_DB_PORT=5432 // -> ? | do I need all those parameters at all ?
set MB_DB_USER=postgres // -> ? |
set MB_DB_PASS=1111 // -> ? |
set MB_JETTY_SSL=true
set MB_JETTY_SSL_PORT=3003
set MB_JETTY_SSL_KEYSTORE=keystore.pfx
set MB_JETTY_SSL_KEYSTORE_PASSWORD=keystore_pass
rem set MB_JETTY_REQUEST_HEADER_SIZE=9223372036854775807
set MB_JETTY_REQUEST_HEADER_SIZE=262140
java -jar metabase.jar > log.txt

The question is how do I change this file to use existing sqlite db file?

I am using metabase 0.36.1

Thanks in advance!

#2

Hi @buckelieg
Currently only H2 (default), Postgres and MySQL/MariaDB is supported as the application database.
https://www.metabase.com/docs/latest/operations-guide/configuring-application-database.html
It is highly recommended to use Postgres or MySQL/MariaDB if you’re running Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
Latest release is 0.38.0.1

#3

Thanks, @flamber!