The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

45 canonical articlesBrowse the complete archive

Popular Searches

Architecture Articles

← Clear filter

Showing 9 of 45 articles

PostgreSQL Logical Replication: Setup, Use Cases, and Limitations

Configure PostgreSQL logical replication for selective table sync, zero-downtime upgrades, and multi-tenant setups

PostgreSQL9 minNov 8, 2022
Read

Redis Use Cases: Caching, Rate Limiting, Pub/Sub, Queues, and Session Storage

A practical guide to Redis use cases in production — cache-aside pattern, sliding window rate limiting, Pub/Sub vs Streams, BRPOP queues with delayed job scheduling, and session storage with persistence configuration.

Redis12 minOct 4, 2022
Read

Apache Kafka for Database Engineers: A Practical Introduction

Understand Kafka from a database perspective — partitions, offsets, consumer groups, and durability guarantees

Kafka11 minSep 28, 2022
Read

Database Connection Pooling: PgBouncer, ProxySQL, and HikariCP Compared

A comprehensive guide to database connection pooling — comparing PgBouncer, ProxySQL, and HikariCP with configuration examples, pool mode trade-offs, and production sizing recommendations.

PostgreSQL12 minSep 27, 2022
Read

The Ultimate Guide to Choosing the Right Database for Your Application

Navigate the complex landscape of database technologies. Compare SQL vs NoSQL, OLTP vs OLAP, and learn decision frameworks for selecting the perfect database for your use case.

16 minMay 31, 2022
Read

DynamoDB Streams and Lambda: Event-Driven Database Patterns

Process DynamoDB Streams with Lambda for change data capture, cross-region replication, and event sourcing

AWS11 minMay 24, 2022
Read

Partitioning and Sharding Techniques for Database Scalability

Master horizontal and vertical partitioning, plus database sharding strategies for handling billions of records. Learn partition pruning, shard key selection, and cross-shard query optimization.

10 minApr 12, 2022
Read

FoundationDB: The Ordered Key-Value Store Powering Apple and Snowflake

Understand FoundationDB's architecture — ACID transactions, layers, and why Snowflake and Apple chose it

11 minFeb 8, 2022
Read

Battle of Memory Allocators: A Deep Dive

Discover how jemalloc, tcmalloc, and mimalloc can dramatically improve MySQL memory management. Real benchmarks showing 2-4x performance improvements and memory leak prevention.

10 minJan 18, 2022
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed