Mastering transactions with Knex.js and Objection.js

Add Postgres transactions in a Node.js application with Knex.js and Objection.js avoiding the pitfalls.

Mastering transactions with Knex.js and Objection.js April 13, 2021 🥐 4 min read Photo by Holly Stratton on Unsplash This article is also available in: Français Add Postgres transactions in a Node.js application with Knex.js and Objection.js avoiding the pitfalls. Transactions symbolize a unit of work that allows a group of requests to be processed in isolation. They do two things: Consistency : if one of the transaction requests fails, the transaction is invalidated. Isolation : if a piece of data used in a transaction changes during it, the transaction is invalidated. In the age of serverle

related reading

• SQL Query Builder for Javascriptknexjs.org
• DBMS Musings: It’s Time to Move on from Two Phase Commitdbmsmusings.blogspot.com
• Understanding IndexedDB. The complete guide.blog.xnim.me
• GitHub - jorzel/concurrency-control: In this repo I would like to show 4 strategies of concurrency control for writing data using Python SQLAlchemy ORM and PostgresSQL (however this examples could be easily transformed to plain SQL).github.com
• TypeScript Structured Concurrencythecandidstartup.org
• PostgreSQL rocks, except when it blocks: Understanding locks - Citus Datacitusdata.com
• Bulletproof node.js project architecture 🛡️softwareontheroad.com
• The startup's Postgres survival guidehatchet.run
• Tao of Node - Design, Architecture & Best Practices | Alex Kondovalexkondov.com
• How to write a production-ready Node and Express appfreecodecamp.org
• Nine ways to shoot yourself in the foot with PostgreSQLphilbooth.me
• you won't forget how postgres works after thisyoutube.com