GNOME Bugzilla – Bug 572871
Remote Access or Merging Hamster Databases
Last modified: 2009-02-23 16:49:09 UTC
An idea occurred to me because I work from multiple machines -- is there any way of merging the hamster database with others? Another possibility being able to specify sftp/ssh or similar access to a server machine with a hamster db on it. Use case: I work on my desktop and track various activities. But occasionally I'm physically away from my desktop but on work business where I might want to still track various activities. I can do this on my laptop, but upon my return I'm left with two hamster databases. How do I merge them just before I need to make some report of my time? Some commandline script may already exist to merge sqlite databases easily without a user needing to know sql or similar? Perhaps this could be included in an Import/Export fashion. So on my laptop I Export to a file (csv or whatnot) and on my desktop I Import that file to have new categories or changes merged with duplicates ignored. Another option, of course, is to move away from just sqlite to mysql or similar and then allow remote access to it. So when I change activity it contacts the mysql server to record the change of activity. If the server is not available, the default would be to store it in sqlite until the next change of activity when it would attempt again to contact the server (and if available, then put in any untransferred changes). I'm sure it has been brought up before, but I mention it because I'd like to get all my hamster data in one place. ;-) -James
*** This bug has been marked as a duplicate of 545816 ***