Database Inquiry for Jira and Confluence

I was looking for clarification on how the database for Confluence and Jira handles attachments. Since attachments do not live in the database, how are they associated with Jira issues and how are they associated with Confluence pages?

After reading up, it seems like there is a table for the name of the attachment, the issue ID or page ID, but is there a third table that links it all together?

 

Thank you,

Robert

2 answers

1 votes

Stock answer:  Do not think about it.  Atlassian use databases as data stores, not real databases, and using SQL is for complicated bug fixes, and a handful of queries where the UI is weak.  Most of the time, using SQL is, quite simply, wrong.

Whatever you think you need to do here, doing it with the database is almost certainly the wrong approach.

But, that advice does dodge a real answer.  You are right in saying that there is a table which stores page id and attachment path.  There are tables in both applications, but the structure varies a lot by version and application.  (Believe me, one of my squad's current projects is Confluence 5.1 -> 6.4, so far, attachments are in 4 different places...)

Rather than try to write an essay on where things might be, could you tell us what you are trying to do with this information (and maybe why)?

Hey Nic,

I appreciate the reply and feedback.  It turns out Atlassian had the answer all along, just had to do a bit more searching.

https://confluence.atlassian.com/jirakb/jira-unable-to-find-attachments-269984254.html?_ga=2.197973551.1816097316.1511285105-1410674850.1511285105

Thanks again,

Rob

Ah, that's one of the times database access is the right thing - when fixing stuff!

My response was mainly based on just how horribly wrong everything goes when people try to use the database for reporting or, a million times worse, updates.

Glad you managed to find it, it is pretty obscure!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,081 views 13 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot