I had all my meta-data in one database, but it got corrupted and I lost it all.

I now prefer adobe bridge / adobe lightroom.

They update the metadata in the photo file itself. Not sure what they offer in terms of client programs.