Hi,

I’m planning to have two separate installations of Tracks (desktop + laptop) which I’d like to keep in sync. I will be using Tracks 1.6 on Linux, with SQLite and the included WEBrick server locally on both machines. I know that I can export the YAML file to bounce data back and forth, but I’d like a more streamlined solution that I can just forget about.  I’d just like to run a manual sync when the two machines are connected on the same LAN, not involving any internet connection. Or ideally, I’d like the two Tracks installations to get in sync whenever my laptop is connected to my home network.

What would be a suitable method for this use case?

Thanks in advance

Well, you could just copy the sqlite database file back and forth between the machines. I’m currently using MySQL dump to keep me synced between work and home. It’s not as slick as it could be, but it does the trick.

Just get a USB key, and you can tell tracks to use the same database between the two machines, depending on where the USB key is located.

Hope this helps!

Seconding what Craig said, I would use just one SQLite db which is accessible to both machines, and point both at that db. Note that I haven’t tried this, so I don’t know if you might get problems with sessions. Let us know how you get on!

I haven’t had a problem with the sessions between the machines, but I’d caution using SQLite with two machines accessing it at the same time. If you’re planning to do that, I’d recommend using MySQL or PostgreSQL.

Thanks everyone for the replies. I’m aware that I can theoretically just carry the database around as a simple solution, but how about if I make some changes in the desktop installation, and then another set of changes in the laptop installation, and want to merge the two together so that both will be retained? Since I will want to be able to capture tasks at maximum speed, having to make sure that I have the latest state of the database on whichever installation I’m working at any given moment will slow me down, and be an inconvenience that may defeat the purpose of having a system at all.

(Note: I don’t want to keep anything on a remote server, due to privacy concerns. I have to keep all my data local.)