Database help, please

Lear,

You should not be unhappy.

You said you have Locations 1 and 2, that you want to be able to make changes in Location 1 and see them cascade to Location 2, but not vice-versa. In, e.g., 2 macs.

So you want uni-directional syncing capabilities. But you also mention changes in Location 2. I think you are aware that this means having roles, permissions and conflict management, right?

DEVONthink was not built for this, and I doubt it that any of the thousands of users ever need anything like that - this is not a collaborative design, a relational database, or a software development app.

So if these are very hard requirements for you, DEVONthink is not for you, and I am very sure you will not find any other platform for that. At least one you can afford without being a Fortune 500 company.

If the case is you don’t want a 2nd user to make changes, just have them commit to not making changes - still, if one major change happens by accident, it can potentially be reversed. Hence doing backups.

If the case IS you want a 2nd user to be able to make independent changes, then, well, what I said above.

4 Likes

And doing this kind of thing is a recipe for disaster, no? :smiling_face_with_three_hearts:

3 Likes

If the user in Location 2 is allowed to make changes while also getting updates from Location 1, it starts to look like the kind of thing software version control tools do. Completely legitimate use case, but not what DT is designed for.

(And to your point about costs, Git is free. Software is largely either plain text or encapsulated binaries, though. Not the kind of freeform data that DT manages so well.)

4 Likes

Well, he said he didn’t want changes made in Location 2 to appear in Location 1. That is not the same as “user in Location 2 is allowed to make changes while also getting updates from Location 1”

Now we’re talking branches, etc, right?

About Git - of course, free!

And of course, DT being freeform (in my old days at Informatica, we’d call it “unstructured” I guess), good luck even thinking of a platform including roles, permissions, versioning, conflickt management, locks, etc, etc.

Oh, wait, maybe AI will solve that magically!

4 Likes

Best topic ever, on any forum, and for any future.

I got my popcorn and sat down to enjoy.

P.S. I can be quite stubborn, but that beats me by any measure :sweat_smile:

1 Like

stubborn? :rofl:

1 Like

I’m glad you enjoyed the show, guy.

between you and me, some of the advice here is so badly presented I almost think it’s meant to mislead. Shocking!

One-way sync would be a cool feature, but I don’t know where someone would get the idea it’s built in.

if you want to keep a backup of a database up to date one-way, SyncThing, rsync, cp, Keyboard Maestro on a schedule could all do it. (Just a user’s opinion, not officially supported etc.)

It’s been brought up in the past. Here’s an example of how to do it without angrily flaming out.

3 Likes

Did I say one way sync?

I really meant synch. With an h.

Location 2 must be an EXACT REPLICA of Location 1

Changes in Location 2 MUST NOT CHANGE Location 1.

That is impossible. If Location 2 changes, it will no longer be an EXACT REPLICA of Location 1.

DEVONthink advertises “synchronising” - look up what that means.



By the way - this is possibly the most helpful forum filled with uniformly sound advice, anywhere. The DEVONthink team are always willing to assist, and responsive to new ideas. Browse this forum and see the many years of extraordinary support…

@BLUEFROG - you demonstrate commendable patience as always.….:grin:

14 Likes

@Lear

Clients, patients and others asking for advice in complex pro matters often (some say always) ask not what they really want, and want not what they really need. This is normal. And any professional service agent knows that. So, @BLUEFROG IS professional asking the questions on context to better assist you.

Business wisdom says that customer is always right, but to the limits of the bill paid. I think you are pretty much out of the limits behaving like you do. Who are you to talk here like this?!

10 Likes

For what it’s worth (I’d read the other thread from Lear too), I do just manually do archive backups of my databases on to an external drive (when I feel like it, but it’s supposed to be once a week). That’s in addition to Time Machine (on a different external drive), but Time Machine serves as the “safety”, I consider my manual backups the “real” backups of my databases. Manual backups work fine if you understand why you’ve made that decision.

3 Likes

I do exactly that—take archive zips—with the same priority of “when i think of it” every so often. Send to a local drive that then gets backed up like everything else with 3-2-1 regime.

2 Likes

I have a serious question for Lear:

Let’s start out with your master database in location 1, and a completely identical copy in location 2. Whenever changes happen in location 1, you would like them replicated to location 2. However, if a user makes changes in location 2, you don’t want them replicated back to location 1.

Am I correct in your requirements?

If I am, what do you envision happens in the following cases:

  1. The file “test1.pdf” is added to location 1 and replicated to location 2, and later deleted only from location 2. Is it supposed to stay deleted from that point on as other changes are made to location 1 and replicated to location 2?
  2. What happens if a user in location 2 edits “test1.pdf”? Do the edits stay in location 2 forever without being replicated back to location 1?
  3. What happens if a user adds a new file “test2.pdf” to location 2 without being replicated back to location 1, and at some point later a completely different “test2.pdf” is added to location 1? Which version of “test2.pdf” ends up in location 2?

It’s issues like this that need to be specified before any sort of solution can be suggested.

4 Likes

Your one-way sync sounds like a backup. Use File→Export→Database Archive.

That will create a zip file anywhere you want. Unzip the file and there’s a copy of your original database.

That’s scriptable, so you could automate creating the archive and unzipping it. I’d do it, but I’m slow with Applescript.

I agree that some answers here can seem abrupt. Stereotypes are cruel, but I’ve wondered if there isn’t an unintended harshness in German to English communication.

Before everyone gets mad at me for saying that, I’m half German and happy to say so. If that seems harsh, maybe I’m just a pot seeing a kettle in the mirror. It’s OK, I’ve said more embarrassing things.

Devonthink is a great resource. Customer support is fantastic.

Good luck with your workflow. I don’t see any reason you can’t get what you want.

3 Likes

You’re clearly frustrated, but taking it out on the people trying to help you isn’t acceptable. This community runs on mutual respect, and the volunteers here owe you neither their time nor their patience.

Right now, the only shocking behavior in this thread is coming from you. If you want useful answers, drop the attitude, provide clear information, and engage like someone who actually wants a solution.

Otherwise, you’re just making noise and slowing down the people who are here to help.

9 Likes

It looks as if a solution is sought to a simple problem and that solution is to be chosen to be complex.

As others have said, the simplest solution would be the best - backup your database file from place 1 to place 2. How you do this is pretty immaterial - you can get the same result from different workflows. I use Chronosync - it will make a backup from my SD drive and send it to my Drobo (I know this is now obsolete, but it currently works) and will therefore overwrite that database copy on the Drobo. Hence only changes on place 1 will be saved on the backup on location 2. Backblaze will also backup my SD database - not a synchronisation as we have been warned about many times on this forum