database path autoresolve and general improvements