DEV Community

丁久 profile picture

丁久

404 bio not found

Joined Joined on 
Caching Strategies and Patterns in Distributed Systems

Caching Strategies and Patterns in Distributed Systems

Comments
3 min read
Wide-Column Databases: Cassandra, HBase, ScyllaDB

Wide-Column Databases: Cassandra, HBase, ScyllaDB

Comments
3 min read
NewSQL Databases: Combining SQL with Horizontal Scaling

NewSQL Databases: Combining SQL with Horizontal Scaling

Comments
3 min read
Key-Value Stores: Redis, DynamoDB, LevelDB, RocksDB

Key-Value Stores: Redis, DynamoDB, LevelDB, RocksDB

Comments
3 min read
Document Databases: MongoDB, CouchDB, Firestore

Document Databases: MongoDB, CouchDB, Firestore

Comments
3 min read
PostgreSQL Vacuuming: Maintenance, Tuning, and Automation

PostgreSQL Vacuuming: Maintenance, Tuning, and Automation

Comments
3 min read
Slow Query Optimization: Analysis, Indexing, and Rewriting

Slow Query Optimization: Analysis, Indexing, and Rewriting

Comments
3 min read
Database Schema Migration: Version Control, Rollback, and Zero-Downtime

Database Schema Migration: Version Control, Rollback, and Zero-Downtime

Comments
3 min read
Database Query Profiling: Finding and Fixing Performance Bottlenecks

Database Query Profiling: Finding and Fixing Performance Bottlenecks

Comments
2 min read
Database Pagination: Offset, Cursor, Keyset, and Seek Methods

Database Pagination: Offset, Cursor, Keyset, and Seek Methods

Comments
3 min read
Database Migration Version Control Strategies

Database Migration Version Control Strategies

Comments
3 min read
Database Locking: Row Locks, Table Locks, and Deadlock Prevention

Database Locking: Row Locks, Table Locks, and Deadlock Prevention

Comments
3 min read
B-Tree, Hash, GiST, GIN: Index Type Selection Guide

B-Tree, Hash, GiST, GIN: Index Type Selection Guide

Comments
3 min read
Database Horizontal Scaling Strategies

Database Horizontal Scaling Strategies

Comments
3 min read
Foreign Key Constraints: Referential Integrity in Practice

Foreign Key Constraints: Referential Integrity in Practice

Comments
2 min read
Database Consistency Levels Explained

Database Consistency Levels Explained

Comments
3 min read
Connection Pooling: Tuning, Best Practices, and Pitfalls

Connection Pooling: Tuning, Best Practices, and Pitfalls

Comments
3 min read
Columnar Storage: Compression, Encoding, and Analytical Performance

Columnar Storage: Compression, Encoding, and Analytical Performance

Comments
3 min read
Change Data Capture: Tracking Database Changes in Real-Time

Change Data Capture: Tracking Database Changes in Real-Time

Comments 1
2 min read
Database Backup Strategies to Object Storage

Database Backup Strategies to Object Storage

Comments
3 min read
Database Auditing: Tracking Data Changes

Database Auditing: Tracking Data Changes

Comments
3 min read
Database Audit Triggers: Automatic Change Tracking

Database Audit Triggers: Automatic Change Tracking

Comments 1
2 min read
Blob Storage: S3, GCS, Azure Blob, MinIO

Blob Storage: S3, GCS, Azure Blob, MinIO

Comments
3 min read
SQL vs NoSQL in 2026

SQL vs NoSQL in 2026

Comments
3 min read
Redis Caching Patterns

Redis Caching Patterns

Comments
2 min read
Partitioning vs Sharding

Partitioning vs Sharding

Comments 1
2 min read
ORM Performance

ORM Performance

Comments
3 min read
NoSQL Databases Guide

NoSQL Databases Guide

Comments
2 min read
Materialized Views

Materialized Views

Comments
2 min read
Database Security Hardening

Database Security Hardening

Comments
2 min read
Database Scalability

Database Scalability

Comments
2 min read
Database Caching

Database Caching

Comments
2 min read
Database Triggers: Use Cases, Performance Costs, and Alternatives

Database Triggers: Use Cases, Performance Costs, and Alternatives

Comments
3 min read
Time-Series with PostgreSQL: TimescaleDB, Hypertables, and Aggregates

Time-Series with PostgreSQL: TimescaleDB, Hypertables, and Aggregates

Comments
2 min read
Stored Procedures vs Functions: When to Use, Languages, Security

Stored Procedures vs Functions: When to Use, Languages, Security

