Where is my query workspace stored?

Hi All,

LOVING 0xDBE, can't wait till it goes live, and I can pay for it :)

Question though.. Where are the query 'worksheets' stored?  I.e, you open a connection, and you get a nice worksheet where you can develop your queries.  Close and re-open 0xDBE, and the queries are still there, etc.   Reason I ask, is that I recently backed up my Windows PC, and installed ubuntu, then installed 0xDBE, and copied my .0xDBE folder from my windows installed in over the top.  Got all of my datasources back, but NOT the query worksheets for each datasource :(

Are they stored somewhere that I can get access to?  REALLY hoping they are, as I have quite a few months of SQL development !

Thanks,

Damien

5 comments
Comment actions Permalink

Hello.

Up to the last public build they should be in .../.0xDBE/system/userHistory/ directory. The relationship to a data source is established via internal datasource id (see the file content). Maybe your ids have been changed somehow during the transfer.

Just notice that right now our developers are moving these files to .../.0xDBE/config/consoles/ directory. And from XML to plain SQL format, by the way.

Regards,
Alexander.

0
Comment actions Permalink

Awesome! I assume the next build is getting multiple consoles then, that's fantastic news!

0
Comment actions Permalink

Thanks Alexander,

Will be able to do a quick regex to convert those back to a plain sql dump :)

Question though.  I found that I *do* have access to them in 0xDBE - but I have to click the 'Browse History' button in the console, and then can click on each query to view the query, or double-click to copy it to the console.   But previously I just saw ALL my queries on the console whenever I opened 0xDBE.  Looking in the .xml files, it looks like maybe there was a difference between the version I was running on windows, and the current 139.795.5 ?  The files from windows only have <history-entry> tags, where as on linux there are the <history-entry> tags, AND a <console-content> tag which contains the data to go into the actual console?

0
Comment actions Permalink

Hello.

New builds of 0xDBE should automatically convert console content storage to new format. But having regex is also nice.

Regarding console content: yes, it should be saved in <console-content> element. I know that from time to time in the past this element was lost. Looks like you've met the same bug. Unfortunately, we did not find a stable way to reproduce it. Now with changing the storage format this issue should become obsolete.

Regards,
Alexander.

0
Comment actions Permalink

Currently, DataGrip installation process doesn't copy the connections and consoles from previous 0xDBE installation.
In order to use previous connections and consoles you can use this commend (works for osx):
cp ~/Library/Preferences/0xDBE10/projects/default/.idea/dataSources* ~/Library/Preferences/DataGrip10/projects/default/.idea/.
cp ~/Library/Preferences/0xDBE10/jdbc-drivers/* ~/Library/Preferences/DataGrip10/jdbc-drivers/.
cp ~/Library/Preferences/0xDBE10/consoles/db/* ~/Library/Preferences/DataGrip10/consoles/db/.

0

Please sign in to leave a comment.