Hey,
yes, that is a good question!
I just discovered Affinity Photo and purchased it. Until now my workflow is/was,
- Ingesting with Photo Mechanic 5 (PM5) or tethered with Capture One pro 9 (COP9)
- Raw converter and 'enhancements' with COP9 in session mode
- Media pro 1.5 for "DAM" of the various external hard drives (archives).
For the current work in progress I rely on memory which session contains what image set I'm not done with - not the best solution but as I'm just a hobbyist it works. If I get lost I have picasa to quickly browse my hard drive and find a picture to work on (I restricted it to only stay current with my pictures folder where all my current images are stored).
I too am curious to see what Affinity will be able to come up with in that department and hope they DON'T try to integrate it with AP and or AD - compatible yes but please not in one program...lol.
Meanwhile I ran across a software called 'Photo supreme' http://www.idimager.com/WP/?page_id=20-which I'm on a 30 day trial.
I like it. However, it is VERY picky and strictly adheres to the xmp protocol for metadata handling giving me some trouble with my existing metadata as other software apparently is - let's say a bit more loose in its implementation.
Very flexible and powerful DAM if you are willing to spent the time and effort to learn and commit to it as a sole metadata handler! As with all programs, one has to first let your head wrap around its requirements and than use it as intended - thats my hope at least.
So, I'm quite busy in 2 new avenues ( Affinity Photo for pixel editing and Photo Supreme to get a bit more organization into my messy collection of images).
Oh, and to answer your question about AP integration into the workflow, for me there are two possible points of integration,
a-) after COP9 to modify an image that can't be done with COP9 and
b-) parallel to COP9 as raw developer and editor depending what your intentions with certain image are.
Cheers, and I hope that helps a bit...
Franz