@platypus I was going to respond to this when you first posted it but decided to concentrate on trying to get my new machine working and I have now got all three machines connected to all three monitors via HDMI switches, sound is reconfigured and only the keyword switch left so …!
If it is a weakness of PhotoLab then the SQLite database is also a weakness of Lightroom, Capture One, Photo Mechanic Plus, Photo Supreme, Zoner, ExifPro, IMatch, XnView and XnViewMp etc. etc. , excluding ACDSee which uses a variant of Dbase I believe, but that is “just” another database.
What singles DxPL db out for special criticism and what exactly are you criticising?
Re-indexing goes some way towards that but I will admit that if I had only navigated to 3 subfolders within a directory of 100 sub-directories and then I re-index the main directory all the sub-directories would be included!
This is easily fixed by providing an option to re-index only those directories already resident in the database @Musashi and ignore those that are not currently present. The code to include the option in the UI is far greater than the code to ignore “non-resident” directories but …!
Please (re-)enumerate those “shortcomings” for those that have not read your previous posts about DB maintenance Database Maintenance to provide some additional detail to your complaint.