Use of transactions

Question

Hi,

We are using a local instance of Jira/Confluence/Bitbucket on top of a set of Postgres databases.

I am looking for confirmation that all of these products are using proper database transactions when modifying data. I am assuming so but I just need to be sure.

Regards,

Patrick.

Patrick Van der Veken_00ma4m · Answer

Hello Fadoua,

I refer to this postgres document: https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-transaction/

A database transaction consists of using a specific set of SQL commands to make database updates so that the updates are done according to the ACID rule: Atomic, Consistent, Isolated and Durable.

Tinker Fadoua · Answer

@Patrick Van der Veken

Any changes you make in Jira get automatically saved to your database. There is nothing needed from your end.

Please if you can elaborate a little more so that I can answer your question.

Best,

Fadoua

Patrick Van der Veken_00ma4m · Answer

Hi Fadoua,

Thanks for your reply. But unfortunately it does not answer my question. My question is about the specific nature of SQL code in the atlassian products, whether or not SQL updates are done via proper database transactions.