Skip to content

Instantly share code, notes, and snippets.

@viktorfa
Created August 14, 2020 14:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save viktorfa/476ab5d7bdd2f69c82ee3bf5faa09c6d to your computer and use it in GitHub Desktop.
Save viktorfa/476ab5d7bdd2f69c82ee3bf5faa09c6d to your computer and use it in GitHub Desktop.
Database config in Strapi.
// config/database.js
const getDatabaseConfig = ({ env }) => {
if (
env("IS_OFFLINE", null) === "true" ||
env("LAMBDA_RUNTIME_DIR", null) === null
) {
return {
connector: "bookshelf",
settings: {
client: "sqlite",
filename: env("DATABASE_FILENAME", ".tmp/data.db"),
},
options: {
useNullAsDefault: true,
},
};
} else {
// In Lambda on AWS
return {
connector: "bookshelf",
settings: {
client: "mysql",
database: env("DATABASE_NAME", "DBName"),
host: env("DATABASE_HOST"),
port: env("DATABASE_PORT", "3306"),
username: env("DATABASE_NAME", "DBUsername"),
password: env("DATABASE_NAME", "DBPassword"),
},
options: {
useNullAsDefault: true,
},
};
}
};
module.exports = ({ env }) => ({
defaultConnection: "default",
connections: {
default: getDatabaseConfig({ env }),
},
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment