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

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

Architecture – Upload Download CSV Files to MySQL PostgreSQL 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

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