Skip to content
Tagged articles

PostgreSQL

500 articles · Page 1 of 5
21CTO
21CTO
Nov 17, 2026 · Databases

PostgreSQL Fixes 52 CVEs: Critical CVE-2026-6460, AI Scanning Trend, v19 REPACK Preview

PostgreSQL released updates for versions 14 through 18 fixing 52 security vulnerabilities including critical CVE-2026-6460, while version 14 reaches end-of-life; experts attribute rising CVE counts to AI-assisted scanning, and PostgreSQL 19 RC2 introduces a new REPACK command for non-blocking space reclamation.

AI Security ScanningCVE-2026-6460Database Upgrade
0 likes · 6 min read
PostgreSQL Fixes 52 CVEs: Critical CVE-2026-6460, AI Scanning Trend, v19 REPACK Preview
21CTO
21CTO
Nov 15, 2026 · Databases

DocumentDB 1.0: Open-Source PostgreSQL Document DB with MongoDB Wire Compatibility

Microsoft's DocumentDB 1.0 releases as an MIT-licensed PostgreSQL extension and gateway compatible with MongoDB wire protocol, offering Kubernetes support, security focus, and a permissive license alternative to MongoDB's SSPL, while benchmarks show mixed performance versus MongoDB and FerretDB.

BenchmarkDocumentDBKubernetes
0 likes · 6 min read
DocumentDB 1.0: Open-Source PostgreSQL Document DB with MongoDB Wire Compatibility
ITPUB
ITPUB
Nov 6, 2026 · Artificial Intelligence

Why AI Agents Need a Database-Backed Control Plane: Inside Chuanxu's Architecture

DBA Yin Haiwen details how Chuanxu evolved from an Agent memory system into a database-backed control plane enforcing identity, permissions, and audit trails across Oracle, PostgreSQL, and YashanDB, using a seven-layer dependency chain and fail-closed zero-trust model.

AI Agent governanceOraclePostgreSQL
0 likes · 25 min read
Why AI Agents Need a Database-Backed Control Plane: Inside Chuanxu's Architecture
Architecture Development Notes
Architecture Development Notes
Oct 27, 2026 · Backend Development

Why MCP's readOnlyHint Can't Be Trusted: Enforce Read-Only at the Database Layer

The article explains that MCP's readOnlyHint is a server-declared hint, not an enforceable guarantee; clients must treat annotations as untrusted unless from verified servers, and true read-only enforcement requires execution-layer permissions like database roles, while also noting data exfiltration risks via openWorldHint.

MCPPostgreSQLdatabase permissions
0 likes · 8 min read
Why MCP's readOnlyHint Can't Be Trusted: Enforce Read-Only at the Database Layer
Raymond Ops
Raymond Ops
Oct 24, 2026 · Databases

Right-Sizing Database Connection Pools: From Guesswork to Capacity Budgeting

This article explains how to determine optimal database connection pool sizes by establishing a capacity budget, monitoring pool and database metrics, configuring HikariCP for PostgreSQL, and iteratively tuning based on workload characteristics rather than relying on generic formulas.

Connection PoolingHikariCPKubernetes
0 likes · 38 min read
Right-Sizing Database Connection Pools: From Guesswork to Capacity Budgeting
Cloud Architecture
Cloud Architecture
Oct 19, 2026 · Backend Development

Go Distributed Transactions in Production: Outbox, SAGA, TCC & Recovery Loops

This article details production-ready Go distributed transaction patterns including Outbox for reliable event publishing, RocketMQ transaction messages, SAGA orchestration with compensation, TCC resource reservation, payment unknown-state handling, capacity planning, fault validation matrices, and operational recovery loops with concrete PostgreSQL schemas and Go code examples.

GoOutbox PatternPostgreSQL
0 likes · 45 min read
Go Distributed Transactions in Production: Outbox, SAGA, TCC & Recovery Loops
Ray's Galactic Tech
Ray's Galactic Tech
Oct 19, 2026 · Information Security

Zero-Trust Agent Tool Execution: From Prompt Injection to MCP Authorization in Go

The article presents a reference implementation for secure agent tool execution, establishing trust boundaries where only an independent executor authorizes side effects, covering Go parameter parsing, PostgreSQL approval workflows with leases and fencing, Kubernetes least-privilege deployment, and audit logging, while noting the code is unverified and not production-ready.

Agent SecurityFencingGo
0 likes · 44 min read
Zero-Trust Agent Tool Execution: From Prompt Injection to MCP Authorization in Go
IT Architects Alliance
IT Architects Alliance
Oct 19, 2026 · Backend Development

GC Pauses Break Redis Locks: How Fencing Tokens Prevent Stale Overwrites

The article explains how Redis distributed locks with TTL leases fail to prevent stale writes when a garbage collection pause delays a lock holder past its lease expiry, allowing a new holder to write fresh data that the original holder then overwrites upon resuming; it demonstrates why fencing tokens — incrementing sequence numbers issued atomically with lock grants and checked atomically at the storage layer via conditional updates — are necessary to reject obsolete writes.

GC pausePostgreSQLRedis
0 likes · 12 min read
GC Pauses Break Redis Locks: How Fencing Tokens Prevent Stale Overwrites
IT Architects Alliance
IT Architects Alliance
Oct 13, 2026 · Operations

Hybrid Cloud DR: Why Full Dual-Active Isn't Mandatory – A Tiered Validation Framework

This article presents a tiered disaster recovery framework for hybrid cloud environments, using a four-dimensional comparison table, recovery acceptance criteria, and a six-question checklist to evaluate warm standby, cold standby, and partial dual-active strategies, demonstrating how to validate recovery with concrete RTO/RPO targets, data gap reconciliation, and business transaction verification.

