Use of transactions

[Patrick Van der Veken]

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.

[Tinker Fadoua]

@Patrick Van der Veken Below are some helpful links:

• https://confluence.atlassian.com/doc/server-hardware-requirements-guide-30736403.html
• https://confluence.atlassian.com/doc/system-requirements-126517514.html
• https://confluence.atlassian.com/bitbucketserver/supported-platforms-776640981.html

Please make sure to select the right version at the top

[Patrick Van der Veken]

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.

[Tinker Fadoua]

@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]

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.