Document running a basic hello world on heroku

[brianc]

No description provided.

[caub]

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?

[mariusa]

Hopefully connection-string support won't require another module.

[caub]

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)

[charmander]

https://node-postgres.com/features/connecting#connection-uri

[caub]

ahh! nice, I'll test that, thanks