PostgreSQLRPORTO
0 likes · 20 min read
Hybrid Cloud DR: Why Full Dual-Active Isn't Mandatory – A Tiered Validation Framework
java1234
java1234
Oct 9, 2026 · Databases

PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More

PostgreSQL 18.6 introduces async I/O with io_uring support, skip scan for composite indexes, time-ordered UUIDv7, virtual generated columns, OAuth authentication, RETURNING old/new values, and critical security fixes for logical decoding and pgcrypto.

GIN IndexGenerated ColumnsOAuth
0 likes · 15 min read
PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More
ITPUB
ITPUB
Oct 7, 2026 · Backend Development

Rails 8 Drops Redis: How PostgreSQL's SKIP LOCKED Powers SolidQueue

Rails 8 replaces Redis with database-backed SolidQueue, SolidCache, and SolidCable, leveraging PostgreSQL's SKIP LOCKED for efficient task queues and arguing that most applications overpay a hidden 'middleware tax' for specialized infrastructure they don't actually need.

Backend ArchitecturePostgreSQLRails 8
0 likes · 14 min read
Rails 8 Drops Redis: How PostgreSQL's SKIP LOCKED Powers SolidQueue
AI Engineering
AI Engineering
Oct 4, 2026 · Databases

Semantic Filtering in Postgres Without Vector Indexes: pg-jev Hands-On

pg-jev is a PostgreSQL extension that wraps TypeSafe's Jev library into SQL functions, enabling semantic classification, probability scoring, and label selection directly in queries without vector indexes or embeddings, with performance benchmarks and operational caveats.

JevPostgreSQLSQL Functions
0 likes · 5 min read
Semantic Filtering in Postgres Without Vector Indexes: pg-jev Hands-On
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Oct 1, 2026 · Databases

Database Selection Guide: Decision Framework for New Projects with Xinchuang Options

This article provides a structured decision framework for choosing databases in new projects, covering four key questions, relational and NoSQL comparisons, Xinchuang (domestic) database options, distributed NewSQL systems, a practical decision tree, typical technology stacks, and guidance on writing selection documents with POC validation.

NewSQLPostgreSQLarchitecture-decision
0 likes · 9 min read
Database Selection Guide: Decision Framework for New Projects with Xinchuang Options
Geek Labs
Geek Labs
Oct 1, 2026 · Artificial Intelligence

AIHOT Open-Sourced: Build Your Own Industry Hot-Topic Site by Swapping Sources

The article introduces AIHOT, an open-source AI-powered news aggregation system that automatically collects, filters, scores, clusters, and publishes daily briefings; its methodology (prompts, scoring, thresholds) is fully open, allowing anyone to adapt it to their industry by changing sources and calibration data.

AI news aggregationLLM promptingNode.js
0 likes · 13 min read
AIHOT Open-Sourced: Build Your Own Industry Hot-Topic Site by Swapping Sources
Ray's Galactic Tech
Ray's Galactic Tech
Sep 29, 2026 · Backend Development

Production-Grade LLM Annotation Pipeline: Pydantic, PostgreSQL & Kafka Patterns

The article details how a SaaS team evolved a fragile LLM ticket-classification script into a production-grade pipeline using strict Pydantic contracts, PostgreSQL state machines with atomic leasing, Kafka outbox patterns, immutable training snapshots, and metric-gated rollouts to handle model drift, replay, and human review safely.

Data EngineeringIdempotencyKafka
0 likes · 27 min read
Production-Grade LLM Annotation Pipeline: Pydantic, PostgreSQL & Kafka Patterns
dbaplus Community
dbaplus Community
Sep 27, 2026 · Databases

Turing Winner Stonebraker: Why LLMs Won't Replace Relational Databases & AI Agent Pitfalls

In an 80-minute interview, Turing Award winner Mike Stonebraker argues that relational databases will absorb AI workloads, explains why Text-to-SQL fails on real enterprise data due to schema corruption and access controls, details DBOS's persistent workflow approach for AI agents, and discusses saga patterns for compensating transactions, graph database limitations, and the future of open-source AI.

AI agentsDBOSGraph Databases
0 likes · 27 min read
Turing Winner Stonebraker: Why LLMs Won't Replace Relational Databases & AI Agent Pitfalls
dbaplus Community
dbaplus Community
Sep 26, 2026 · Databases

PostgreSQL JSON vs JSONB: 1M Row Benchmark Shows 7x Query Speed Gap

This article benchmarks PostgreSQL JSON and JSONB types on 1 million rows, revealing JSONB delivers 6-9x faster queries and 26% less storage despite 31% slower writes, with practical guidance on when to choose each type and how to leverage GIN indexes for optimal performance.

Database BenchmarkGIN IndexJSON
0 likes · 20 min read
PostgreSQL JSON vs JSONB: 1M Row Benchmark Shows 7x Query Speed Gap
21CTO
21CTO
Sep 25, 2026 · Databases

MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark

The author benchmarks MariaDB 10.3, MySQL 8.0, and PostgreSQL 12 using a real Turkish motorcycle classifieds app with many simple queries, finding MariaDB 5% faster on average and 7% faster at p95 with lower CPU usage, though MySQL handles tail latency better and memory differences stem from default performance_schema settings.

BenchmarkDatabase PerformanceMariaDB
0 likes · 10 min read
MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Sep 20, 2026 · Databases

One SQL to Generate 2000 Test Rows: Stop Hand-Writing VALUES

