Author

Hacker Afternoon Tea

You might find something interesting here ^_^

127

Articles

Likes

336

Views

Comments

Latest from Hacker Afternoon Tea

100 recent articles max

Hacker Afternoon Tea

Mar 17, 2022 · Databases

Building Scalable Time‑Series with Distributed PostgreSQL (Citus) – Official Example

This guide shows how to combine PostgreSQL declarative time‑range partitioning with Citus distributed sharding to create a scalable time‑series database, covering table creation, distribution, automatic monthly partition generation, columnar archiving, maintenance with pg_cron, and performance benefits such as faster inserts, queries, and data expiration.

CitusDistributed DatabasePostgreSQL

0 likes · 11 min read

Building Scalable Time‑Series with Distributed PostgreSQL (Citus) – Official Example

Hacker Afternoon Tea

Mar 16, 2022 · Databases

Building a Real-Time Dashboard with Distributed PostgreSQL (Citus) – Official Example

This tutorial shows how to use Citus, a distributed PostgreSQL extension, to ingest immutable HTTP event logs, shard them by site_id, create real‑time and pre‑aggregated tables, schedule roll‑up jobs, handle data expiration, estimate distinct counts with HyperLogLog, and store unstructured JSONB counters for a low‑latency analytics dashboard.

CitusHyperLogLogJSONB

0 likes · 16 min read

Building a Real-Time Dashboard with Distributed PostgreSQL (Citus) – Official Example

Hacker Afternoon Tea

Mar 15, 2022 · Databases

Migrating Existing Applications to a Distributed PostgreSQL (Citus) Cluster

This guide walks through planning a distribution strategy, adding and back‑filling a distribution key, preparing a development Citus cluster, updating schema and queries for multi‑tenant workloads, securing connections, monitoring cross‑node traffic, and finally migrating production data using either pg_dump/pg_restore for small databases or Citus Warp for large deployments.

Distributed Databasemigrationmulti-tenant

0 likes · 20 min read

Migrating Existing Applications to a Distributed PostgreSQL (Citus) Cluster

Hacker Afternoon Tea

Mar 14, 2022 · Databases

Building a Multi‑Tenant SaaS with Citus: An Official Distributed PostgreSQL Example

This guide walks through creating a multi‑tenant ad‑analytics SaaS using Citus, covering schema design, sharding by company_id, data ingestion, reference tables, online schema changes, tenant‑specific JSONB fields, hardware scaling, large‑tenant isolation, and migration steps with concrete SQL examples and commands.

CitusDistributed SQLJSONB

0 likes · 27 min read

Building a Multi‑Tenant SaaS with Citus: An Official Distributed PostgreSQL Example

Hacker Afternoon Tea

Mar 6, 2022 · Databases

Understanding Citus: Distributed PostgreSQL Architecture and Core Concepts

Citus extends PostgreSQL into a shared‑nothing distributed system where a coordinator node routes queries to worker nodes, supporting distributed, reference, and local tables, shard placement, replication modes, co‑location, parallel execution, and configurable connection‑pool settings to scale storage and CPU across a cluster.

CitusDistributed DatabasePostgreSQL

0 likes · 12 min read

Understanding Citus: Distributed PostgreSQL Architecture and Core Concepts

Hacker Afternoon Tea

Feb 28, 2022 · Cloud Native

Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling

This guide explains how to combine a PostgreSQL Operator with Pgpool-II on Kubernetes to create a PostgreSQL cluster that supports query read‑load balancing and connection pooling, covering prerequisites, deployment steps, environment‑variable and ConfigMap configuration, backend settings, failover handling, password registration, streaming replication checks, SSL setup, and Prometheus monitoring.

Cloud NativeConfigMapKubernetes

0 likes · 13 min read

Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling

Hacker Afternoon Tea

Feb 25, 2022 · Databases

How Citus Turns PostgreSQL into a Distributed Database

Citus is an open‑source PostgreSQL extension that adds sharding, distributed tables and parallel query execution, enabling horizontal and vertical scaling for multi‑tenant SaaS, real‑time analytics, and massive workloads, while outlining acquisition options, practical use cases, and scenarios where it is unsuitable.

AzureCitusDistributed Database

0 likes · 7 min read

How Citus Turns PostgreSQL into a Distributed Database

Hacker Afternoon Tea

Feb 24, 2022 · Cloud Native

How to Create, Connect, and Delete a PostgreSQL Cluster with CrunchyData PGO (Cloud‑Native)

This tutorial walks through installing the CrunchyData Postgres Operator, creating a PostgreSQL cluster named hippo with kustomize, inspecting its resources, configuring services, secrets, and TLS for secure connections, modifying service types, deploying a Keycloak application using the generated credentials, and finally deleting the cluster while handling PVC retention.

Cloud NativeCrunchyDataKubernetes

0 likes · 12 min read

How to Create, Connect, and Delete a PostgreSQL Cluster with CrunchyData PGO (Cloud‑Native)

Hacker Afternoon Tea

Feb 22, 2022 · Cloud Native

Deploy Cloud‑Native PostgreSQL Clusters with Crunchy Data’s PGO Operator

The Crunchy Data Postgres Operator (PGO) extends Kubernetes to provide a cloud‑native, highly available PostgreSQL platform with features such as automated provisioning, disaster recovery, TLS encryption, monitoring, user management, upgrade handling, advanced replication, cloning, connection pooling, affinity, scheduled backups to S3/GCS, multi‑namespace support, and extensive customizability across major Kubernetes distributions.

BackupCloud NativeCustom Resources

0 likes · 10 min read

Deploy Cloud‑Native PostgreSQL Clusters with Crunchy Data’s PGO Operator

Hacker Afternoon Tea

Feb 7, 2022 · Backend Development

How to Configure a Memory Broker Replica in Undermoon

This guide shows how to build Undermoon, run a master and replica Memory Broker, verify data replication, and manually switch to the replica via the coordinator API when the master fails, ensuring continued service operation.

Coordinator APIMemory BrokerRedis

0 likes · 4 min read

How to Configure a Memory Broker Replica in Undermoon