Write core logic for async memory database connections

[faizanazim11]

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.