Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage


What is the first approach to creating apps on Confluence ?

Our team members need to manage some internal information and we created a standard relational database schema to represent the data structure. 

We need to deploy this model in a DBMS and make a frontend that we would like to be integrated to our On-Premise Confluence/Jira site.

We need this system to be SQL based or at least be capable of extrating the entire database content to migrate it into some other non Atlassian system in the future. (Possibly)  
So the relational structure must be SQL compliant.

Is there one standard generic way to approach this ?

Thanks !

1 answer

0 votes

Start at

One word of caution on the database side - your app is free to do whatever you want with the databases it needs to access, but do not use SQL to touch the Confluence database.  Use the internal API to read/write Confluence, or you will find yourself with horrible performance killing read SQL queries, and if you were to attempt to write to its data, a broken Confluence, possibly irretrievably.

Everything seams to be very "Frontend" oriented... Almost nothing about the data management layer of the plugins... And we do not need to touch any of the Confluence related data or data structures... Our application could even be made into a completely separated DBMS. 

And again, we must implement the relational model we created in such a way that if one day we need to migrate into a new DBMS like SQL Server or MySQL, will be able to export the data and the relations... (We have NtoN relations, One-to-Many, etc)

Apps for Confluence are generally about adding functions to it, so there's a heavy focus on working with Confluence.

You can do whatever you want in your code though.  Reading and writing a separate database is absolutely fine, but there's no reason for the Confluence docs to talk about that, as it's nothing to do with Confluence.  You'll want to read docs for the language you are using to write the app ( I would recommend writing apps in something the Confluence system already supports so you don't have to include entire coding language support in your app)

As you are reading and writing data outside Confluence and want to be able to port it, you will need to write export and import methods in your code (and I'd recommend thinking about upgrades too)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

463 views 24 9
Join discussion

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