No, it is not possible. As you probably know, we develop youTrack using MPS. So to support that feature in future, we need to upgrade significantly our web-app development framework in MPS. Would we do that or not - depends mostly on our plans regarding this framework, not youTrack explicitly. If you could define certain requirements for youTrack which might demand support of other databases, this will be +1 argument for altering the framework.
Having data stored in database of my own choice gives me more confidence that if youtrack project gets shut down someday I will be able to migrate my data. Also backing the data up is easier when my admin has only one database engine with all my organizations' databases. Besides, what are datasources for in application servers ?
I have to agree with Bernard here, even though my organization will never need to use an external database -- other, larger enterprises I have worked for would be keen to hook it up to their already existing DB clusters (Oracle for example) ... where they have the skill set and man power to manage, migrate, optimize, etc... these DBs. Having a seperate box holding data is definately not part of the optmization process going on at many large corporations. They want to consolidate. Just my 2-cents.
How about info on accessing youtrack database directly ? Or you don't want to let us gain to much power :-D ?
I want to export data to xml to synchronize them with GanttProject. Current CSV export is poor, because we cannot choose which columns should be exported and which not. Furthermore if description consists of more than 1 line then entire CSV file is messed up.
I would appreciate this feature being added- if nothing else so that we can hook external reporting systems up to it and report against it. Our company is in the process of writing a service that exports all of our YouTrack issues to an SQL database via the REST API so that we can perform BI analysis against it. If we could access the database directly, this would be much less of a time intensive task.
Even though this feature is very useful for the maintainability of the installation in an enterprise setting it's also extremely useful in less grandiose endeavours.
For example we are having issues with projects disappearing from view possibly because we tried to configure custom settings on the project and YouTrack didn't like the changes so we're having to explicitly search by project name to find it. It would be nice to query a database to find what project are in a particular install in case it decides to hide away in the bowels of the app.
So the question is, what is Jetbrains doing to make this great tool a bit more future proof and enterprise friendly, like change the implementation to a more streamlined and standards based platform, perhaps?!
Thank you for your post. Please let me address it.
We understand your request and see why you'd like to have it work like that. As of now, though, we don't have any plans to migrate to a different database or support backward-compatible operations. If the change was worth it, then we'd definitely have done it a long time ago. However, there are a lot of technical and performance-related reasons as to why we don't consider it.
If that's not the case, then please share the additional details (where you query it, where it disappears from, and so on) about this issue with our support team. We'll examine the details and get back to you with further information. Thanks.
No, it is not possible. As you probably know, we develop youTrack using MPS. So to support that feature in future, we need to upgrade significantly our web-app development framework in MPS. Would we do that or not - depends mostly on our plans regarding this framework, not youTrack explicitly. If you could define certain requirements for youTrack which might demand support of other databases, this will be +1 argument for altering the framework.
Bernard,
Why do you want to use external database? YouTrack internal database my handle more then 100000 issues and this is not the limit...
Having data stored in database of my own choice gives me more confidence that if youtrack project gets shut down someday I will be able to migrate my data. Also backing the data up is easier when my admin has only one database engine with all my organizations' databases. Besides, what are datasources for in application servers ?
I have to agree with Bernard here, even though my organization will never need to use an external database -- other, larger enterprises I have worked for would be keen to hook it up to their already existing DB clusters (Oracle for example) ... where they have the skill set and man power to manage, migrate, optimize, etc... these DBs. Having a seperate box holding data is definately not part of the optmization process going on at many large corporations. They want to consolidate. Just my 2-cents.
So, any news in this topic ?
How about info on accessing youtrack database directly ? Or you don't want to let us gain to much power :-D ?
I want to export data to xml to synchronize them with GanttProject. Current CSV export is poor, because we cannot choose which columns should be exported and which not. Furthermore if description consists of more than 1 line then entire CSV file is messed up.
We BerkeleyDB JE without DPL, so, actually, we use BerkeleyDB as transactional
key-value store only. Database objects are mapped in a complicated manner
to records in numerous tables with two columns. So I thinks there is no any
sense to access such a database directly.
Wouldn't it be better to access YouTrack using REST?
--
Best regards,
Vyacheslav Lukianov
Software Developer
JetBrains, Inc.
http://www.jetbrains.com
"Develop with pleasure!"
I would appreciate this feature being added- if nothing else so that we can hook external reporting systems up to it and report against it. Our company is in the process of writing a service that exports all of our YouTrack issues to an SQL database via the REST API so that we can perform BI analysis against it. If we could access the database directly, this would be much less of a time intensive task.
Hello Ryan, sorry for the delay.
Could you please tell, which external reporting systems do you have in mind?
Even though this feature is very useful for the maintainability of the installation in an enterprise setting it's also extremely useful in less grandiose endeavours.
For example we are having issues with projects disappearing from view possibly because we tried to configure custom settings on the project and YouTrack didn't like the changes so we're having to explicitly search by project name to find it. It would be nice to query a database to find what project are in a particular install in case it decides to hide away in the bowels of the app.
So the question is, what is Jetbrains doing to make this great tool a bit more future proof and enterprise friendly, like change the implementation to a more streamlined and standards based platform, perhaps?!
Hi!
I'm Sergey from the Youtrack team.
Thank you for your post. Please let me address it.
We understand your request and see why you'd like to have it work like that. As of now, though, we don't have any plans to migrate to a different database or support backward-compatible operations. If the change was worth it, then we'd definitely have done it a long time ago. However, there are a lot of technical and performance-related reasons as to why we don't consider it.
As for the problem with some projects disappearing, then the most common reason would be that these projects are set as a custom project template. Please see for more details: https://www.jetbrains.com/help/youtrack/incloud/2020.5/custom-project-templates.html
If that's not the case, then please share the additional details (where you query it, where it disappears from, and so on) about this issue with our support team. We'll examine the details and get back to you with further information. Thanks.