The JusDB Database Engineering Blog

Configure Patroni to use Consul instead of etcd as its DCS for PostgreSQL HA. Covers Consul setup, patroni.yml, service discovery, HAProxy routing, and failover testing.

Use pg_cron to schedule SQL jobs inside PostgreSQL. Covers installation, cron syntax, partition maintenance, materialized view refresh, job monitoring, and RDS setup.

Learn how to convert a standalone PostgreSQL instance to a Patroni high-availability cluster with etcd. Step-by-step guide covering installation, configuration, and failover testing.

Compare Liquibase and Flyway for schema migration management — features, abstraction level, and team fit

Use Apache Airflow to orchestrate database ETL, backup jobs, and maintenance tasks — DAGs, sensors, and best practices

Implement the transactional outbox pattern to publish events reliably from MySQL or PostgreSQL without dual-write problems

Compare Delta Lake, Apache Iceberg, and Apache Hudi — ACID transactions, time travel, and format interoperability

Use dbt to build modular SQL transformations — models, tests, documentation, and CI/CD for your data warehouse

Compare CDC, ETL, and ELT — latency, complexity, cost, and when each pattern fits your data pipeline needs

Compare ScyllaDB and Apache Cassandra — throughput, latency, operational complexity, and when to switch

FoundationDB powers Apple iCloud and Snowflake's metadata layer with ACID transactions across distributed nodes. Learn how its ordered key-value core, layer architecture, and simulation testing deliver unmatched reliability.

DuckDB brings OLAP query performance to your Python process without a server or cluster. Learn how to query Parquet files, replace heavy ETL jobs, and run analytics directly against PostgreSQL.