Learn how to generate 2000 test rows in PostgreSQL using a single INSERT...SELECT with generate_series, deriving column values via series numbers, zero-padding with LPAD, explicit timestamps, and ON CONFLICT for idempotent execution, plus random data variations and MySQL equivalents.

INSERT SELECTKingBaseESLPAD
0 likes · 8 min read
One SQL to Generate 2000 Test Rows: Stop Hand-Writing VALUES
Raymond Ops
Raymond Ops
Sep 17, 2026 · Databases

MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained

This comprehensive guide covers MySQL and PostgreSQL monitoring essentials, including key metrics (connections, throughput, InnoDB, replication), version-specific differences, alert thresholds, exporter deployment (mysqld_exporter, postgres_exporter), Grafana dashboards, Prometheus alerting rules, troubleshooting playbooks for common issues like connection exhaustion, replication lag, deadlocks, and disk growth, plus automation scripts for long-transaction killing and slow-query analysis.

ExportersGrafanaPerformance Tuning
0 likes · 74 min read
MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 16, 2026 · Databases

PostgreSQL JSONB with Spring Boot: Handle Custom Fields Without MongoDB

This article demonstrates how PostgreSQL's JSONB type combined with Spring Boot provides a practical alternative to MongoDB for managing dynamic custom fields in enterprise applications, covering storage, indexing, JPA mapping, partial updates, querying patterns, and performance tuning while preserving relational integrity.

Cursor PaginationGIN IndexHibernate
0 likes · 21 min read
PostgreSQL JSONB with Spring Boot: Handle Custom Fields Without MongoDB
ITPUB
ITPUB
Aug 21, 2026 · Industry Insights

12 Years of DTCC: How China’s Database Conference Evolved and United Engineers

The article chronicles the twelve‑year evolution of China’s Database Technology Conference (DTCC), showing how it transformed isolated DBA communities into a collaborative ecosystem, introduced new topics such as cloud and NoSQL, and enabled figures like 那海蓝蓝 to shape the nation’s database engineering landscape.

DTCCPostgreSQLTDSQL
0 likes · 30 min read
12 Years of DTCC: How China’s Database Conference Evolved and United Engineers
Java Companion
Java Companion
Aug 14, 2026 · Backend Development

One‑Command Install, MCP Direct Connect: AI‑Powered Production with InsForge

InsForge is an open‑source backend platform that bundles PostgreSQL, authentication, object storage, serverless functions, real‑time messaging and a unified model gateway, exposing them via MCP so AI coding agents like Cursor and Claude can automatically provision, configure and deploy full‑stack services with a single command.

AI coding agentsInsForgeMCP Protocol
0 likes · 11 min read
One‑Command Install, MCP Direct Connect: AI‑Powered Production with InsForge
Yunqi AI+
Yunqi AI+
Aug 13, 2026 · Artificial Intelligence

Building an AI‑Native Service: A Minimal Viable Semantic Service Walkthrough

This article details how to turn ontology‑based semantic assets into a runnable Semantic Service that answers risk queries and suggests actions, using a three‑layer architecture of deterministic code, a versioned knowledge base, and LLM‑driven reasoning, illustrated with a customer health‑score example.

AILLMPostgreSQL
0 likes · 21 min read
Building an AI‑Native Service: A Minimal Viable Semantic Service Walkthrough
21CTO
21CTO
Aug 10, 2026 · Databases

Build a High‑Availability PostgreSQL Cluster with Streaming Replication and Read‑Write Splitting from Scratch

This guide walks through the complete process of designing, configuring, and operating a PostgreSQL primary‑standby setup with streaming replication, choosing between asynchronous and synchronous modes, implementing read‑write splitting via application routing or PgBouncer, and handling monitoring, failover, and common pitfalls for production‑grade high availability.

High AvailabilityPatroniPostgreSQL
0 likes · 15 min read
Build a High‑Availability PostgreSQL Cluster with Streaming Replication and Read‑Write Splitting from Scratch
MaGe Linux Operations
MaGe Linux Operations
Aug 6, 2026 · Databases

How to Determine the Right Database Connection Pool Size: Practical Guidelines and Benchmarks

This article walks through a systematic approach to sizing PostgreSQL connection pools for Java applications using HikariCP and Spring Boot, covering capacity budgeting, workload‑driven calculations, monitoring metrics, slow‑SQL analysis, leak detection, Kubernetes deployment considerations, and safe rollout practices.

Connection PoolHikariCPKubernetes
0 likes · 27 min read
How to Determine the Right Database Connection Pool Size: Practical Guidelines and Benchmarks
System Architect Go
System Architect Go
Aug 4, 2026 · Databases

Quick PostgreSQL Guide for MySQL Users: Beyond Syntax Differences

This article walks MySQL developers through the essential architectural, schema, data‑type, SQL‑dialect, transaction, vacuum, indexing, and extension differences when moving to PostgreSQL, providing concrete examples, code snippets, and best‑practice recommendations to avoid common pitfalls.

PostgreSQLSQLVACUUM
0 likes · 38 min read
Quick PostgreSQL Guide for MySQL Users: Beyond Syntax Differences
dbaplus Community
dbaplus Community
Jul 28, 2026 · Operations

PostgreSQL Ops Checklist: 13 Pitfalls to Avoid (2026 Edition)

The article provides a comprehensive PostgreSQL operational self‑checklist covering CPU, memory, generic plans, idle connections, autovacuum, checkpoint and bgwriter tuning, AI workload handling, index building, replication, migration, partition management, and observability, with concrete examples, benchmarks, and practical commands.

