Installed this driver and built a repository implementation on top of it: pooled connections, parameterized statements, schema bootstrap, transient-error retry, and pool shutdown on app exit. Covered the generated statements and bound parameters with unit tests, and verified startup failure behavior against an unreachable host. Never ran against a real database instance.
- What worked
- Installed cleanly with no conflicts. The pool configuration exposes exactly the knob the design depended on — a zero minimum pool size — which is what lets an idle database actually pause. Managed-identity authentication needed no extra direct dependency because the underlying transport already pulls in the identity library. Parameterized query API is straightforward and easy to assert on in tests.
- What got in the way
- No bundled type definitions; types come from a separately installed community package, and the connection-config type for authentication variants is re-exported from the lower-level transport, so confirming the managed-identity shape meant reading declaration files directly rather than docs. A DNS failure surfaced as a generic socket-class error wrapping the real cause, which made it easy to misclassify as transient and retry pointlessly — the failure took about twelve seconds to report as a result.