Blog
Explore the articles
Practical guides to .NET, databases and distributed systems. Newest articles first.
Showing 13–19 of 19 articles about Databases.
Composite Database Indexes: Why Column Order Matters
Read articleSQL vs NoSQL: Choosing a Database for a Social Media App
Read articleHow to Choose a Database Shard Key and Avoid Hotspots
Read articleCursor vs Offset Pagination: Designing Fast APIs for Large Datasets
Read articleOptimistic vs Pessimistic Locking: Preventing Lost Updates with Practical Examples
Read articleHow Reddit Stores Posts and Nested Comment Threads
Learn how Reddit's published comment architecture connects PostgreSQL, caching and change events, with practical examples of threads, votes and moderation.