丁久 - DEV Community

丁久

May 18

Caching Strategies and Patterns in Distributed Systems

#architecture #systemdesign

3 min read

丁久

May 18

Wide-Column Databases: Cassandra, HBase, ScyllaDB

#database #backend #data

3 min read

丁久

May 18

NewSQL Databases: Combining SQL with Horizontal Scaling

#database #backend #data

3 min read

丁久

May 18

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

#database #backend #data

3 min read

丁久

May 18

Document Databases: MongoDB, CouchDB, Firestore

#database #backend #data

3 min read

丁久

May 18

PostgreSQL Vacuuming: Maintenance, Tuning, and Automation

#database #backend #data

3 min read

丁久

May 18

Slow Query Optimization: Analysis, Indexing, and Rewriting

#database #backend #data

3 min read

丁久

May 18

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

#database #backend #data

3 min read

丁久

May 18

Database Query Profiling: Finding and Fixing Performance Bottlenecks

#database #backend #data

2 min read

丁久

May 18

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

#database #backend #data

3 min read

丁久

May 18

Database Migration Version Control Strategies

#database #backend #data

3 min read

丁久

May 18

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

#database #backend #data

3 min read

丁久

May 17

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

#database #backend #data

3 min read

丁久

May 17

Database Horizontal Scaling Strategies

#database #backend #data

3 min read

丁久

May 17

Foreign Key Constraints: Referential Integrity in Practice

#database #backend #data

2 min read

丁久

May 17

Database Consistency Levels Explained

#database #backend #data

3 min read

丁久

May 17

Connection Pooling: Tuning, Best Practices, and Pitfalls

#database #backend #data

3 min read

丁久

May 17

Columnar Storage: Compression, Encoding, and Analytical Performance

#database #backend #data

3 min read

丁久

May 17

Change Data Capture: Tracking Database Changes in Real-Time

#database #backend #data

1

2 min read

丁久

May 17

Database Backup Strategies to Object Storage

#database #backend #data

3 min read

丁久

May 17

Database Auditing: Tracking Data Changes

#database #backend #data

3 min read

丁久

May 17

Database Audit Triggers: Automatic Change Tracking

#database #backend #data

1

2 min read

丁久

May 17

Blob Storage: S3, GCS, Azure Blob, MinIO

#database #backend #data

3 min read

丁久

May 17

SQL vs NoSQL in 2026

#database #backend #data

3 min read

丁久

May 17

Redis Caching Patterns

#database #backend #data

2 min read

丁久

May 17

Partitioning vs Sharding

#database #backend #data

1

2 min read

丁久

May 17

ORM Performance

#database #backend #data

3 min read

丁久

May 17

NoSQL Databases Guide

#database #backend #data

2 min read

丁久

May 17

Materialized Views

#database #backend #data

2 min read

丁久

May 17

Database Security Hardening

#database #backend #data

2 min read

丁久

May 17

Database Scalability

#database #backend #data

2 min read

丁久

May 17

Database Caching

#database #backend #data

2 min read

丁久

May 17

Database Triggers: Use Cases, Performance Costs, and Alternatives

#database #backend #data

3 min read

丁久

May 17

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

#database #backend #data

2 min read

丁久

May 17

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

#database #backend #data

3 min read

丁久

May 17

Schema Design Patterns: Normalization, Denormalization, Naming Conventions

#database #backend #data

2 min read

丁久

May 17

Read Replicas: Scaling Reads, Replication Lag, and Failover

#database #backend #data

1

3 min read

丁久

May 17

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

#database #backend #data

1

2 min read

丁久

May 17

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

#database #backend #data

1

3 min read

丁久

May 17

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

#database #backend #data

1

2 min read

丁久

May 17

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

#database #backend #data

2 min read

丁久

May 17

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

#database #backend #data

3 min read

丁久

May 17

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

#database #backend #data

2 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

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

#database #backend #data

2 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

Database Views: Simple, Materialized, and Updateable Views

#database #backend #data

3 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

Database Transactions Deep Dive: ACID, Isolation Levels, Savepoints

#database #backend #data

1

2 min read

丁久

May 16

Slow Query Troubleshooting: Identification, Profiling, and Optimization

#database #backend #data

2 min read

丁久

May 16

Database Table Partitioning: Range, List, Hash

#database #backend #data

3 min read

丁久

May 16

Database Migration Tools: Alembic, Flyway, Liquibase, Versioning

#database #backend #data

3 min read

丁久

May 16

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

#database #backend #data

2 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

Databases in Containers: StatefulSets, Persistent Volumes, and Backup

#database #backend #data

2 min read

丁久

May 16

Database Concurrency Control: MVCC, Locking, and Deadlocks

#database #backend #data

2 min read

丁久

May 16

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

#database #backend #data

3 min read

丁久

May 16

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

#database #backend #data

2 min read