IndexingMemoryPostgreSQL
0 likes · 39 min read
PostgreSQL Ops Checklist: 13 Pitfalls to Avoid (2026 Edition)
Ray's Galactic Tech
Ray's Galactic Tech
Jul 27, 2026 · Databases

How Partitioning Cut a 43‑Second PostgreSQL Query to 0.3 seconds

In a SaaS analytics platform with a 45‑billion‑row, 1.2 TB events table, the author shows how moving to native PostgreSQL range partitioning by event_time, combined with zero‑downtime migration steps, reduced the typical P99 query latency from 43 seconds to about 0.3 seconds while enabling easier data lifecycle management.

PartitioningPostgreSQLmigration
0 likes · 27 min read
How Partitioning Cut a 43‑Second PostgreSQL Query to 0.3 seconds
DataFunSummit
DataFunSummit
Jul 26, 2026 · Databases

Why Is PostgreSQL Gaining New Momentum as an AI‑Era Data Foundation?

PostgreSQL is attracting renewed interest not because it magically becomes an all‑purpose AI database, but because AI applications in production demand a unified, consistent platform that can manage business records, vector embeddings, agent state, permissions and tooling, and PostgreSQL’s extensible ecosystem—pgvector, serverless architectures, branching, and MCP—offers exactly that blend of relational reliability and AI‑native capabilities.

AIDatabase BranchingMCP
0 likes · 15 min read
Why Is PostgreSQL Gaining New Momentum as an AI‑Era Data Foundation?
ITPUB
ITPUB
Jul 24, 2026 · Databases

Interview with Yang Yu: Databases Face Their Most Dramatic Role Shift in 50 Years

The article examines how databases, after five decades of human‑centric design, are undergoing a fundamental transformation driven by Agentic AI, requiring new semantics, multimodal storage, memory capabilities, and integrated engines, illustrated through insights from Yang Yu of KuKe Data.

AIAgentPostgreSQL
0 likes · 13 min read
Interview with Yang Yu: Databases Face Their Most Dramatic Role Shift in 50 Years
System Architect Go
System Architect Go
Jul 23, 2026 · Databases

Building a PostgreSQL WAL‑Based CDC System: Principles and Engineering Implementation

This article explains how to capture and stream row‑level changes from PostgreSQL using its Write‑Ahead Log, compares the approach with MySQL binlog CDC, and provides a step‑by‑step guide—including configuration, logical decoding, snapshot handling, replication slots, and production‑grade correctness considerations—to build a reliable CDC pipeline.

CDCData PipelineLogical Decoding
0 likes · 29 min read
Building a PostgreSQL WAL‑Based CDC System: Principles and Engineering Implementation
dbaplus Community
dbaplus Community
Jul 21, 2026 · Databases

Tired of Hand‑Crafted Backup Scripts? Meet Databasus – One Open‑Source Platform for All Major Databases

Databasus is an open‑source backup management platform that unifies PostgreSQL, MySQL, MariaDB and MongoDB backups with a web UI, offering logical, physical and incremental backups, automated scheduling, AES‑256‑GCM encryption, multi‑cloud storage, RBAC collaboration, and optional agents for secure, out‑bound connections.

AES-256-GCMDatabasusKubernetes
0 likes · 14 min read
Tired of Hand‑Crafted Backup Scripts? Meet Databasus – One Open‑Source Platform for All Major Databases
dbaplus Community
dbaplus Community
Jul 19, 2026 · Databases

Why PostgreSQL’s Creator Criticizes Oracle and Google – AI‑Generated SQL Still Falls Short

In a candid interview, PostgreSQL founder Michael Stonebraker recounts his journey from Ingres to Postgres, critiques Oracle’s sales tactics, denounces Google’s and Amazon’s database strategies, explains Postgres’s extensible type system, explores the DBOS research project, and highlights why current large‑language‑model‑to‑SQL solutions remain far from production‑ready.

AIDBOSGoogle
0 likes · 25 min read
Why PostgreSQL’s Creator Criticizes Oracle and Google – AI‑Generated SQL Still Falls Short
21CTO
21CTO
Jul 19, 2026 · Databases

Can Rust Replace PostgreSQL? pgrust Passes All Official Tests

The pgrust project rewrites PostgreSQL's core in Rust, passes all 46,066 official regression tests, supports standard SQL and the psql client, but remains experimental, exploring a thread‑per‑connection model and showcasing how AI‑driven coding can lower the cost of large‑scale infrastructure rewrites.

AIPostgreSQLRust
0 likes · 15 min read
Can Rust Replace PostgreSQL? pgrust Passes All Official Tests
ByteDance SE Lab
ByteDance SE Lab
Jul 14, 2026 · Databases

Instant DB Creation & Auto‑Scale: How Volcano PostgreSQL Serverless Supercharges Feishu MiaoDa AI Development

The article explains how AI‑generated code can be delivered in seconds, but traditional databases add a ten‑minute bottleneck, and shows that Volcano Cloud PostgreSQL Serverless reduces instance creation to 10 seconds, speeds up branch operations 200‑fold, offers scale‑to‑zero, cuts costs by 99.99%, and provides a Data‑as‑Git workflow with a step‑by‑step recovery demo.

AI developmentCloud DatabaseData as Git
0 likes · 12 min read
Instant DB Creation & Auto‑Scale: How Volcano PostgreSQL Serverless Supercharges Feishu MiaoDa AI Development
dbaplus Community
dbaplus Community
Jul 5, 2026 · Databases

Why Dropping SQLite May Be Wrong – Do You Actually Need PostgreSQL for Write Load?

