Import CSV data into PostgreSQL using Node.js

In this tutorial, we’re gonna import CSV data into PostgreSQL Database table using Node.js. There are 2 steps:

  • Reading CSV file with fs & fast-csv module
  • Connecting to PostgreSQL Database to save CSV data with pg module

Related Post: Export PostgreSQL data to CSV file using Node.js
Rest API: Node.js: Upload CSV file data into Database with Express
Dockerize: Docker Compose Nodejs and Postgres example

Read More

Export MySQL data to CSV file using Node.js

In previous tutorial, we’ve known how to use Node.js to import CSV data into MySQL Database table. Today you’re gonna look at way to do the opposite: Export MySQL data to CSV file. The process has 2 steps:

  • Read MySQL data using mysql module
  • Export MySQL data to CSV file using one of three modules: fast-csv, csv-writer or fs

Rest API: Node.js Download CSV file from MySQL Database example

Read More

React File Upload/Download example with Spring Boot Rest Api

In this tutorial, I will show you way to build React.js File Upload example with Spring Boot Rest APIs. The React App uses Axios and Multipart File for making HTTP requests, Bootstrap for progress bar. You also have a display list of files’ information (with download url).

More Fullstack Practice:
React + Spring Boot: Pagination example
Spring Boot + React: CRUD example
Spring Boot + React: JWT Authentication with Spring Security

Run both projects in one place:
How to integrate React.js with Spring Boot

Using Template Engine:
Thymeleaf + Spring Boot: File Upload example

Read More