Question 1

How do I use pg-promise with async/await?

Accepted Answer

pg-promise fully supports ES7 async/await syntax, as shown in examples under Tasks and Transactions. You can wrap callback functions in async methods for cleaner, promise-based code without manual promise chaining.

Question 2

pg-promise vs knex.js: which should I choose?

Accepted Answer

pg-promise is better for developers who prefer writing raw SQL with built-in safety and automatic management, while knex.js is a query builder that generates SQL. Choose pg-promise if SQL injection prevention and transaction control are priorities over abstracted query building.

Question 3

How to prevent SQL injection in pg-promise?

Accepted Answer

Use the library's query-formatting engine with named parameters (e.g., ${name}) or index variables, which auto-escape values. Avoid raw text filters for user inputs, as emphasized in the formatting sections to maintain security.

Question 4

Can pg-promise handle nested transactions with savepoints?

Accepted Answer

Yes, it supports nested transactions using PostgreSQL savepoints, automatically managing names like sp_x_y. However, note that PostgreSQL doesn't offer full atomic nested transactions, only partial rollbacks as mentioned in the Limitations subsection.

Question 5

How to separate SQL queries into external files with pg-promise?

Accepted Answer

Use the QueryFile class to load SQL from files, with options for minification and auto-reloading. This approach keeps JavaScript code clean and allows for easier SQL maintenance, as detailed in the Query Files section.

Question 6

What are tasks and when should I use them?

Accepted Answer

Tasks provide a shared connection context for executing multiple queries efficiently. Use them whenever you need to chain queries or avoid connection misuse, such as in complex operations, as explained in the Tasks section to prevent performance issues.

Question 7

Is pg-promise suitable for large-scale applications?

Accepted Answer

Yes, features like connection pooling, automatic transactions, and query optimization make it scalable. However, the initial learning curve and API complexity might slow down onboarding for large teams.

pg-promise

What is pg-promise?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions