Add a PostgreSQL Database to a Node.js App on Light Cloud

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/add-postgres-to-nodejs-app

Add PostgreSQL to a Node.js app on Light Cloud: create the database, connect with node-postgres using DATABASE_URL with ?sslmode=require&uselibpqcompat=true, deploy, and save a note.

Level: Beginner · Time: about 15 minutes · Plan: Lite · Stack: Node.js, Express, PostgreSQL, node-postgres

Steps

• Step 1: Create the database
• Step 2: Add the SSL ending
• Step 3: Connect from Node.js
• Step 4: Deploy with DATABASEURL
• Step 5: Save a note

Source code: https://github.com/light-cloud-com/tutorial-nodejs-api-postgres

---

Questions, problems with a step, or a screen that no longer matches the console? Reply here. Every tutorial is re-run on the live platform before it is published, and this thread is where fixes get discussed.