The article re‑examines SQLite’s historic reputation as a test‑only database, showing how SSD‑backed WAL mode, tools like LibSQL/Turso, Litestream, and Cloudflare D1, plus modern JVM support, give SQLite production‑grade performance for read‑intensive, multi‑tenant and edge scenarios, while outlining when PostgreSQL remains necessary.

Cloudflare D1Database PerformanceLibSQL
0 likes · 19 min read
Why Dropping SQLite May Be Wrong – Do You Actually Need PostgreSQL for Write Load?
ITPUB
ITPUB
Jul 2, 2026 · Industry Insights

How ColdFront Sets pgEdge Apart in the OLTP‑OLAP‑AI Showdown

The article compares four emerging data‑lake‑for‑PostgreSQL solutions—Databricks LTAP, EDB Fusion Analytics, Snowflake pg_lake, and pgEdge's ColdFront—highlighting ColdFront's unique transparent Iceberg layer, writable cold data, DuckDB integration, and the strategic trade‑offs developers must weigh when choosing a modern OLTP/OLAP/AI architecture.

Agentic AIColdFrontDuckDB
0 likes · 9 min read
How ColdFront Sets pgEdge Apart in the OLTP‑OLAP‑AI Showdown
Cloud Architecture
Cloud Architecture
Jun 28, 2026 · Databases

PostgreSQL vs MongoDB: Architecture Selection & Hybrid Implementation Guide

This article provides a comprehensive, enterprise‑level comparison of PostgreSQL and MongoDB, outlining when each database fits business needs, a five‑dimensional decision framework, mixed‑architecture patterns, practical schema and indexing examples, and guidance on performance, stability, and migration considerations.

MongoDBPostgreSQLdatabase selection
0 likes · 36 min read
PostgreSQL vs MongoDB: Architecture Selection & Hybrid Implementation Guide
Cloud Architecture
Cloud Architecture
Jun 26, 2026 · Databases

PostgreSQL Backup & Replication Guide: WAL Basics to Production‑Ready HA, DR, and Recovery

This comprehensive guide walks through PostgreSQL's backup and replication architecture, explaining WAL fundamentals, the distinction between backup, high‑availability, disaster‑recovery and CDC, and provides step‑by‑step configurations, performance trade‑offs, monitoring queries, Kubernetes deployment tips, and practical recovery‑drill procedures for production environments.

CDCHAPITR
0 likes · 40 min read
PostgreSQL Backup & Replication Guide: WAL Basics to Production‑Ready HA, DR, and Recovery
Hacker Afternoon Tea
Hacker Afternoon Tea
Jun 22, 2026 · Cloud Native

Run Multica Self‑Hosted with Three Commands: Safely Launch Three Containers

The article explains how to self‑host Multica using a three‑container Docker Compose setup—PostgreSQL, backend, and frontend—detailing secure defaults, health‑checked service dependencies, advisory‑lock‑based migrations, loopback port bindings, and two launch methods (official images or local builds) that let you start the system with just three commands.

MulticaPostgreSQLSecurity
0 likes · 14 min read
Run Multica Self‑Hosted with Three Commands: Safely Launch Three Containers
Cloud Architecture
Cloud Architecture
Jun 22, 2026 · Databases

Opening the Hood of PostgreSQL WAL: From Transaction Logs to Production‑Grade HA, Replication, and Performance Tuning

This article dissects PostgreSQL's Write‑Ahead Logging (WAL), explaining how it underpins transaction durability, replication, CDC, point‑in‑time recovery, and commit latency, and provides a step‑by‑step guide to architecture design, parameter tuning, troubleshooting, containerization, backup strategies, and operational checklists for production‑grade deployments.

CDCHigh AvailabilityPerformance Tuning
0 likes · 37 min read
Opening the Hood of PostgreSQL WAL: From Transaction Logs to Production‑Grade HA, Replication, and Performance Tuning
Shuge Unlimited
Shuge Unlimited
Jun 16, 2026 · Artificial Intelligence

Beyond mem0: How YC CEO’s Open‑Source AI Memory Engine Uses Regex Instead of LLMs to Power a Knowledge Graph

The article dissects GBrain, an open‑source AI memory engine from Y Combinator’s Garry Tan, showing how a dual‑engine contract, zero‑LLM regex‑based knowledge‑graph extraction, and a layered hybrid retrieval pipeline boost P@5 from ~18 to 49.1 while detailing engineering trade‑offs, batch‑write work‑arounds, weighting constants, and reliability mechanisms.

AI agentGBrainHybrid Retrieval
0 likes · 21 min read
Beyond mem0: How YC CEO’s Open‑Source AI Memory Engine Uses Regex Instead of LLMs to Power a Knowledge Graph
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jun 12, 2026 · Databases

PostgreSQL Migration Pitfalls: From Rough Practices to Stable Management

The article analyzes common mistakes when moving from MySQL to PostgreSQL—such as oversized connection pools, blind max_connections tweaks, oversized transactions, idle‑in‑transaction connections, and indiscriminate indexing—and offers concrete, step‑by‑step guidance to achieve a stable, well‑tuned PostgreSQL deployment.

Connection PoolPerformance TuningPostgreSQL
0 likes · 14 min read
PostgreSQL Migration Pitfalls: From Rough Practices to Stable Management
Cloud Architecture
Cloud Architecture
Jun 4, 2026 · Databases

PostgreSQL vs MySQL: The Ultimate Engineering Guide to Database Selection

This comprehensive guide compares PostgreSQL and MySQL from an engineering perspective, covering business models, transaction semantics, concurrency, replication, scalability, operational costs, real‑world case studies, and a decision matrix to help teams choose the database that minimizes long‑term complexity and cost.

