[v4] Support Database Transactions with Knex, please

[willnode]

Feature request

Please describe your feature request

• I have created my request on the Product Board before I submitted this issue
• I have looked at all the other requests on the Product Board before I submitted this issue

Summary

Please support database transactions in v4. v3 actually supports database transactions since it is used with Bookshelf.js. v4 uses a custom database engine and I can't see how I can insert knex.js transactions in custom code.

Why is it needed?

Please read my draft article on how to use database transactions in v3, it also tells the real reason why database transactions is a must:

strapi/community-content#539

Suggested solution(s)

We can add a parameter transaction in the query engine.

strapi/packages/core/database/lib/query/query-builder.js

Line 7 in 6ee0ba1

const createQueryBuilder = (uid, db) => {

Related issue(s)/PR(s)

If there's nobody has time to implement this, will you (the Strapi team) accept PRs to this feature? This feature is so critical to me.

[Flowko]

hi @willnode, any news about this from the Strapi team ?

[willnode]

Not heard anything yet.

[copocaneta]

Thanks for the feature request and also for the article @willnode

This feature is a must when working with multiple instances of Strapi querying the same database. It's unfortunate that this is not possible on v4. Strapi Team, is there a status for this?

[derrickmehaffy]

If there's nobody has time to implement this, will you (the Strapi team) accept PRs to this feature? This feature is so critical to me.

I would absolutely say we are open to a PR on this

[willnode]

Finally an answer 👀 will try on weekend.

[derrickmehaffy]

Finally an answer eyes will try on weekend.

Sorry it's been pretty crazy with v4 🙈 lots going on

[benderillo]

@willnode how are you progressing with the PR?
I was unpleasantly surprised that V4 does not support transactions, which makes it unsuitable for multi-instance deployment which should be the only way of deployment if you do it on a cloud really.
Thank you for bringing this up! And thanks for the article on v3 transactions, it was that missing piece of information that I needed.