#database
61 snippets tagged with #database
Prisma Find with Relations
Query related records using Prisma ORM include and select for efficient nested data loading.
Best for: Loading user profiles with posts
Cursor-Based Pagination API
Implement cursor-based pagination with forward/backward navigation, consistent ordering, and link headers.
Best for: REST API pagination
Data Caching with unstable_cache
Cache database queries and expensive computations with unstable_cache for server-side memoization.
Best for: database query caching
View - Technique 1
Create and manage database views
Best for: database operations
Index - Technique 2
Create and optimize database indexes
Best for: database operations
Trigger - Technique 3
Create triggers for automatic actions
Best for: database operations
Procedure - Technique 4
Create stored procedures
Best for: database operations
Function - Technique 5
Create user-defined functions
Best for: database operations
Cursor - Technique 6
Work with database cursors
Best for: database operations
Transaction - Technique 7
Manage database transactions
Best for: database operations
Lock - Technique 8
Handle database locking
Best for: database operations
Constraint - Technique 9
Add database constraints
Best for: database operations
Sequence - Technique 10
Create and use sequences
Best for: database operations
Partition - Technique 11
Partition large tables
Best for: database operations
JSON - Technique 12
Work with JSON data
Best for: database operations
XML - Technique 13
Parse XML data
Best for: database operations
Date - Technique 14
Handle date functions
Best for: database operations
String - Technique 15
String manipulation functions
Best for: database operations
Math - Technique 16
Mathematical functions
Best for: database operations
Window - Technique 17
Advanced window functions
Best for: database operations
Subquery - Technique 18
Use subqueries
Best for: database operations
Join - Technique 19
Advanced join techniques
Best for: database operations
Aggregate - Technique 20
Aggregate functions
Best for: database operations
Window Analytics - Technique 21
Advanced analytics
Best for: database operations
Materialized View - Technique 22
Materialized views
Best for: database operations
Composite Index - Technique 23
Multi-column indexes
Best for: database operations
Full Text Search - Technique 24
Full text indexing
Best for: database operations
Explain Plan - Technique 25
Query execution plans
Best for: database operations
Deadlock - Technique 26
Handle deadlocks
Best for: database operations
Replication - Technique 27
Database replication
Best for: database operations
Backup - Technique 28
Database backups
Best for: database operations
Restore - Technique 29
Database restoration
Best for: database operations
Archive - Technique 30
Data archiving
Best for: database operations
Vacuum - Technique 31
Database maintenance
Best for: database operations
Analyze - Technique 32
Query analysis
Best for: database operations
Statistics - Technique 33
Table statistics
Best for: database operations
Cluster - Technique 34
Data clustering
Best for: database operations
Sharding - Technique 35
Database sharding
Best for: database operations
Partitioning Strategy - Technique 36
Partitioning patterns
Best for: database operations
Denormalization - Technique 37
Denormalization patterns
Best for: database operations
Normalization - Technique 38
Database normalization
Best for: database operations
ETL Pipeline - Technique 39
Extract Transform Load
Best for: database operations
Data Warehouse - Technique 40
Data warehouse design
Best for: database operations
Recursive CTE - Technique 41
Recursive query traversal
Best for: database operations
Upsert - Technique 42
Insert or update rows
Best for: database operations
Merge - Technique 43
Merge source into target
Best for: database operations
Pivot - Technique 44
Pivot row values into columns
Best for: database operations
Unpivot - Technique 45
Unpivot columns into rows
Best for: database operations
Query Hint - Technique 46
Use optimizer hints
Best for: database operations
GRANT - Technique 47
Grant roles and privileges
Best for: database operations
RLS - Technique 48
Row level security policies
Best for: database operations
Audit - Technique 49
Track data mutations
Best for: database operations
CTE - Technique 50
Reusable query blocks
Best for: database operations
PostgreSQL Docker Setup with Init Script
Docker Compose for PostgreSQL with volume persistence, init scripts, and connection pooling.
Best for: Local PostgreSQL for development
Docker Compose — PostgreSQL Dev Environment
Full Docker Compose setup for PostgreSQL with pgAdmin, init scripts, volumes, and health checks.
Best for: Local database development environment
Database Sync Script in Python
Sync data between two databases with upsert logic, batch processing, and change detection.
Best for: Replicating data between databases
JPA Entity Mapping with Relationships
Map entities with JPA annotations: OneToMany, ManyToOne, ManyToMany with fetch strategies and cascading.
Best for: Database schema design with JPA entities
Spring Data JPA — Custom Queries
Write custom JPA queries with @Query, derived methods, Specifications, and native SQL for complex lookups.
Best for: Complex database queries in Spring applications
Spring Data JPA with Kotlin
Build data layers with Spring Data JPA in Kotlin: entities, repositories, queries, and pagination.
Best for: CRUD operations with Spring Data
Database Access with Doobie
Query databases with Doobie: SQL interpolation, type-safe queries, transactions, and streaming.
Best for: Type-safe database queries
Database Queries with Slick
Write type-safe database queries with Slick: table definitions, CRUD, joins, and streaming.
Best for: Type-safe database access