Outbox PatternPostgreSQLdatabase selection
0 likes · 38 min read
PostgreSQL vs MySQL: The Ultimate Engineering Guide to Database Selection
Java Tech Enthusiast
Java Tech Enthusiast
Jun 4, 2026 · Databases

Why PostgreSQL Beats MySQL in the AI Era

The article explains why developers should move beyond MySQL to PostgreSQL, illustrating the productivity gains of native window functions, MVCC concurrency, rich indexing, JSONB support, and extensive extensions through detailed examples, installation guides, performance comparisons, and real‑world use cases.

Database MigrationIndexingJSONB
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
Ubuntu
Ubuntu
Jun 2, 2026 · Databases

One‑Click Deployment of MySQL, Redis, and PostgreSQL on WSL

This guide shows how to install, configure, and manage MySQL/MariaDB, Redis, and PostgreSQL inside Windows Subsystem for Linux, including remote access setup, common command‑line operations, GUI client recommendations, and scripts for one‑click start/stop and backup.

GUI clientPostgreSQLRedis
0 likes · 14 min read
One‑Click Deployment of MySQL, Redis, and PostgreSQL on WSL
Su San Talks Tech
Su San Talks Tech
May 30, 2026 · Databases

Why PostgreSQL Beats MySQL for AI‑Driven Applications

The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.

IndexingJSONBJava
0 likes · 24 min read
Why PostgreSQL Beats MySQL for AI‑Driven Applications
IoT Full-Stack Technology
IoT Full-Stack Technology
May 29, 2026 · Backend Development

How We Cut a 30‑Second API Call to Under 1 Second on 2 Million Records

In a high‑concurrency transaction system, the author diagnosed a 30‑second API latency caused by costly SQL scans and Java Map creation on over two million rows, then applied SQL aggregation, moved counting logic into PostgreSQL, and introduced a Caffeine cache, ultimately reducing the response time to under 0.8 seconds while highlighting relational‑database limits for massive data.

Caffeine CacheJavaMyBatis
0 likes · 10 min read
How We Cut a 30‑Second API Call to Under 1 Second on 2 Million Records
dbaplus Community
dbaplus Community
May 20, 2026 · Databases

Stunning SQL Queries: From Tetris Game to Real‑Time Funnels

This article showcases a collection of impressive SQL queries—including a PostgreSQL Tetris implemented with a recursive CTE, window‑function session analysis, a ClickHouse real‑time funnel, dynamic WHERE clause generation, and a recursive employee hierarchy—while discussing performance tips and engine choices.

ClickHouseHivePostgreSQL
0 likes · 25 min read
Stunning SQL Queries: From Tetris Game to Real‑Time Funnels
dbaplus Community
dbaplus Community
May 17, 2026 · Databases

Is Raising work_mem from 4 MB to 64 MB Really Optimizing Sorts? The 2 TB PostgreSQL OOM Time Bomb

The article explains why increasing PostgreSQL's work_mem does not guarantee per‑query memory limits, how multiple sort/hash nodes, parallel workers and long‑lived memory contexts can cause OOM even on a 2 TB server, and offers concrete diagnostics and mitigation strategies for DBAs and developers.

ConcurrencyMemory ManagementOOM
0 likes · 12 min read
Is Raising work_mem from 4 MB to 64 MB Really Optimizing Sorts? The 2 TB PostgreSQL OOM Time Bomb
ITPUB
ITPUB
May 13, 2026 · Databases

Is the Hype Around Vector Databases a Pseudo‑Demand in the AI Era?

The article questions whether dedicated vector databases are truly needed for AI applications, examining market hype, the rapid emergence of many vector‑DB products, real‑world examples like PostgreSQL pgvector and major vendor integrations, and the hidden costs of data fragmentation and operational complexity.

AIPostgreSQLRAG
0 likes · 15 min read
Is the Hype Around Vector Databases a Pseudo‑Demand in the AI Era?
LuTiao Programming
LuTiao Programming
May 12, 2026 · Backend Development

Stop Splitting Databases: Spring Boot + PostgreSQL Schema Multi‑Tenant Best Practice for Performance

This article explains why naïve database‑per‑tenant designs cause resource waste and operational headaches, and demonstrates how Spring Boot, Hibernate, and PostgreSQL schemas provide a lightweight, high‑performance multi‑tenant architecture with strong isolation, low overhead, and easy scalability.

HibernateMulti-tenancyPostgreSQL
0 likes · 16 min read
Stop Splitting Databases: Spring Boot + PostgreSQL Schema Multi‑Tenant Best Practice for Performance
21CTO
21CTO
May 11, 2026 · Information Security

AI Uncovers 20-Year-Old Critical Vulnerabilities in PostgreSQL and MariaDB

An AI‑driven security tool discovered high‑severity, remote‑code‑execution flaws in PostgreSQL's pgcrypto extension and MariaDB's JSON schema validation, both dating back over two decades, prompting immediate patch releases and offering mitigation steps for unpatched deployments.

AI-driven AnalysisCVE-2026-2005MariaDB
0 likes · 6 min read
AI Uncovers 20-Year-Old Critical Vulnerabilities in PostgreSQL and MariaDB
SpringMeng
SpringMeng
May 3, 2026 · Databases

Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, extensible ecosystem, advanced replication and monitoring features, while exposing MySQL's limitations in data modeling, sequence support, tooling, and replication, and concludes that the best choice depends on specific workload requirements.

MVCCPostgreSQLdata types
0 likes · 8 min read
Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained
21CTO
21CTO
May 1, 2026 · Industry Insights

Why PHP 9.0 Is Switching to the 3‑Clause BSD License

