database-driver-design

This skill provides specialized architectural guidance for developers engineering high-performance database client libraries in Swift. It focuses on the intersection of networking, type-safe API design, and concurrency, using industry-standard patterns observed in libraries like valkey-swift and postgres-nio. The goal is to help developers move beyond simple wrappers toward robust, low-latency, and memory-safe implementations suitable for production server-side environments.

• Implementing custom wire protocol parsers and serializers to minimize latency.

• Managing connection lifecycles using explicit state machines to prevent deadlock and race conditions.

• Designing non-blocking IO (NIO) channel handlers for efficient database communication.

• Optimizing actor-to-event-loop alignment using unownedExecutor to eliminate unnecessary context switching.

• Building custom backpressure-aware streaming systems to prevent memory exhaustion during large result sets.

• Enforcing SQL injection safety through compile-time type checking and ExpressibleByStringInterpolation for parameterized queries.

• Designing command-as-type structures for improved API ergonomics and response type safety.

• Target audience: Backend engineers, infrastructure library maintainers, and Swift server-side developers.

• Typical use cases: Creating new database drivers (NoSQL or SQL), building ORM low-level protocols, or optimizing existing NIO-based database integrations.

• Required inputs: Database documentation, protocol specifications (e.g., length-prefixed binary formats), and performance targets for throughput/latency.

• Practical constraints: Always prefer type-safe patterns over string-based dynamic code. Align with Swift 6 structured concurrency and ensure all state management is Sendable. When dealing with NIO buffers, prioritize zero-copy operations and explicit memory lifecycle management.