databases
Practical resources about databases for software engineers.
99 results
Storing, Querying, and Scaling Data
Databases are the persistence layer every application depends on. Choosing between relational and NoSQL, designing indexes, handling migrations, and optimizing slow queries are skills that directly impact user experience and infrastructure cost.
This section covers recipes for PostgreSQL and MySQL connections, MongoDB CRUD operations, Redis caching strategies, and schema design patterns. You will also find guides on ACID transactions, connection pooling, and full-text search implementation.
Cursor-Based Pagination with PostgreSQL
Implement efficient cursor-based pagination for large datasets in PostgreSQL, avoiding OFFSET...
Cache Database Query Results with Redis and Python
Cache expensive database query results in Redis with cache-aside pattern, TTL management, and...
Configure Caffeine Cache in Java with Eviction Policies
Set up Caffeine cache in a Java application with size-based, time-based, and weighted eviction...
Cache Database Queries with Django Cache Framework
Use Django's built-in cache framework with per-view caching, template fragment caching, and...
UUID Generation in Python, JavaScript, and Java
Generate universally unique identifiers (UUIDs) for database keys, session tokens, and resource...
UUID Generation: v4, v7, and ULID Comparison
Compare UUID v4, v7, ULID, and nanoid for generating unique identifiers with different tradeoffs in...
Implement ACID Transactions in PostgreSQL
How to use PostgreSQL transactions to ensure Atomicity, Consistency, Isolation, and Durability for...
Caching with Redis
How to implement application caching using Redis for performance and scalability.
Connect to PostgreSQL
How to connect to PostgreSQL databases in Python, JavaScript, and Java.
Connect to Redis
How to connect to Redis and perform basic operations in Python, JavaScript, and Java.
Database Connection Pooling
Configure and tune database connection pools to maximize throughput while preventing connection...
Handle Database Deadlocks and Retries
Detect, prevent, and recover from database deadlocks with automatic retry logic, consistent lock...
Manage Database Migrations Safely
How to version, apply, and rollback database schema changes using migration tools like Flyway,...
Database Migrations Safely
How to run database schema migrations without downtime or data loss.
Set Up Database Read Replicas for Scaling
Scale read-heavy workloads with database read replicas, replication lag monitoring, and read/write...
Database Replication
Set up and manage database replication for high availability, read scaling, and disaster recovery...
Database Transactions
How to use ACID transactions to ensure data integrity across Python, JavaScript, and Java with SQL...
Create and Use Database Views and Materialized Views
How to create and use database views and materialized views to simplify queries and improve read...
Prevent and Resolve Deadlocks in SQL Transactions
Identify deadlock patterns in SQL databases, apply consistent lock ordering, use appropriate...
No results found.