Search

Lessons (14)

• AWS Databases: Choose the Right One

  … managed SQL database RDS runs engines such as PostgreSQL and MySQL while AWS handles hardware, backups, and many …

• 10,000 Users Do Not Need 10,000 Database Connections

  … For connection-heavy workloads, a pooler such as PgBouncer can sit between application clients and PostgreSQL. Transaction pooling …

• What Is Software Architecture?

  … Use PostgreSQL for the orders service Status Accepted (2026-09-28) Context Orders need multi-row transactions (order …

• C4 Architecture Diagrams: Context, Container, Component and Code

  … The adapter, repository and publisher handle the details of Stripe, PostgreSQL and SQS. This makes an important design …

• Practical Project: Deploy a Real CRM App on EKS

  … Create the database (RDS PostgreSQL) The database lives in the private subnets of the cluster VPC and accepts …

• VPC Networking Without the Confusion

  … the app cannot reach PostgreSQL Assume an app in 10.42.10.0/24 connects to a database …

• Layered (N-Tier) Architecture

  … database server"] DB[(PostgreSQL)] end UI -- API -- DB The classic 3-tier web app has three layers of …

• SQL vs NoSQL Databases

  … correct, and SQL is a universal language. Examples: PostgreSQL, MySQL, SQL Server, SQLite (which this very app uses …

• Docker & Containers

  … shop } volumes: [pgdata:/var/lib/postgresql/data] healthcheck: test: ["CMD-SHELL", "pg isready -U app"] interval: 5s cache …

• StatefulSets, DaemonSets, Jobs and CronJobs

  … data mountPath: /var/lib/postgresql/data volumeClaimTemplates: - metadata: name: data spec: accessModes: [ReadWriteOnce] resources: requests: storage: 20Gi Key …

• Kafka vs RabbitMQ & the Kafka Ecosystem

  … Elasticsearch, S3, Snowflake, BigQuery, MongoDB, Postgres. json { "name": "orders-cdc", "config": { "connector.class": "io.debezium.connector.postgresql.PostgresConnector …

• Database Indexing & Transactions

  … BY , BETWEEN and / < fast. Creating and checking indexes (PostgreSQL) sql -- Slow: no index on email SELECT FROM users …

• Caching & Redis

  … the write path updates PostgreSQL, then returns success while Redis still holds the old value. mermaid sequenceDiagram participant …

• AWS: Start Here

  … Execute your business logic Orders and customers RDS PostgreSQL Store structured data with transactions Uploaded covers Private S3 …