The php.internals vote on April 4 approved moving PHP 9.0 to the permissive 3‑clause BSD license, replacing the dual PHP v3.01 and Zend Engine licenses, and the article explains the historical reasons, legal benefits, comparisons with other BSD variants, PostgreSQL’s approach, and broader open‑source licensing trends.

BSD licenseOSIOpen Source Licensing
0 likes · 7 min read
Why PHP 9.0 Is Switching to the 3‑Clause BSD License
dbaplus Community
dbaplus Community
Apr 26, 2026 · Databases

Why PostgreSQL Is the Better Choice in 99% of Scenarios

The article argues that relying on many specialized databases creates operational complexity, higher costs, and maintenance overhead, while PostgreSQL’s extensible ecosystem—offering full‑text search, vector, time‑series, JSONB, and more—delivers comparable or superior algorithms, proven performance, and a simpler, more reliable stack for the vast majority of use cases, especially in AI applications.

AIPostgreSQLdatabase
0 likes · 19 min read
Why PostgreSQL Is the Better Choice in 99% of Scenarios
IoT Full-Stack Technology
IoT Full-Stack Technology
Apr 24, 2026 · Databases

Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?

The article compares PostgreSQL and MySQL across data types, native sequences, extensions, monitoring tools, replication mechanisms, licensing, community governance, and MVCC implementation, showing why many Chinese tech giants favor PostgreSQL for complex, high‑consistency workloads while acknowledging MySQL’s strengths in simple web scenarios.

MVCCPostgreSQLdatabase comparison
0 likes · 9 min read
Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 22, 2026 · Databases

Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice

PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.

Apache AGEJSONBPostGIS
0 likes · 39 min read
Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice
Tech Ocean
Tech Ocean
Apr 19, 2026 · Backend Development

Day 10: Building a Multi‑Container FastAPI App with PostgreSQL, Redis, and Celery

This tutorial extends the previous FastAPI example by adding Redis caching and Celery asynchronous tasks, showing the project layout, a complete docker‑compose configuration, required Python packages, sample FastAPI and Celery worker code, startup commands, health‑check setup, and key takeaways.

FastAPIPostgreSQLPython
0 likes · 4 min read
Day 10: Building a Multi‑Container FastAPI App with PostgreSQL, Redis, and Celery
Cloud Architecture
Cloud Architecture
Apr 16, 2026 · Databases

EXPLAIN ANALYZE: The CT Scan That Triggers a Query Performance Revolution

When a core order‑query suddenly slowed from milliseconds to seconds, the team discovered that using PostgreSQL’s EXPLAIN ANALYZE revealed hidden plan regressions, outdated statistics, and index misuse, leading to a systematic, production‑grade methodology for diagnosing and fixing query performance issues.

EXPLAIN ANALYZEPerformance TroubleshootingPostgreSQL
0 likes · 32 min read
EXPLAIN ANALYZE: The CT Scan That Triggers a Query Performance Revolution
dbaplus Community
dbaplus Community
Apr 12, 2026 · Backend Development

Can PostgreSQL Replace Redis? Performance, Cost, and Migration Insights

This article examines how PostgreSQL can take over Redis' roles—caching, pub/sub, and job queues—by leveraging unlogged tables, LISTEN/NOTIFY, and SKIP LOCKED, presenting cost savings, benchmark results, migration steps, and code examples for a practical backend replacement.

BackendPostgreSQLRedis
0 likes · 17 min read
Can PostgreSQL Replace Redis? Performance, Cost, and Migration Insights
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 9, 2026 · Databases

Master PostgreSQL Full-Text Search: From Basics to Advanced Chinese Tokenization

This article explains PostgreSQL's native full‑text search, its core concepts of tsvector and tsquery, demonstrates how to use built‑in functions and operators, compares built‑in, zhparser, and pg_search extensions for Chinese tokenization, and provides best‑practice tips for indexing, triggers, and performance optimization.

BM25Chinese tokenizationDatabase Indexing
0 likes · 14 min read
Master PostgreSQL Full-Text Search: From Basics to Advanced Chinese Tokenization
java1234
java1234
Apr 7, 2026 · Databases

Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths

The article analyzes why many Chinese cloud providers and enterprises prefer PostgreSQL to MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while acknowledging MySQL's remaining advantages in specific scenarios.

MVCCPostgreSQLdatabase comparison
0 likes · 10 min read
Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths
ITPUB
ITPUB
Apr 4, 2026 · Databases

How PostgreSQL and SQL Server Differ in Data Access Strategies

This article compares PostgreSQL and SQL Server data access methods—including sequential scans, index scans, bitmap heap scans, index‑only scans, and parallel query execution—highlighting PostgreSQL's lack of clustered indexes and the performance implications of each approach.

Bitmap ScanIndex ScanParallel Query
0 likes · 10 min read
How PostgreSQL and SQL Server Differ in Data Access Strategies
MaGe Linux Operations
MaGe Linux Operations
Apr 1, 2026 · Databases

Master PostgreSQL 17 Locks: From Fundamentals to Advanced Monitoring & Optimization

This comprehensive guide explores PostgreSQL 17's lock mechanisms, covering lock classifications, table‑ and row‑level lock behavior, MVCC interaction, common pitfalls such as deadlocks and lock contention, and provides practical SQL queries, Bash monitoring scripts, advisory‑lock techniques, and best‑practice recommendations for performance tuning and reliable production deployment.

AdvisoryLocksDeadlockLocks
0 likes · 36 min read
Master PostgreSQL 17 Locks: From Fundamentals to Advanced Monitoring & Optimization
Architect's Guide
Architect's Guide
Mar 29, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL

