Syncing connections between computers

[nathanpalmer]

When purchasing TablePlus this week I mistakenly assumed that connections (not including passwords or keys) would be synced between devices. I see there is a Backup and Restore function but are there any plans to add a sync. I have quite a few connections and keeping them in-sync between my desktop and laptop would same me time in trying to keep them up to date myself.

[huyphams]

Thank @nathanpalmer for the suggestion. I know syncing connection would be a nice feature but currently, I need to do export/import connection first.

If I build syncing function, I need to research encode/decode first, because connection information is very very important, I can't make any mistake when handling it. And of course, I will not include any password and key when syncing connection.

[nathanpalmer]

Ok, great. Glad it's on your mind though.

[JAStanton]

In general I see this as something that would be more of an enterprise feature. I'd love on day 1 for a new co-worker to sync connections w/ DropBox and have all everything setup including all preferences for things like "Alert Mode" / "Safe Mode" for production connections. That'd be pretty slick!

In general I could see features like this and others making sense if attention was turned to more enterprise customers: "$x per team member". Having managed users, permissions, connections, credentials etc... this would be a huge win in this space! See which team members ran which queries on which connections could be great for auditing too

[huyphams]

I have seen this feature in 1Password. it called vault. Basically, they encrypted it and put it on cloud (Dropbox, Google Drive).

[eberkund]

I sync my Filezilla credentials with Dropbox, I don't know if this would a suitable solution for TablePlus?

[huyphams]

I'm planning to use this solution, includes History and Favorite.

[rizkysyazuli]

@nathanpalmer if u use a mac or linux, i should point you to mackup. i use it to backup, restore, and sync ALL my app settings.

right now it doesn't support TablePlus yet. which is why i wanted to open a pull request there and add it. but i need to know where TablePlus stores the user settings (which is why i'm here).

maybe @huyphams can help show us where the file is?

PS: mackup uses your own dropbox/gdrive for backup. so it should be quite safe.

[huyphams]

TablePlus stores data in Application Support, just like a standard Mac app.
cd ~/Library/Application\ Support/com.tinyapp.TablePlus/

Please note that:
Make sure you are on the latest build of TablePlus. 105. If not, please update the app.

Currently:

All the passwords:
- Server password.
- Database password.
- Keyphrase password.
- Private key data (which was imported when creating a connection).
Are stored in the Keychain and not stored in this folder so it's safe.

But the connection data in this folder still include the HOSTNAME and the SERVER ADDRESS. So please DO NOT SHARE this file without knowing the risk.

[rizkysyazuli]

@huyphams understood. thx.

Anyway, the pull request is here if someone else's also using mackup.

[zhengyue]

I just moved the Data folder in ~/Library/Application\ Support/com.tinyapp.TablePlus/ to iCloud Drive, and created a link in the original place using ln -s. Now the connections are synced between all my Mac computers.

[huyphams]

if you want to sync Favorite and History you can add the folder Cache to iCloud @zhengyue

[matt-stuart]

Simply having a UI element to specify where to store the above data would be handy to move it to iCloud / Dropbox / what have you. Otherwise this works for me for now.

[kirillplatonov]

Agree. Being able to specify folder for settings would be great. For example, that's how Dash doing it:

@huyphams hopefully you will have resources to implement it anytime soon. I really like TablePlus and having sync would make usage on different machines much smoother. Thanks for your amazing work!

[huyphams]

I've it on backlog already, you guys will see it soon! I pushed some code related to it on the build 190 (if you've read the changelogs).

[ssx]

what's the status of this? if I symlink via Dropbox is the sync reliable? will it sync everything?

[bskiefer]

Checking in on this

[jannejava]

+1

[rjventrone]

+1

[rijkvanzanten]

@huyphams any updates? 🙂 You stated

you guys will see it soon!

so I'm curious to see where this was left of as that comment is about to reach it's 1 year anniversary 😄

[shaynem]

was just looking for this, it's painful to enter in all the information again into the iPad / iPhone for 20+ connections

[HansOspina]

This is a must if you pay for the iPad version and the Computer version you really expect this to happen. Please get it out soon!!

[jpike88]

Any progress?

Would be nice if it just synced with my iCloud account

[MattRiddell]

Yeah I'm looking for this too - I have an office and laptop and hate to get home and realize I forgot to copy my settings - just being able to specify ~/Documents/ as the settings location would be sufficient

[huyphams]

Hi @MattRiddell it's supported, you can change the path in the settings.

[onlime]

HI @huyphams

Hi @MattRiddell it's supported, you can change the path in the settings.

Thanks for the hint. This is very nice and works perfectly. But I still can't find this locations settings in TablePlus mobile app (iOS). So syncing to mobile via iCloud is not yet possible?

[MattRiddell]

Awesome, thanks!

[jordan-brough]

FYI there's currently a small bug with custom locations where you can't create saved queries, but there is a workaround.
See #2002.

[zieglar]

Create three folder in Dropbox and copy ~/Library/Application Support/com.tinyapp.TablePlus/{Cache,Data,Temp} three folder content, set tableplus locations to new folder, All settings are lost :(
change locations failed

[huyphams]

TablePlus will not move the old data to new folder @zieglar you have to do this by yourself by exporting and importing connections.

[acalvino4]

I can see that 'locations' tab in my table plus preferences, but it doesn't seem to have a page in the docs: https://docs.tableplus.com/preferences/general

[diegostamigni]

Why is this closed as completed?

[onlime]

Why is this closed as completed?

Probably because the solution presented by @huyphams (Settings > Locations > Connections) is a viable solution. I am using it successfully like this since 2020 with the following path in Connections:

/Users/<USER>/Library/Mobile Documents/com~apple~CloudDocs/TablePlus/Data

That's the iCloud storage location for TablePlus. At least on macOS between different macs, this works. But AFAIK sync between macOS and iOS TablePlus is not yet possible.

[leearmstrong]

Any news on being able to "sync" to iOS? Even an import!?