I want to sync preferences on my different macbooks

[griiid]

I think there are 2 possible ways:

1. Is it possible to decide where the preference files to store by myself? In the new feature?
2. Let me know the current Sequal Ace preference position so I can sync them with https://github.com/lra/mackup

[Jason-Morcos]

1. Not trivially possible - sandboxing enforces the file location
2. They're stored in a container in a location chosen by the macOS Samdbox

[Jason-Morcos]

This might help - #53

[griiid]

This might help - #53

Oh, I see ~/Library/Containers/com.sequel-ace.sequel-ace/Data/Library/Application Support/Sequel Ace/Data
I'll try it, thx.

[griiid]

@Jason-Morcos It's not helped I guess.

What I really care is Query Favorites, but In ~/Library/Containers/com.sequel-ace.sequel-ace/Data/Library/Application Support/Sequel Ace/Data there's only pinnedTables.db, queryHistory.db, Favorites.plist

[Jason-Morcos]

Ohhh Query Favorites, to be honest I don't really recall where those are stored. @Sequel-Ace/all anyone else remember the location? I think they're stored in a SQLite DB IIRC (and I might be wrong on that), and I have no recollection where that's stored.

[robinkunde]

It should be in ~/Library/Containers/com.sequel-ace.sequel-ace/Data/Library/Preferences/com.sequel-ace.sequel-ace.plist. You can dump out the contents of binary plist files with plutil -p.

[robinkunde]

@griiid Does that help?

[griiid]

Sorry @robinkunde, I forgot to setup sync yesterday, need 1 more day to check.

[griiid]

Hi @robinkunde, ~/Library/Containers/com.sequel-ace.sequel-ace/Data/Library/Preferences/com.sequel-ace.sequel-ace.plist is a correct file path, however when I sync from another macbook, my Sequel Ace looks like it doesn't have preferences, maybe there are some related-to-mac data in the plist file?

Now I don't know how can I automatically sync it.
I can only export query favorites manually, and wait for new feature?

[robinkunde]

@griiid Can you confirm two things for me?

1. Are you using the AppStore version of Sequel Ace on both machines?
2. Does the file actually contain your saved queries? You can dump out a clear text version of the file on the command line plutil -p ~/Library/Containers/com.sequel-ace.sequel-ace/Data/Library/Preferences/com.sequel-ace.sequel-ace.plist

[griiid]

@robinkunde

1. Yes, I installed from AppStore, on both machines.
2. Yes.

[robinkunde]

Ok, I just tried to myself. Global Query Favorites successfully transferred. Non-global ones are bugged for me tho. So copying the file should work for transferring global favorites at least.