PostgreSQL Programming Tutorials & Engineering Articles

I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.

We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.

ClickHouse has achieved the AWS Small and Medium Business Competency, joining a select group of AWS Partners recognized for deep expertise in real-time analytics for small and medium businesses.

PostgresBench now includes HA benchmarks, comparing the performance of managed Postgres services under production-style HA configurations. This post explains the architectures behind each service and analyzes the trade-offs between availability guarantees

High-performance full-text search, even on object storage. This deep dive from the ClickHouse engineers explains the new text index design and how it keeps queries fast at scale.

Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.

A Solutions Architect’s experience building a retail analytics platform with AI agents, real-time dashboards, and full observability on the ClickHouse data platform

ClickHouse 26.4 is here! In this release, more features become SQL compatible, COUNT DISTINCT gets faster, EXPLAIN gets even prettier, and more

On June 15, 2016, ClickHouse went open source under the Apache 2.0 license. Ten years later, it's one of the most widely deployed analytical databases in the world.

How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.

chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.

How ClickHouse Managed Postgres reserves, enforces, and sizes huge pages so shared_buffers avoids the per-connection page-table tax that eats RAM and stalls reads on 4KB pages.

AI agents have changed a lot in the last two years. The first could only answer one question at a time. Then came multi-turn chat, where the model could keep…

While consumer AI offers powerful capabilities, workplace tools often suffer from disjointed data and limited context. Built with LangChain, the NVIDIA AI-Q…

This blog post introduces a suite of six protocols, such as MCP and A2A, designed to eliminate custom integration code by standardizing how AI agents access data and communicate. Using a "kitchen manager" agent as a practical example, it demonstrates how these tools handle complex tasks like real-time inventory checks, wholesale commerce via UCP, and secure payment authorization through AP2. By leveraging the Agent Development Kit (ADK), developers can also implement A2UI and AG-UI to deliver interactive dashboards and seamless streaming interfaces to users.

The article reviews Airbnb's significant advancements in research and technology throughout 2025, focusing on their participation in key conferences and the impactful papers presented.

The article discusses how PeerDB facilitates large-scale PostgreSQL migrations, specifically achieving a 1TB migration in just 2 hours.

The article discusses Spotify's multi-agent architecture designed to enhance advertising workflows by addressing structural issues within their ad business.

The article discusses the pg_stat_ch extension for PostgreSQL, which facilitates the export of metrics to ClickHouse.

This article explains how OpenAI built the Codex App Server, a bidirectional JSON-RPC API that serves as the critical link between the Codex harness (agent loop and logic) and various client surfac...

OpenAI built a bespoke internal AI data agent powered by GPT-5.

This article demonstrates how to port a Matrix homeserver from traditional infrastructure (Synapse on VPS) to Cloudflare Workers, creating a serverless, zero-maintenance deployment with automatic p...

This article explains the core agent loop architecture behind OpenAI's Codex CLI, detailing how it orchestrates interactions between users, LLM models, and tools to perform software engineering tas...

OpenAI details how they scaled PostgreSQL to support 800 million ChatGPT users, achieving millions of queries per second through a single-primary architecture with nearly 50 read replicas across mu...

ClickHouse 25.

The article discusses the NVIDIA Multi-Agent Intelligent Warehouse (MAIW), an AI command layer designed to enhance operational efficiency and supply chain intelligence in automated warehouses.

The article discusses how to build and orchestrate end-to-end synthetic data generation (SDG) workflows using NVIDIA Isaac Sim and NVIDIA OSMO.

The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.

The article presents a curated list of technology blogs that focus on performance optimizations, algorithms, database development, and more, aimed at helping software engineers find valuable resour...

The article discusses the implementation of a PostgreSQL setting (GUC) for the pg_clickhouse extension, focusing on optimizing the parsing of key/value pairs for session settings.

The article highlights Alexey's favorite features introduced in ClickHouse throughout 2025, including lightweight updates, data lake support, and advancements in text and vector indexing.

The article discusses Pinterest's journey in enhancing developer experience through the creation of PinConsole, an Internal Developer Platform built on Backstage.

This article compares the UPDATE performance of ClickHouse and PostgreSQL, highlighting ClickHouse's significant speed advantages in bulk updates while also acknowledging PostgreSQL's strengths in ...

ClickHouse Release 25.

This article discusses the significant performance improvements achieved in ClickHouse's SQL UPDATE operations, demonstrating how they can be up to 1,000× faster than traditional mutation methods t...

This article discusses the innovative approach ClickHouse has taken to implement fast SQL-style UPDATEs in its column store architecture.

This article discusses how ClickHouse addresses the challenges of row-level updates in column stores by treating updates as inserts.

This article explores a bug encountered by the ClickPipes team related to logical replication slot creation in PostgreSQL read replicas, where a query could not be terminated by standard methods.

This article discusses the importance of data flywheels in maintaining the accuracy of AI systems over time, particularly in enterprise settings.

The article discusses the integration of frontend, backend, and database functionalities within a single Cloudflare Worker, highlighting recent improvements that enable developers to build full-sta...

The article discusses the newly announced support for MySQL in Cloudflare Workers and Hyperdrive, enabling developers to build applications that connect directly to MySQL databases regardless of th...

The article discusses how Dash0 transitioned to using ClickHouse as a core database technology for their observability platform, leveraging its efficiency and scalability to handle OpenTelemetry da...

The article discusses the implementation of Make Before Break scaling mechanics for ClickHouse Cloud, focusing on the transition from a single StatefulSet architecture to a more flexible MultiSTS a...

This article provides a comprehensive guide on integrating PostgreSQL with ClickHouse using Change Data Capture (CDC) for real-time analytics.

The article discusses the One Billion Documents JSON Challenge, comparing the performance of ClickHouse against other popular databases like MongoDB, Elasticsearch, DuckDB, and PostgreSQL in storin...

This article discusses data access patterns for integrating with Stripe, emphasizing the importance of choosing the right data storage strategy to enhance security, performance, and scalability.

This article provides a comprehensive guide on creating a custom Slackbot LLM agent using NVIDIA NIM and LangChain.

The article discusses the launch of Workers Builds, an integrated CI/CD workflow on the Workers platform, enabling developers to build and deploy applications seamlessly from GitHub or GitLab.