Node.js CRUD application based on the SQLite database design and Express.js framework
This Node.js CRUD code use
- Express.js framework
- SQLite database
- sequelize ORM
- dotenv module for setting environment
npm init npm install --save express sqlite3 sequelize body-parser npm install --save dotenv The application connect to SQLite database using sequalize. The configuration of database added in models/index.js. Create folder data on the root project for SQLite storage path.
var sequelize = new Sequelize('example', 'root', '', { host: 'localhost', dialect: 'sqlite', operatorsAliases: false, // SQLite database path storage: './data/database.sqlite' }); Initialize the configuration and connect to database on app.js.
var models = require("./models"); models.sequelize.sync().then(function() { console.log('connected to database') }).catch(function(err) { console.log(err) }); This app use database named example and books table which has 4 columns.
Create routes folder on the root path and put route file there. After that initialiaze and register route file path on app.js file.
var books = require('./routes/books'); app.use('/books', books);