I am learning how to set up a node server with express routing, and mysql for the database. (Am I leaving laravel?!?)
Everything was running smoothly until I started to set up the database configuration. I do not want the sensitive info like passwords, etc in my version control … that stuff is secret you know. So I installed npm dotenv, and tested how to work it. It seemed simple enough, using the process.env.yourVariableName.
The problem cane when I set up sequelize. I used the cli, and that very nicely set things up for me. It set up a config.json in a config directory. But the json format could not use the process.env.yourVariableName. I did a lot of rooting around and trying the different suggestions that I found.
Finally, I found a good suggestion on their site near the bottom. after combing the docs, I found you could use a config.json file or alternatively a config.js file. The cli automatically installs the config.json. I removed it and used config.js in this format:
const dotenv = require('dotenv').config();
module.exports = {
development: {
database: process.env.DB_NAME,
username: process.env.DB_USERNAME,
password: process.env.DB_PASSWORD,
host: process.env.DB_HOST,
port: process.env.DB_PORT,
dialect: 'mysql',
},
}
And having set up my dotenv variables correspondingly, the whole thing jus tmgically worked!!
Now I feel so safe about using it all. And in fact, the sequelize documents were, while not the best ever, quite good and easy enough to use when you become a bit more familiar with them. I rather feel confortable now after about twenty minutes getting warmed up to their docs.