Skip to content

Instantly share code, notes, and snippets.

@sirmews
Forked from streamich/lambda.js
Created November 19, 2020 04:31
Show Gist options
  • Save sirmews/10a5b6fa5f725df74ec103f51730297d to your computer and use it in GitHub Desktop.
Save sirmews/10a5b6fa5f725df74ec103f51730297d to your computer and use it in GitHub Desktop.
using node-postgres (`pg`) in AWS Lambda
import λ from "apex.js";
import { Pool } from "pg";
// connection details inherited from environment
const pool = new Pool({
max: 1,
min: 0,
idleTimeoutMillis: 120000,
connectionTimeoutMillis: 10000
});
export default function λ(async (event, context) => {
// https://github.com/brianc/node-postgres/issues/930#issuecomment-230362178
context.callbackWaitsForEmptyEventLoop = false; // !important to reuse pool
const client = await pool.connect();
try {
await client.query("SELECT NOW()");
} finally {
// https://github.com/brianc/node-postgres/issues/1180#issuecomment-270589769
client.release(true);
}
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment