You might find something interesting here ^_^
This tutorial walks through setting up a PostgreSQL 16.1 + Citus 12.1 cluster with Docker, creating separate schemas and roles for user, time, and ping microservices, distributing them via schema‑based sharding, and demonstrating CRUD operations and verification of data placement across three worker nodes.
This guide explains what a sharded PostgreSQL cluster is, how StackGres implements it with Citus and Patroni, and provides step‑by‑step YAML manifests and scripts to create both a basic and a custom production‑grade high‑availability sharded cluster on Kubernetes.
This guide walks through identifying master and replica pods, performing graceful switchover, triggering automated failover, and reinitializing replicas in a StackGres 1.6 cluster using kubectl and patronictl commands, with practical notes and safety warnings.
This guide explains how StackGres 1.6 uses custom Kubernetes CRDs—SGPostgresConfig, SGInstanceProfile, and SGPoolingConfig—to define PostgreSQL parameters, instance sizing, and PgBouncer connection‑pool settings, and shows how to apply, reload, disable, and inspect these configurations with kubectl.
This article introduces StackGres 1.6’s core capabilities—including declarative Kubernetes CRDs, default tuning, custom configurations, high‑availability with Patroni, automated backups, server‑side connection pooling, distributed logging, observability, and a web UI—and provides a step‑by‑step quick‑start guide to install the operator, create a PostgreSQL cluster, and access it via psql, services, or the UI.
StackGres 1.6 is a full‑stack, production‑grade PostgreSQL distribution for Kubernetes that bundles a curated set of components—including Patroni, WAL‑G, PgBouncer, Envoy, and monitoring tools—into a single declarative deployment unit with multiple access methods, sidecar architecture, and built‑in high‑availability, backup, and observability features.
This article walks through the design and step‑by‑step deployment of a multi‑tenant, cloud‑native ClickHouse PaaS using Kubernetes Operators and Helm charts, integrates it with Sentry's Snuba event‑analysis engine, and shows how to customize Sentry Helm charts, configure Zookeeper, and verify distributed tables for large‑scale analytics.
The article explains how to boost a distributed system's throughput by optimizing middleware clusters—using Longhorn for storage, Citus for sharding Sentry's nodestore_node table into 64 shards across six workers, and adding PgPool, repmgr, and PgAdmin for read‑write splitting, high availability, and management.
This article explains how to automate and run HammerDB benchmarks for OLTP, OLAP, and HTAP workloads on Azure-hosted Citus‑extended PostgreSQL, discusses workload characteristics, benchmark specifications, challenges of HTAP testing, and shows how a 2 million new‑orders‑per‑minute result was achieved using open‑source tooling and configuration tips.
This guide walks through installing the Dapr JavaScript SDK, configuring a RabbitMQ pub/sub component, injecting DaprClient and DaprServer into a NestJS project, creating a custom @DaprPubSubSubscribe decorator, and running a complete end‑to‑end demo that publishes and consumes page‑view events.
