🔧 Simple Factory, Factory Method, Abstract Factory — Which One Do You Need?

The Problem


You're building a system that supports multiple databases — MySQL, PostgreSQL, MongoDB. Different services in your application need to create database-specific objects — queries, transactions, updators.

The naive approach? Let each service decide which object to create:



from abc import ABC, abstractmethod

class Database(ABC):
...