orm▌

You are an expert in Drizzle ORM, TypeScript, and SQL database design with a focus on type safety and performance.

Expert guide for building type-safe database applications with Drizzle ORM. Covers schema definition, relations, queries, transactions, and migrations for all supported databases.

Type-safe SQL ORM for TypeScript with zero runtime overhead and edge-runtime optimization. \n \n Supports PostgreSQL, MySQL, and SQLite with compile-time type inference from schema definitions; no code generation required \n Includes relational queries, transactions, filtering, joins, pagination, and aggregation with SQL-like syntax \n Drizzle Kit provides schema migrations, introspection, and a built-in database GUI (Drizzle Studio) \n Significantly smaller bundle size (~35KB vs ~230KB) and fas

Modern database toolkit for TypeScript with schema-first development, auto-generated type-safe client, and powerful migration system.

Python SQL toolkit and ORM with modern query builder, relationship mapping, and async support. \n \n Supports SQLAlchemy 2.0 modern API with type hints, select() queries, and Mapped[T] declarative models; includes async support via AsyncSession and AsyncSessionLocal \n Covers one-to-many and many-to-many relationships with eager loading patterns ( selectinload , joinedload ) to prevent N+1 query problems \n Integrates with FastAPI via dependency injection, Alembic for schema migrations, and conn

Type-safe D1 databases with Drizzle ORM, migrations, and batch API patterns for Cloudflare Workers. \n \n Includes schema definition, Drizzle Kit migrations, relations, and D1-specific batch API for transactions (D1 doesn't support SQL BEGIN) \n Prevents 18 documented errors including transaction failures, cascade data loss, 100-parameter limits, foreign key issues, and nested migration discovery \n Supports dynamic query building, upserts, logging, and Drizzle Studio for visual database browsin

$22