Vue.js + Node.js + Express + PostgreSQL example: Build a full-stack CRUD Application

In this tutorial, I will show you how to build full-stack (Vue.js + Node.js + Express + PostgreSQL) example with a CRUD Application. The back-end server uses Node.js + Express for REST APIs, front-end side is a Vue client with Vue Router and axios.

More Practice: Node.js Express + Vue.js: JWT Authentication & Authorization example

Run both projects (back-end & front-end) in one place:
How to serve/combine Vue App with Express

Serverless with Firebase:
Vue Firebase Realtime Database: CRUD example
Vue Firestore: Build a CRUD App example

Read More

Export PostgreSQL data to CSV file using Node.js

Previous tutorial shows you how to use Node.js to import CSV data into a PostgreSQL Database table. Today we’re gonna do the opposite: Export PostgreSQL data to CSV file. There are 2 steps:

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

Rest API: Node.js Download CSV file example
Dockerize: Docker Compose Nodejs and Postgres example

Read More

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