Document running a basic hello world on heroku #1342

Activity

1. brianc

   added this to the docs milestone on Jun 22, 2017
2. caub commented on Jun 24, 2017

   

   caub

   on Jun 24, 2017

   Last edited by caub

   Contributor

   More actions

   schema.sql

   CREATE TABLE IF NOT EXISTS hello {
     id   BIGSERIAL PRIMARY KEY;
     text TEXT DEFAULT '...';
   }

   Run heroku run "psql -U postgres -f schema.sql" --app your-app

   hello-world.js

   const {Pool} = require('pg');
   const {parse} = require('pg-connection-string');
   const dbConfig = Object.assign(parse(process.env.DATABASE_URL || 'pg://postgres@localhost/postgres'), {max: 9});
   const pool = new Pool(dbConfig);
   pool.query(`INSERT INTO hello(text) VALUES('world') RETURNING *`)
     .then(({rows}) => console.log(rows))
     .catch(console.error)

   Run heroku run "node hello-world" --app your-app
   like this?
3. mariusa commented on Jul 12, 2017

   

   mariusa

   on Jul 12, 2017

   More actions

   Hopefully connection-string support won't require another module.
4. caub commented on Jul 12, 2017

   

   caub

   on Jul 12, 2017

   Last edited by caub

   Contributor

   More actions

   I made a PR to make it simpler:

   const {Pool} = require('pg');
   const parse = require('pg-connection-string');
   
   const pool = new Pool(parse(process.env.DATABASE_URL || 'pg://postgres@localhost/postgres', {ssl:true, max: 2}));
   pool.query(`INSERT INTO hello(text) VALUES('world') RETURNING *`)
     .then(({rows}) => console.log(rows))
     .catch(console.error)

   I hope the one integrated in pg will look like it

   I'd love to do:

   const {Pool} = require('pg');
   // new Pool(opts) or new Pool(connectionString, opts)
   const pool = new Pool(process.env.DATABASE_URL || 'pg://postgres@localhost/postgres', {ssl:true, max: 2});
   pool.query(`INSERT INTO hello(text) VALUES('world') RETURNING *`)
     .then(({rows}) => console.log(rows))
     .catch(console.error)
5. charmander commented on Jul 12, 2017

   

   charmander

   on Jul 12, 2017

   Collaborator

   More actions

   https://node-postgres.com/features/connecting#connection-uri
6. caub commented on Jul 12, 2017

   

   caub

   on Jul 12, 2017

   Contributor

   More actions

   ahh! nice, I'll test that, thanks
7. charmander

   assigned

   brianc

   on Dec 5, 2019