Go CLI SQL Storage

Treat *sql.DB as a long-lived pool owned by the composition root. Keep SQL, driver behavior, migrations, and sensitive connection details inside adapters.

Core Workflow

1. Choose the database and driver from workload, platform, and distribution needs.
2. Define domain operations and transaction ownership before repository methods.
3. Open and configure one long-lived pool at the composition root.
4. Verify required startup connectivity with a bounded PingContext.
5. Apply versioned migrations using an explicit serialization policy.
6. Implement parameterized queries and map driver errors to stable domain errors.
7. Test consumers with fakes and adapters with the real driver and production schema.
8. Build the final artifact and smoke-test database initialization.

Read Next