node-contacts

Databases in Node

This example uses pg to connect to a DigitalOcean PostgreSQL database, with support for JSONB (see the favorites column in the dataset).

1. Import the dataset if necessary
2. Pass your database credentials in environment variables. To look up your DigitalOcean Database connection details, see the examples README. You have two options:
   1. Pass in the whole connection string in the DATABASE_URL environment variable. Note that you will need to set ?ssl=true instead of ?sslmode=require
   2. Pass in each component separately in their own environment variables like so:
      • DB_HOST—Server hostname
      • DB_PORT—Server port
      • DB_USER—Username
      • DB_PASSWORD—Password
      • DB_DATABASE—Database
      • DB_SSL—Use SSL? true/false
   • The DATABASE_URL variable will be preferred over any others.
3. Start the server: node index.js
4. View the app at http://localhost:3000