Working with two libraries / or other approach

Software darktable
24

That is the most straight forward way, yes.

You can also change the location of images using the collect images module: Moving folders in the database - #2 by Pascal_Obry