Other database

Is it possible to use external database with Youtrack? I.e.: PostgreSQL ? If not, will it be possible in future ?

8 comments
Comment actions Permalink

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.

0
Comment actions Permalink

Bernard,

Why do you want to use external database? YouTrack internal database my handle more then 100000 issues and this is not the limit...

0
Comment actions Permalink

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 ?

0
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0
Comment actions Permalink

How about info on accessing youtrack database directly ?

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.

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.

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!"

0
Comment actions Permalink

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.

0
Comment actions Permalink

Hello Ryan, sorry for the delay.

Could you please tell, which external reporting systems do you have in mind?

0

Please sign in to leave a comment.