Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,325
Community Members
 
Community Events
165
Community Groups

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.

1 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.

Fadoua Community Leader Jun 20, 2022

@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

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you