Postgres.js

<StepHikeCompact.Details title="Install">

Install Postgres.js and related dependencies.

</StepHikeCompact.Details>

<StepHikeCompact.Code>

 ```shell
 npm i postgres
 ```

</StepHikeCompact.Code>

<StepHikeCompact.Details title="Connect">

Create a `db.js` file with the connection details.

To get your connection details, go to the [**Connect** panel](/dashboard/project/_?showConnect=true). Choose [**Transaction pooler**](/dashboard/project/_?showConnect=true&method=transaction) if you're on a platform with transient connections, such as a serverless function, and [**Session pooler**](/dashboard/project/_?showConnect=true&method=session) if you have a long-lived connection. Copy the URI and save it as the environment variable `DATABASE_URL`.

</StepHikeCompact.Details>

<StepHikeCompact.Code>

```ts
// db.js
import postgres from 'postgres'

const connectionString = process.env.DATABASE_URL
const sql = postgres(connectionString)

export default sql
```

</StepHikeCompact.Code>

<StepHikeCompact.Details title="Execute commands">

Use the connection to execute commands.

</StepHikeCompact.Details>

<StepHikeCompact.Code>

```ts
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
}
```

</StepHikeCompact.Code>