I redesigned the entire AssetDatabase API. I wanted to be done with it. No more edge-cases, inconsistencies, guesswork, "works for me" utility methods, ...
Every Unity user has an interest in tool developers using the AssetDatabase correctly, precisely, with minimal impact and side-effects on their projects. Learn from my implementation and tests, or buy it and revel in ease of mind. 🙂
https://assetstore.unity.com/packages/tools/utilities/codesmile-assetdatabase-270771