What is the benefit of the Mapper pattern included here?

The Mapper pattern decouples your internal database schema from your public-facing API types, allowing you to change your database structure without breaking your API contracts.

Can I use these patterns with any ORM?

Yes, while the examples use Prisma-like syntax, the patterns are designed to be customized for Drizzle, TypeORM, or any other database library you prefer.

How does this skill help prevent N+1 queries?

It provides specific implementation patterns for batch operations using Promise.all and in-memory mapping, ensuring efficient data fetching for related entities in a single trip.

What is the Result type pattern used in this skill?

It is a functional approach to error handling where functions return a structured object indicating success or failure instead of throwing exceptions, making error handling explicit and type-safe.

Service Architecture Patterns

Name: Service Architecture Patterns
Author: JaveedIshaq

byJaveedIshaq

•

API 开发

Implements clean architecture service layers with type-safe error handling and efficient data access patterns.

关于

This skill provides a comprehensive set of templates for building robust backend service layers in TypeScript. It enforces the Result type pattern to eliminate unexpected exceptions, establishes a consistent base service with integrated logging, and provides best practices for data mapping, database transactions, and batch operations to prevent N+1 query performance issues. It is ideal for developers building scalable APIs who want to ensure maintainable, testable, and type-safe business logic that adheres to clean architecture principles.

主要功能

1 GitHub stars
Domain-driven Mapper patterns for separating database entities from domain types
Optimized data access patterns including transaction management and batch processing
Functional Result type pattern for type-safe error handling without exceptions
Ready-to-use implementation templates for ORMs like Prisma, Drizzle, and TypeORM
Standardized Base Service class with built-in logging and error context management

使用场景

Optimizing database performance by eliminating N+1 query bottlenecks in complex relationships
Building a new TypeScript backend with Clean Architecture and Domain Driven Design
Refactoring legacy catch-all error handling to a predictable Result-based flow

关于

主要功能

1 GitHub stars
Domain-driven Mapper patterns for separating database entities from domain types
Optimized data access patterns including transaction management and batch processing
Functional Result type pattern for type-safe error handling without exceptions
Ready-to-use implementation templates for ORMs like Prisma, Drizzle, and TypeORM
Standardized Base Service class with built-in logging and error context management

使用场景

Optimizing database performance by eliminating N+1 query bottlenecks in complex relationships
Building a new TypeScript backend with Clean Architecture and Domain Driven Design
Refactoring legacy catch-all error handling to a predictable Result-based flow