I want to create a small command/function that visits the node (there is a small set of nodes I visit all the time and I don’t want to use org-roam-node-find any more). I can open the file, but I thought that the node-id will be better, in case I move the file (and also, puts the point at the beginning of the node).
Thought the built-in org-id-open would be enough for your purpose, though it does not use DB. Some reason to prefer DB to the built-in way (with a list in a file)?
I use syncthing to sync all my files from computer to computer. The IDs in org-cache seems to be updated only when the files are opened in the computer where the cache exists.
In contrast, I run org-roam-db-sync daily (or when a file does not seem to be found). So I trust org-roam’s db more than org’s cache.
I don’t really know if this is an issue, in part because I never understood org’s cache (the documentation on it is not very good).