Nodejs Express CSV Upload Download to MySQL PostgreSQL – Multer, Fast CSV, Json2Csv, Sequelize

Nodejs/Express CSV Upload Download to MySQL/PostgreSQL – Multer, Fast-CSV, Json2Csv, Sequelize

In the tutorial, I will introduce how to build a Nodejs/Express RestAPIs application to upload/import and download/extract data from multiple CSV files to MySQL or PostgreSQL database by:

• Express is used to build Nodejs RestApis
• Multer is used to upload/download CSV files
• Sequelize ORM is used to manipulate data with MySQL/PostgreSQL
• Json2csv is used to save data objects to CSV file
• fast-csv is used to parse CSV file to data objects

Architecture

We build Nodejs RestAPIs on the top of Express framework and use the Multer library to handle upload multiple CSV files. For handling the business processing of our application, We implement a Controller.js that uses fast-csv and json2csv libraries to write/read data objects to CSV files. And for doing CRUD operations with MySQL and PostgreSQL database, we use Sequelizez ORM to finalize the jobs.

Goal

All Details at: Nodejs/Express CSV Upload Download to MySQL/PostgreSQL – Multer, Fast-CSV, Json2Csv, Sequelize

Related posts:

Angular Nodejs Fullstack CRUD Application with MySQL/PostgreSQL – Angular 10-9-8 HttpClient + Nodejs Express, Sequelize ORM Build Nodejs CRUD Application with MySQL/PostgreSQL – Express RestAPIs + Ajax : Post/Get/Put/Delete Request Nodejs RestAPIs Upload Download Multiple Excel Files to MySQL/PostgreSQL – Multer, Sequelize ORM, Exceljs, Read-excel-file