Home → Suggestions →

Symbolic Linking to SQlite Database

• Edit

Julian Quintana

18 Jan, 2012 03:45 PM

I've attempted to create a symbolic link to the SQlite DB found in Application Support, with the hopes of moving the DB to my dropbox folder. Dropbox seems to be causing a permissions error that is inhibiting this. Has anyone successfully moved the DB and do you know if the developers are planning on implementing this feature in order to use the same DB across several computers.

1. Support Staff 1 Posted by drewmccormack on 19 Jan, 2012 10:58 AM

   

   Hi Julian,
   We have plans to add iCloud syncing in the coming months.
   If you do want to try the link, and you should definitely make sure you have a good backup if you do, then

   1) Move the folder ~/Library/Application/Mental Case/Library.mentalcase2lib to your Dropbox
   2) Link to the folder from the original location. In Terminal type this

   ln -s <path-to-folder-in-dropbox> ~/Library/Application/Mental Case/Library.mentalcase2lib

   The path in dropbox could be something like this

   ~/Dropbox/Library.mentalcase2lib

   And I repeat: please make a good backup, because Dropbox syncing is not really supported, and there is some risk of data corruption, especially if the app is run simultaneously on two devices.

   Hope that helps.
   Kind regards,
   Drew

   • Edit

2. 2 Posted by Doug Stetar on 14 Mar, 2012 01:54 AM

   

   I've been attempting to implement the dropbox support as you outlined. However, I keep getting a second Data.sqlite file begin created with a name something like:
   Data.(Laptop's conflicted copy 2012-3-13).sqlite. Any thoughts?

   • Edit

3. Support Staff 3 Posted by drewmccormack on 14 Mar, 2012 07:11 AM

   

   Hi Doug,
   It is a risky business, because you can end up with a corrupt database.
   You must not run the app on two machines at once. If dropbox sees that the same file changed on two different machines, it will consider the files in conflict, and it then makes a copy of the older one in case you want to use that one. That is the extra file you are seeing.
   We are working on iCloud syncing now. If you would like to be in on the beta testing let me know. Probably not too long until we start testing.
   Kind regards,
   Drew

   • Edit

4. 4 Posted by Doug Stetar on 14 Mar, 2012 10:21 PM

   

   Drew,

   I would very much like to be in on the beta testing. My situation is such that I really need to sync between two macs (not to mention an iPad & iPhone). I use all of these regularly in learning Mandarin.

   ciao
   doug
   ------------------------------------------------------------
   Doug Stetar, MFA
   Chair, Media Studies Department
   Director, Media Research Lab
   Vancouver Island University
   250.740.6145
   [email blocked]
   ------------------------------------------------------------

   • Edit

5. Support Staff 5 Posted by drewmccormack on 15 Mar, 2012 07:42 AM

   

   We'll let you know if we have something. Things aren't going so good with iCloud testing, so don't know exactly when that will be.

   Drew

   • Edit