chore: add nosec B324 annotations to non-cryptographic MD5 usages and update temporary database path to use system temp directory

Fix test failures: update hash test for MD5, handle unicode surrogates

fix: improve error handling and add comprehensive test coverage