supabase/node-postgres
PostgreSQL client for node.js.
https://skillcdn.ai/gh/supabase/node-postgresConnect this address to your AI to use these skills. How to connect
- Unverified
- Default branch
master - Commit
a8a369c - License
MIT
Explore this repository
Searches the original text of skills and documents; display translations are not searched.
Documents
- _meta.jsdocs/pages/features/_meta.js
- Callbacksasync / await is the preferred way to write async code these days with node, but callbacks are supported in the pg module and the pg-pool module. To use them, pass a callback function as the last arg…docs/pages/features/callbacks.mdx
- Connectingnode-postgres uses the same environment variables as libpq and psql to connect to a PostgreSQL server. Both individual clients & pools will use these environment variables. Here's a tiny program conn…docs/pages/features/connecting.mdx
- ESMAs of v8.15.x node-postgres supporters the ECMAScript Module (ESM) format. This means you can use import statements instead of require or import pg from 'pg'.docs/pages/features/esm.mdx
- Native BindingsNative bindings between node.js & libpq are provided by the node-pg-native package. node-postgres can consume this package & use the native bindings to access the PostgreSQL server while giving you t…docs/pages/features/native.mdx
- Poolingimport { Alert } from '/components/alert.tsx' import { Info } from '/components/info.tsx'docs/pages/features/pooling.mdx
- QueriesFor the sake of brevity I am using the client.query method instead of the pool.query method - both methods support the same API. In fact, pool.query delegates directly to client.query internally.docs/pages/features/queries.mdx
- SSLnode-postgres supports TLS/SSL connections to your PostgreSQL server as long as the server is configured to support it. When instantiating a pool or a client you can provide an ssl property on the co…docs/pages/features/ssl.mdx
- Transactionsimport { Alert } from '/components/alert.tsx'docs/pages/features/transactions.mdx
- Data Typesimport { Alert } from '/components/alert.tsx'docs/pages/features/types.mdx