nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Have a question about server and database implementation

Mia Paulin

@mention Good afternoon all! I hope everyone enojyed their weekend. Happy Monday. I have a question about the language a servwer app is supposed to be written in. Most servers are coded in php, which is the language I want to use. Yet, in that Atlassian documentation, it's saying it's coded in Java. This is really going to sound stupid, but if I code it in php, will it still be compatible? Also, in the documention, I saw the fields that make up- not a table- and entire database. The schema is about enough for not even a whole dataset. It's as though there are 5 different types of values that are actual fields taht are expected to be an entire database instead of a table. Granted, I do have examples to pat schemas to look at, but I was wondering...Never mind. I'll use the past schemas, but if it's coded in php instead of Java, will it make a difference?

Accepted answers

All comments

Mia Paulin

Also, aside from Sql Server DB and Oracle, are there any other database engines taht anyome can recommend?

Nic Brough -Adaptavist-

Why the "@ mention" in your posts? You do know it is spamming someone who probably doesn't want to hear it?

This is a stream of questions about development in general, but I'll frame the answers for Atlassian stuff because we are in an Atlassian Community!

>>> have a question about the language a servwer app is supposed to be written in. Most servers are coded in php, which is the language I want to use.

Most servers are not coded in PHP, and certainly, very few are coded in just PHP. They often make use of many languages, frameworks, and technologies. Even when you find one that is primarily coded in PHP, you'll find it still makes use of at least Javascript, and usually good piles of CSS and HTML.

>>>Yet, in that Atlassian documentation, it's saying it's coded in Java.

Yes, Jira and the other Atlassian applications are written in Java, or variants

(Most of Jira Service Management used to be written in Scala, and although I've not checked in recently, I have no reason to think that might have changed).

And they also use a load of other technologies. I've written apps (they were called "plugins" at the time, to show my age) for Jira and Confluence. They all started with Java code (I later dabbled in Kotlin), and usually Velocity, HTML, CSS, and sometimes Javascript. Atlassian applications are built with a longer list than that!

When I got my paws on Scriptrunner, I started writing scripts in Java, but moved on to Groovy quite quickly. Although you can usually spot my scripts because I'm blatantly writing Groovy first and dropping back into Java when I'm not sure!

>>>This is really going to sound stupid, but if I code it in php, will it still be compatible?

Not by default, as Atlassian applications don't have any support for it in the distribution. Your app will have to implement a completely new PHP engine to run your code, or you'll have to have the server admins install PHP on the server to support it.

>>>Also, in the documention, I saw the fields that make up- not a table- and entire database. The schema is about enough for not even a whole dataset. It's as though there are 5 different types of values that are actual fields taht are expected to be an entire database instead of a table.

The Jira database is very complex, Confluence, Bitbucket, and the others less so.

But the simple advice here is "stop looking at the database".

The applications are abstracted away from the database - your code should use the application's APIs to talk to the core data, not SQL, and "active objects" if it needs to store data in the database. It can never write to the database directly either, that will simply corrupt your data.

>>>I'll use the past schemas, but if it's coded in php instead of Java, will it make a difference?

I think that's answered by "don't use PHP" and "don't look at the database directly"

>>>aside from Sql Server DB and Oracle, are there any other database engines taht anyome can recommend?

Atlassian generally support the four "big" names in databases, but not their variants (MySQL for example, but not Percona, Maria, or Drizzle)

These are in my order of preference:

Postgres. Mainly because Atlassian code and test for this first. I've never had a problem with a Postgres Atlassian system that was down to Postgres itself, once I'd got the configuration right. Plus it's effectively free.
MySQL. Also free, but only ever had character encoding problems with it (mostly config problems, but not entirely)
Oracle. Paid, and has caused me some interesting problems with encoding, indexing (mostly down to code in Jira not using the driver correctly), and sometimes fetching the wrong data when using complex AO tables.
Microsoft SQL Server. (We need to be clear on the "Microsoft" because "SQL Server" could mean any form of server that acts as a database with SQL capability). I tend to avoid it, because it's caused all sorts of problems with Atlassian servers for many years of my career. I'm told more recent versions have improved, to a point where they might push it into second place on my list, but I've not used it recently enough to confirm that.

In terms of "best", though, there is a "gnat's whisker" between the top three in my list, and maybe a "gnat's tooth" between Oracle and MS.

I recommend not thinking "best" but "best for us". If your organisation has a preferred database, use the one they prefer - don't ask your DBAs to learn all the quirks of MySQL if all the rest of their databases are MS-SQL.

What you learn about any one of them, though, you'll find the knowledge mostly transferable to others. The biggest problem I have swapping between them is when I can't remember whether I need to end a SQL query with a ; or not!

unknown

@Nic Brough -Adaptavist-Have a look at the OP's posting history. It's likely it's an AI bot, as the account has been posting contradictory or nonsense content across multiple groups and other mods have deleted it.

Nic Brough -Adaptavist-

Yeah, I know, it does look a bit "botty".

Atlassian have been asked to have a word with them, and apparently got a human response, and AI-detecting software consistently says their posts are human (I'd assumed they were too, because AI posts tend to be a bit more focussed and written in better English)

unknown

Ok, fair enough. I've seen plenty of bots inject random spelling errors to humanise their content, but if our new AI overlords are happy with their brethren, so be it.