0.0.26 • Published 2 years ago

@sqltags/pg v0.0.26

Weekly downloads
-
License
MIT
Repository
github
Last release
2 years ago

Build status npm version

SqlTags PostgreSQL driver

This is the PostgreSQL driver for the @sqltags/core library.

Please refer to the @sqltags/core project README for more information.

What is SqlTags?

🔧✨ Safely create & execute parameterized SQL queries using template strings.

const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;

Results in the following query:

SELECT * FROM users WHERE id = $1
-- with parameters: [123]

Installation & Usage

Install:

npm install @sqltags/core @sqltags/pg

Create & connect a PostgreSQL Client or Pool instance, then create a SQL tag using the connection:

import { Client } from 'pg';
import { createPgTag } from '@sqltags/pg';

const client = new Client({
  /* ... */
});
await client.connect();
const sql = createPgTag(client);
import { Pool } from 'pg';
import { createPgTag } from '@sqltags/pg';

const pool = new Pool({
  /* ... */
});
const sql = createPgTag(pool);

Query:

const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;

Don't forget to disconnect your client when finished!

await client.end();
0.0.26

2 years ago

0.0.25

2 years ago

0.0.23

2 years ago

0.0.24

2 years ago

0.0.20

2 years ago

0.0.22

2 years ago

0.0.18

2 years ago

0.0.19

2 years ago

0.0.13

2 years ago

0.0.14

2 years ago

0.0.15

2 years ago

0.0.12

2 years ago

0.0.11

2 years ago

0.0.10

2 years ago

0.0.9

2 years ago