Which design pattern shoud be used for creating a single database object?

I know I can use the singleton pattern but that's being called the anti-pattern because of testability and other reasons.

Having said that... which pattern should be used for creating a single database connection? Also, I've been searching the web and haven't found any answers. Can you tell me which search keywords you used to find the answer?