Database export options
Posted: Thu Apr 14, 2022 1:25 pm
It would be good to have an option to create a copy of the XnView.db file for export, to another computer.
Where you can change choose which folders in the database, to include in the exported file (with the option to exclude specific sub-folders), and rename their paths, to the path that they have in the other computer. (I've tried to find a SQLite-tool, to do a search-and-replace of the file paths …but couldn't find a search-and-replace option. I found some option that replaces text, but it required me to specify something I didn't know anything about and… Well, TLDR: I failed)
This would be especially good, if one is directly connected to the computer, and the program can use that connection to let you browse the other computer and specify which folders on it, are equivalent to the folders on the local computer. (and let the program change the file-paths, to the path on the other computer)
Naturally, that would require it to interpret stuff like "smb://[computername]/c$/", and "/run/user/1000/gvfs/smb-share:server=[computername],share=c$/", and the like, and understand what the filepath would be called, on that computer. (this wouldn't really be an issue with windows-to-windows connections)
With *nix-to-*nix connections, as well as non-root shares (which would be most shares, I suppose …but my desktop computer, which is only in contact with my laptop, is safe to share the root, especially as it is password protected, anyway), I suppose one would probably still have to manually specify the local filepath of the share
…but any and all subfolders of the share, would automatically and accurately have their paths derived from that, which would still make it worth it
Doing it manually, with a database editor, is not an option for most people. (I'm a lot better with computers than most, and it's way too hard for me. Granted, I do intend to learn to use databases, and I suppose it wouldn't be that hard, once I do that, but… I'm not going to do that right away, and even when I do it will take time …and the vast majority of people, for whom this is a very desired feature [and there are many], have no intention of ever learning to use databases)
Where you can change choose which folders in the database, to include in the exported file (with the option to exclude specific sub-folders), and rename their paths, to the path that they have in the other computer. (I've tried to find a SQLite-tool, to do a search-and-replace of the file paths …but couldn't find a search-and-replace option. I found some option that replaces text, but it required me to specify something I didn't know anything about and… Well, TLDR: I failed)
This would be especially good, if one is directly connected to the computer, and the program can use that connection to let you browse the other computer and specify which folders on it, are equivalent to the folders on the local computer. (and let the program change the file-paths, to the path on the other computer)
Naturally, that would require it to interpret stuff like "smb://[computername]/c$/", and "/run/user/1000/gvfs/smb-share:server=[computername],share=c$/", and the like, and understand what the filepath would be called, on that computer. (this wouldn't really be an issue with windows-to-windows connections)
With *nix-to-*nix connections, as well as non-root shares (which would be most shares, I suppose …but my desktop computer, which is only in contact with my laptop, is safe to share the root, especially as it is password protected, anyway), I suppose one would probably still have to manually specify the local filepath of the share
…but any and all subfolders of the share, would automatically and accurately have their paths derived from that, which would still make it worth it
Doing it manually, with a database editor, is not an option for most people. (I'm a lot better with computers than most, and it's way too hard for me. Granted, I do intend to learn to use databases, and I suppose it wouldn't be that hard, once I do that, but… I'm not going to do that right away, and even when I do it will take time …and the vast majority of people, for whom this is a very desired feature [and there are many], have no intention of ever learning to use databases)