Pakiet npm – postgres

import postgres from 'postgres'

const sql = postgres({

  username: process.env.POSTGRES_USER,
  password: process.env.POSTGRES_PASSWORD,
  host:     process.env.POSTGRES_HOST,
  port:     parseInt(process.env.POSTGRES_PORT || '5432'),
  database: process.env.POSTGRES_DATABASE,
 })

// lub za pomocą URL
const sql = postgres(process.env.POSTGRES_URL!, { ssl: 'require' });


// .env.local
POSTGRES_URL="postgres://<dbuser>:<dbpassword>@localhost:5432/<database>"

export default sql

// users.js
import sql from './db.js'

async function getUsersOver(age) {

const users = await sql`select name, age
                        from users
                        where age > ${age}
                       `
// users = Result [{ name: "Walter", age: 80 }, { name: 'Murray', age: 68 }, ...]
return users
}


async function addUser({ name, age }) {

const users = await sql`
                     insert into users
                                (name, age)
                            values
                                ( ${name}, ${age} )
                      returning name, age
                     `
// users = Result [{ name: "Murray", age: 68 }]
return users[0]
}