Amid China's push for independent, cloud‑native databases, leading firms like Tencent, Alibaba, Huawei and others have built PostgreSQL‑based solutions, and this article analyzes why PostgreSQL’s richer data types, true sequence objects, extensible ecosystem, advanced replication and licensing advantages make it a preferred choice over MySQL.

PostgreSQLdatabase comparisonextensions
0 likes · 9 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL
ITPUB
ITPUB
Mar 27, 2026 · Databases

AI’s Impact on Open‑Source Databases: MySQL, PostgreSQL, and AliSQL DuckDB

In 2026 the database ecosystem faces fierce competition between MySQL and PostgreSQL, while AI emerges as a new driver prompting open‑source projects like AliSQL to release DuckDB, vector engines and intelligent CLI, reshaping how relational databases serve both transactional and analytical workloads.

AIAliSQLDuckDB
0 likes · 15 min read
AI’s Impact on Open‑Source Databases: MySQL, PostgreSQL, and AliSQL DuckDB
Ray's Galactic Tech
Ray's Galactic Tech
Mar 26, 2026 · Backend Development

Why Go + PostgreSQL + sqlc Is the Secret to High‑Concurrency Backend Architecture

This article explains how combining Go, PostgreSQL, and sqlc creates a Zero‑ORM architecture that restores SQL to the center of high‑performance, highly controllable, and maintainable backend services, covering design principles, layer responsibilities, schema and query patterns, connection‑pool tuning, transaction handling, observability, and practical best‑practice checklists.

Backend ArchitectureGoPostgreSQL
0 likes · 36 min read
Why Go + PostgreSQL + sqlc Is the Secret to High‑Concurrency Backend Architecture
AI Waka
AI Waka
Mar 26, 2026 · Cloud Computing

Unlock Faster, Smarter Cloud SQL Management with Gemini CLI’s Agent Skills

The article explains how Gemini CLI’s shift from traditional Tools to progressive Agent Skills streamlines Cloud SQL for PostgreSQL extensions, reducing context overload, enabling on‑demand skill loading, zero‑manual installation, and cross‑platform execution, and provides step‑by‑step commands for exploring and using these new capabilities.

CLI extensionsCloud SQLGemini CLI
0 likes · 7 min read
Unlock Faster, Smarter Cloud SQL Management with Gemini CLI’s Agent Skills
dbaplus Community
dbaplus Community
Mar 15, 2026 · Databases

Why MySQL Is Falling Behind PostgreSQL: Commit Trends and Oracle’s Role

The article examines the sharp decline in MySQL’s commit activity since its 2006‑2007 peak, compares recent DB‑Engines rankings that show PostgreSQL overtaking MySQL, and attributes the downturn to Oracle’s management practices, technical setbacks, reduced open‑source community engagement, and a shift toward proprietary alternatives.

Database TrendsOraclePostgreSQL
0 likes · 7 min read
Why MySQL Is Falling Behind PostgreSQL: Commit Trends and Oracle’s Role
dbaplus Community
dbaplus Community
Mar 4, 2026 · Databases

Master PostgreSQL Execution Plans to Supercharge Your SQL Performance

This guide explains what PostgreSQL execution plans are, how they are generated, and how to interpret them using EXPLAIN and EXPLAIN ANALYZE, then demonstrates three real‑world case studies that show step‑by‑step optimizations with indexes, configuration tweaks, and query rewrites to dramatically improve query speed.

Database PerformanceIndexingPostgreSQL
0 likes · 16 min read
Master PostgreSQL Execution Plans to Supercharge Your SQL Performance
Ops Community
Ops Community
Mar 3, 2026 · Databases

Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning

This comprehensive guide walks you through PostgreSQL 17 deployment, explains its multi‑process architecture and MVCC model, details environment requirements, shows essential configuration parameters, provides step‑by‑step backup and PITR procedures, demonstrates streaming replication setup, and shares best‑practice tuning, security, and monitoring tips for reliable production use.

HAPerformance TuningPostgreSQL
0 likes · 24 min read
Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning
AI Explorer
AI Explorer
Mar 2, 2026 · Industry Insights

AI Technology Daily: Key AI Industry Updates March 2, 2026

A concise roundup of major AI developments on March 2, 2026, covering Palantir's stock surge linked to Anthropic tech in a US airstrike, OpenAI's controversial DoD agreement, breakthroughs in large‑model optimization, PostgreSQL scaling, competitive wins, new recommendation systems, open‑source model releases, and emerging research from top universities.

AIAnthropicCVRP
0 likes · 7 min read
AI Technology Daily: Key AI Industry Updates March 2, 2026
SpringMeng
SpringMeng
Feb 26, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article analyzes why many leading Chinese tech firms adopt PostgreSQL despite MySQL’s popularity, detailing PostgreSQL’s richer data types, native sequence support, extensible ecosystem, advanced monitoring tools, robust replication, open‑source licensing, and MVCC implementation, while also acknowledging MySQL’s strengths in simple deployment and read‑heavy workloads.

MVCCPostgreSQLdatabase comparison
0 likes · 9 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
ITPUB
ITPUB
Feb 20, 2026 · Databases

Master PostgreSQL Health Checks with Open‑Source SKILL Scripts

This guide introduces a collection of PostgreSQL SKILL scripts for automated health checks and operational analysis, explains the repository layout, shows how to run individual or full daily checks, lists all available skills, and provides a sample report with actionable recommendations.

PostgreSQLSQLdatabase monitoring
0 likes · 11 min read
Master PostgreSQL Health Checks with Open‑Source SKILL Scripts