Comments
3 min read
Schema Design Patterns: Normalization, Denormalization, Naming Conventions

Schema Design Patterns: Normalization, Denormalization, Naming Conventions

Comments
2 min read
Read Replicas: Scaling Reads, Replication Lag, and Failover

Read Replicas: Scaling Reads, Replication Lag, and Failover

Comments 1
3 min read
Query Parameterization: Bind Parameters, Prepared Statements, and SQL Injection

Query Parameterization: Bind Parameters, Prepared Statements, and SQL Injection

Comments 1
2 min read
EXPLAIN ANALYZE Deep Dive: Reading Plans, Cost Estimation, and Scan Types

EXPLAIN ANALYZE Deep Dive: Reading Plans, Cost Estimation, and Scan Types

Comments 1
3 min read
Multi-Master Replication: Conflict Resolution, CRDTs, Galera, and BDR

Multi-Master Replication: Conflict Resolution, CRDTs, Galera, and BDR

Comments 1
2 min read
JSON in PostgreSQL: JSONB vs JSON, Indexing, and Operations

JSON in PostgreSQL: JSONB vs JSON, Indexing, and Operations

Comments
2 min read
Database Index Types: B-tree, Hash, GiST, GIN, SP-GiST, BRIN

Database Index Types: B-tree, Hash, GiST, GIN, SP-GiST, BRIN

Comments
3 min read
Index Maintenance: Bloat, Rebuild, Reindex, and Fillfactor Tuning

Index Maintenance: Bloat, Rebuild, Reindex, and Fillfactor Tuning

Comments
2 min read
Graph Queries in SQL: Recursive CTEs, Adjacency Lists, and WITH RECURSIVE

Graph Queries in SQL: Recursive CTEs, Adjacency Lists, and WITH RECURSIVE

Comments
3 min read
Geospatial Data with PostGIS: Geometry, Geography, and Spatial Queries

Geospatial Data with PostGIS: Geometry, Geography, and Spatial Queries

Comments
3 min read
Full-Text Search in PostgreSQL: tsvector, tsquery, GIN Indexes

Full-Text Search in PostgreSQL: tsvector, tsquery, GIN Indexes

Comments
2 min read
DynamoDB vs Cassandra: Data Model, Consistency, Scaling, and Cost

DynamoDB vs Cassandra: Data Model, Consistency, Scaling, and Cost

Comments
3 min read
Database Views: Simple, Materialized, and Updateable Views

Database Views: Simple, Materialized, and Updateable Views

Comments
3 min read
Database Types Overview: Relational, Document, Key-Value, Graph, Time-Series, Vector

Database Types Overview: Relational, Document, Key-Value, Graph, Time-Series, Vector

Comments
3 min read
Database Transactions Deep Dive: ACID, Isolation Levels, Savepoints

Database Transactions Deep Dive: ACID, Isolation Levels, Savepoints

Comments 1
2 min read
Slow Query Troubleshooting: Identification, Profiling, and Optimization

Slow Query Troubleshooting: Identification, Profiling, and Optimization

Comments
2 min read
Database Table Partitioning: Range, List, Hash

Database Table Partitioning: Range, List, Hash

Comments
3 min read
Database Migration Tools: Alembic, Flyway, Liquibase, Versioning

Database Migration Tools: Alembic, Flyway, Liquibase, Versioning

Comments
3 min read
Database Disaster Recovery: RPO, RTO, Cross-Region Replication

Database Disaster Recovery: RPO, RTO, Cross-Region Replication

Comments
2 min read
Database Design Patterns: Repository, Unit of Work, Query Objects, Table Inheritance

Database Design Patterns: Repository, Unit of Work, Query Objects, Table Inheritance

Comments
3 min read
Database Cost Optimization: Instance Sizing, Reserved Instances, Storage Tiering

Database Cost Optimization: Instance Sizing, Reserved Instances, Storage Tiering

Comments
3 min read
Databases in Containers: StatefulSets, Persistent Volumes, and Backup

Databases in Containers: StatefulSets, Persistent Volumes, and Backup

Comments
2 min read
Database Concurrency Control: MVCC, Locking, and Deadlocks

Database Concurrency Control: MVCC, Locking, and Deadlocks

Comments
2 min read
Database Compression: Page-Level, Tuple-Level, Columnar, and TOAST

Database Compression: Page-Level, Tuple-Level, Columnar, and TOAST

Comments
3 min read
Couchbase Guide: N1QL, Document Model, Clustering, and Caching

Couchbase Guide: N1QL, Document Model, Clustering, and Caching

Comments
2 min read
loading...