Posts Tagged “SQL”

  • Node Postgres Insert Multiple Rows

    You might be wondering how to insert multiple rows into a table using Node Postgres. Most examples show adding only one row at a time. Some solutions recommend using a control flow library like async. But this technique is slow and inefficient because it uses too many connections or sends the queries one by one. Other solutions recommend using a heavyweight ORM, but this might require a significant rewrite of your application.

  • How to use transactions with node postgres

    Transactions in computer programming are essential for data integrity. Transactions provide primitives for guaranteeing your query logic succeeds or fails gracefully. A transaction contains any number of statements. At any point you can rollback if an error occurs or your logic fail conditions trigger.