Add a .env file based on .env.sample
PG_URLfor storing dashboard configurationsSERVER_PORTfor setting the port number for the api server. Defaults to31200CORS_ALLOW_ORIGINfor configuring cors. separate multiple origins by;. Defaults tohttp://localhostSECRET_KEYfor encrypting and decrypting passwords used in datasource configurationsENABLE_AUTHWhether to add authentication and authorization to routes. 0 = disabled, 1 = enabledENABLE_QUERY_PARSERWhether to enable Server-Side Query parsing. 0 = disabled, 1 = enabledSUPER_ADMIN_PASSWORDThe password which will be configured for the superadmin account during migration. Must be configured before migration is run. If value is not set, password will be 'secret'DATABASE_CONNECTION_TIMEOUT_MSfor configuration the time after which the db connection will timeout in milliseconds. Default is 30000ms (30 seconds)DATABASE_POOL_SIZEfor configuration the maximum number of clients in the poolSQL_REWRITER_URLfor configurating the endpoint for the sql rewriter plugin
Variables for configuring preset ApiKeys. Separate values with ; ex: PRESET_API_KEY_NAME=name1;name2;name3
-
PRESET_API_KEY_NAME=Pre-configured apikey name -
PRESET_APP_IDPre-configured apikey app_id -
PRESET_APP_SECRETPre-configured apikey app_secret -
PRESET_ROLE_ID=Pre-configured apikey role_id -
PRESET_DASHBOARDS_REPOgit repository where the preset dashboards will be downloaded from -
EXPRESS_REQUEST_MAX_SIZEmaximum request size for the express server. Default is 1mb
Test database connections
END_2_END_TEST_PG_URLe2e test postgres connection URLINTEGRATION_TEST_PG_URLintegration test postgres connection URL
Frontend logo and favicon configurations
WEBSITE_LOGO_URL_ZHlogo url ChineseWEBSITE_LOGO_URL_ENlogo url EnglishWEBSITE_LOGO_JUMP_URLlogo jump urlWEBSITE_FAVICON_URLfavicon url
yarn installyarn migration:runwill setup necessary database tables. UsesPG_URLyarn dev