BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

2096Database wire protocols
2097Driver connection strings
2098Node-postgres Pool
2099Node-postgres parameterized queries
2100Node-postgres transaction clients
2101Psycopg connections
2102Psycopg parameter binding
2103Psycopg row factories
2104Python sqlite3 module
2105JDBC connections
2106JDBC PreparedStatement
2107JDBC batch operations
2108Go database/sql
2109Go sql.Tx
2110Rust SQLx
2111Rust tokio-postgres
2112.NET Npgsql
2113Client-side connection pooling
2114Pool sizing
2115Connection acquisition timeouts
2116Connection idle timeouts
2117Connection lifetime limits
2118Connection leak detection
2119Transaction context propagation
2120Cancellation propagation
2121Retry budgets
2122Idempotency tokens
2123Database circuit breakers
2124Server-side cursors
2125Streaming large query results
2126Active Record pattern
2127Data Mapper pattern
2128Unit of Work pattern
2129Identity map
2130Lazy loading
2131Eager loading
2132N+1 detection
2133Prisma schema
2134Prisma migrations
2135Prisma transactions
2136Drizzle schemas
2137Drizzle SQL expressions
2138Knex query builder
2139SQLAlchemy Core
2140SQLAlchemy ORM sessions
2141SQLAlchemy relationships
2142Django models
2143Django QuerySets
2144Django select_related and prefetch_related
2145Hibernate mappings
2146Hibernate persistence context
2147Entity Framework Core migrations
2148ORM optimistic locking
2149ORM raw SQL escape hatches
2150ORM query logging
2151Repository pattern trade-offs
2152Database types in application types
2153Mapping decimal values safely
2154Mapping timestamps safely
2155Mapping bigint to JavaScript
2156Versioned migrations
2157Repeatable migrations
2158Migration ordering
2159Migration checksums
2160Migration locks
2161Forward-only migrations
2162Down migration risks
2163Flyway
2164Liquibase
2165Alembic
2166dbmate
2167Sqitch
2168Transactional migrations
2169Nontransactional migrations
2170Database seeding
2171Deterministic fixtures
2172Synthetic test data
2173Testcontainers
2174Ephemeral test databases
2175Transactional test rollback
2176Parallel test database isolation
2177Contract tests for schemas
2178Testing constraints
2179Testing stored procedures
2180Testing concurrent transactions
2181Testing migrations against snapshots
2182Golden query result tests
2183Property-based database tests
2184Database fuzz testing
2185Production-like test statistics
2186Shared-table tenancy
2187Schema-per-tenant tenancy
2188Database-per-tenant tenancy
2189Tenant-aware unique constraints
2190Tenant-aware foreign keys
2191Tenant routing
2192Tenant migration orchestration
2193Tenant data export
2194Tenant deletion
2195Noisy neighbor mitigation
2196Cross-tenant reporting
2197Transactional outbox
2198Inbox deduplication
2199Saga orchestration
2200Saga choreography
2201Distributed transaction trade-offs
2202Database-per-service boundaries
2203Shared database anti-pattern
2204API pagination cursors
2205ETags and row versions
2206Audit context propagation
2207Inventory service implementation project
2208Multi-tenant invoicing implementation project

Databases & SQL

2096Database wire protocols
2097Driver connection strings
2098Node-postgres Pool
2099Node-postgres parameterized queries
2100Node-postgres transaction clients
2101Psycopg connections
2102Psycopg parameter binding
2103Psycopg row factories
2104Python sqlite3 module
2105JDBC connections
2106JDBC PreparedStatement
2107JDBC batch operations
2108Go database/sql
2109Go sql.Tx
2110Rust SQLx
2111Rust tokio-postgres
2112.NET Npgsql
2113Client-side connection pooling
2114Pool sizing
2115Connection acquisition timeouts
2116Connection idle timeouts
2117Connection lifetime limits
2118Connection leak detection
2119Transaction context propagation
2120Cancellation propagation
2121Retry budgets
2122Idempotency tokens
2123Database circuit breakers
2124Server-side cursors
2125Streaming large query results
2126Active Record pattern
2127Data Mapper pattern
2128Unit of Work pattern
2129Identity map
2130Lazy loading
2131Eager loading
2132N+1 detection
2133Prisma schema
2134Prisma migrations
2135Prisma transactions
2136Drizzle schemas
2137Drizzle SQL expressions
2138Knex query builder
2139SQLAlchemy Core
2140SQLAlchemy ORM sessions
2141SQLAlchemy relationships
2142Django models
2143Django QuerySets
2144Django select_related and prefetch_related
2145Hibernate mappings
2146Hibernate persistence context
2147Entity Framework Core migrations
2148ORM optimistic locking
2149ORM raw SQL escape hatches
2150ORM query logging
2151Repository pattern trade-offs
2152Database types in application types
2153Mapping decimal values safely
2154Mapping timestamps safely
2155Mapping bigint to JavaScript
2156Versioned migrations
2157Repeatable migrations
2158Migration ordering
2159Migration checksums
2160Migration locks
2161Forward-only migrations
2162Down migration risks
2163Flyway
2164Liquibase
2165Alembic
2166dbmate
2167Sqitch
2168Transactional migrations
2169Nontransactional migrations
2170Database seeding
2171Deterministic fixtures
2172Synthetic test data
2173Testcontainers
2174Ephemeral test databases
2175Transactional test rollback
2176Parallel test database isolation
2177Contract tests for schemas
2178Testing constraints
2179Testing stored procedures
2180Testing concurrent transactions
2181Testing migrations against snapshots
2182Golden query result tests
2183Property-based database tests
2184Database fuzz testing
2185Production-like test statistics
2186Shared-table tenancy
2187Schema-per-tenant tenancy
2188Database-per-tenant tenancy
2189Tenant-aware unique constraints
2190Tenant-aware foreign keys
2191Tenant routing
2192Tenant migration orchestration
2193Tenant data export
2194Tenant deletion
2195Noisy neighbor mitigation
2196Cross-tenant reporting
2197Transactional outbox
2198Inbox deduplication
2199Saga orchestration
2200Saga choreography
2201Distributed transaction trade-offs
2202Database-per-service boundaries
2203Shared database anti-pattern
2204API pagination cursors
2205ETags and row versions
2206Audit context propagation
2207Inventory service implementation project
2208Multi-tenant invoicing implementation project

← Databases & SQL

Search the Databases & SQL glossary

Lesson 2178 of 2,478·26. Databases in ApplicationsFree lesson

Testing constraints

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy