Write core logic for async memory database connections #3

Implement the core logic necessary for supporting asynchronous operations in the memory database utilities. This should include functions to create async connections and ensure compatibility with async/await patterns. Include error handling and maintain backwards compatibility with existing sync APIs.