Socket
Socket
Sign inDemoInstall

pg

Package Overview
Dependencies
Maintainers
1
Versions
224
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

pg

PostgreSQL client - pure javascript & libpq with the same API


Version published
Weekly downloads
4.8M
decreased by-20.15%
Maintainers
1
Weekly downloads
 
Created

What is pg?

The pg npm package is a PostgreSQL client for Node.js. It provides functionalities to connect to a PostgreSQL database server and execute queries, manage transactions, and listen to notifications from the database.

What are pg's main functionalities?

Connecting to a PostgreSQL database

This code sample demonstrates how to connect to a PostgreSQL database using the pg package. It includes creating a new client instance and connecting to the database with a connection string.

const { Client } = require('pg');
const client = new Client({
  connectionString: 'postgresql://user:password@localhost:5432/database'
});
client.connect();

Executing a query

This code sample shows how to execute a SQL query to select all records from a table and print the results. It also handles any potential errors and closes the connection.

client.query('SELECT * FROM my_table', (err, res) => {
  console.log(err ? err.stack : res.rows);
  client.end();
});

Using async/await for queries

This code sample uses async/await syntax to execute a query and print the results. It's a more modern approach to handling asynchronous operations in Node.js.

async function fetchData() {
  const res = await client.query('SELECT * FROM my_table');
  console.log(res.rows);
  client.end();
}
fetchData();

Managing transactions

This code sample illustrates how to manage a transaction with the pg package. It begins a transaction, attempts to insert data, commits the transaction if successful, or rolls back if an error occurs.

async function transactionExample() {
  await client.query('BEGIN');
  try {
    await client.query('INSERT INTO my_table (col) VALUES ($1)', ['data']);
    await client.query('COMMIT');
  } catch (e) {
    await client.query('ROLLBACK');
    throw e;
  }
}
transactionExample();

Listening to notifications

This code sample demonstrates how to listen for notifications from the PostgreSQL server. It sets up an event listener for 'notification' events and executes the LISTEN command to subscribe to a specific notification.

const client = new Client();
client.connect();
client.on('notification', (msg) => {
  console.log('New notification:', msg);
});
client.query('LISTEN my_notification');

Other packages similar to pg

Keywords

FAQs

Package last updated on 17 Sep 2024

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc