Sqlite files on iCloud or Dropbox

[LiamP]

in-house app on MacOS. No simultaneous access. I’m the only one using the app. And always with at least 10 minutes or more between different computers. I have a desktop app I use in my Studio but also need to access the SQLite database on my computer at home.

I seem to recall there is a potential problem with SQLite files on Dropbox. Is this true or am I save to move the db file to dropbox.

I currently use DropBox but also have an iCloud account if this is a better option.

Thanks for all your advice.

B

[Tim_Parnell]

@LiamP

I seem to recall there is a potential problem with SQLite files on Dropbox. Is this true[?]

Yes.

@LiamP

I currently use DropBox but also have an iCloud account if this is a better option.

No.

---

You have to copy the database out of the cloud sync folder, connect to it, do your stuff, disconnect, then copy the database back into the cloud sync folder. Otherwise you risk corrupting the database with all automatic cloud sync services.

[LiamP]

I thought I remembered that. thanks Tim