Results for “pattern”

Production patterns and non-obvious traps for Prisma ORM in TypeScript backends, covering schema design, query optimization, transactions, pagination, and serverless connection handling.

Provides JPA/Hibernate patterns for Spring Boot data modeling, including entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and connection pooling.

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance patterns.

Provides ClickHouse schema design, query optimization, and data ingestion patterns for high-performance analytical workloads.

Provides ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Quick reference for PostgreSQL best practices covering indexing, schema design, query optimization, and security defaults.

Performs comprehensive SQL code review across all major databases, analyzing security, performance, maintainability, and anti-patterns.

Provides ClickHouse-specific patterns for schema design, query optimization, data ingestion, and analytics, including materialized views and performance monitoring.

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Quick reference for PostgreSQL best practices covering query optimization, schema design, indexing, Row Level Security, and connection pooling.

Plan and execute safe Convex schema and data migrations using the widen-migrate-narrow pattern and the @convex-dev/migrations component.

Manage Amazon Aurora DSQL clusters, schemas, and migrations with MCP tools and CLI scripts, including multi-tenant patterns and IAM-based authentication.

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

Provides best practices for using MariaDB's built-in vector support for AI workloads, including SQL syntax for vector columns, indexes, distance functions, and RAG patterns.

Manage Cloudflare D1 SQLite databases and KV key-value stores with setup commands, TypeScript usage patterns, and a decision matrix for choosing between them.

Quick reference for Redis best practices across common backend use cases, including caching strategies, rate limiting, distributed locks, pub/sub, streams, and connection management.

Review PostgreSQL code for best practices, anti-patterns, and quality standards including JSONB, arrays, custom types, schema design, functions, and security features like Row Level Security.

Scans US equities for daily +20%/-20% movers, classifies catalysts and chart context, updates forward outcomes, and summarizes cohort patterns for research.

Points developers to the canonical WordPress Presence API sources and explains its ephemeral-table-plus-TTL architectural pattern, so they avoid inventing postmeta-based presence implementations.

Explains the Financial Services Cloud data model, covering managed-package and Core FSC object structures, household relationships, financial account ownership, and the rollup framework, with SOQL query patterns.

Build production-grade Azure Cosmos DB NoSQL services with Python/FastAPI, including client setup with dual authentication, service layer CRUD operations, partition key strategies, parameterized queries, and TDD patterns.

Guides OLTP database schema design through six stages: domain and access patterns, entities and relationships, keys and constraints, normalization trade-offs, indexing and performance, and operations and evolution. Includes a final review checklist and tips for effective guidance.