Darktable creates a .xmp file with the metadata next to each photo.

I believe this format is also supported by Lightroom and other tools. I prefer this approach because you can keep your originals untouched.