BestHub
Sign in
Tagged articles

PostgreSQL

571 articles · Page 1 of 6
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 agentsDockerInsForge
0 likes · 11 min read
One‑Command Install, MCP Direct Connect: AI‑Powered Production with InsForge
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
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.

IndexingMemoryMigration
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.

MigrationPartitioningPostgreSQL
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.

AIAgentDatabases
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-GCMDatabasusDocker
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.

AIDBOSDatabase Architecture
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.

AIDatabasePostgreSQL
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.

ColdFrontData LakeDuckDB
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.

Enterprise ArchitectureMongoDBPostgreSQL
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.

BackupCDCHA
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.

DockerMulticaPostgreSQL
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.

BackupCDCHigh Availability
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 AgentHybrid RetrievalKnowledge Graph
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 PoolMigrationPostgreSQL
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.

MySQLPostgreSQLdatabase 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.

Database deploymentGUI clientMySQL
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.

DatabaseFull-text SearchIndexing
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 cacheMyBatisPostgreSQL
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.

ClickHouseData WarehouseHive
0 likes · 25 min read
Stunning SQL Queries: From Tetris Game to Real‑Time Funnels
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.

Data TypesDatabase ComparisonExtensions
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.

AIDatabaseExtensions
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.

Database ComparisonExtensionsMVCC
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 AGEFull-text SearchJSONB
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.

Docker ComposePostgreSQLPython
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 ANALYZEPostgreSQLQuery Optimization
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.

MigrationPostgreSQLRedis
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 TokenizationFull-text Search
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.

Database ComparisonExtensionsLicensing
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 ScanDatabase ComparisonIndex Scan
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.

Database ComparisonExtensionsMySQL
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.

AIAliSQLDatabase
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 ArchitectureDatabase DesignGo
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.

Agent SkillsCLI extensionsCloud SQL
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 trendsMySQLOracle
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.

BackupDatabase AdministrationHA
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.

Database ComparisonExtensionsMVCC
0 likes · 9 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
php Courses
php Courses
Feb 25, 2026 · Backend Development

Why Choose PDO Over mysqli? A Complete Guide to PHP Database Connections

This guide explains the advantages of using PDO instead of mysqli for PHP database connections, walks through MySQL and PostgreSQL setup with detailed code examples, recommended configuration options, and a checklist for troubleshooting common connection errors.

DatabaseMySQLPDO
0 likes · 7 min read
Why Choose PDO Over mysqli? A Complete Guide to PHP Database Connections
LuTiao Programming
LuTiao Programming
Feb 21, 2026 · Backend Development

Stop Building Chaotic Payment Systems: A Complete Design Methodology for Payment Domains

The article presents a production‑grade, modular design methodology for payment domain systems, detailing five core modules, essential principles such as idempotency and ACID, concrete implementation examples with Kafka, Redis, PostgreSQL, and guidance on risk, compliance, and high‑availability engineering.

Distributed ArchitectureIdempotencyKafka
0 likes · 8 min read
Stop Building Chaotic Payment Systems: A Complete Design Methodology for Payment Domains
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.

Database MonitoringPostgreSQLSQL
0 likes · 11 min read
Master PostgreSQL Health Checks with Open‑Source SKILL Scripts
Architect's Guide
Architect's Guide
Feb 3, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL – Key Benefits

Amid rising demand for open‑source, self‑controlled databases in China, major firms such as Tencent, Alibaba, and Huawei have built PostgreSQL‑based distributed, cloud‑native solutions, citing PostgreSQL’s richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, and true open‑source licensing as decisive advantages over MySQL.

Database ComparisonExtensionsMySQL
0 likes · 10 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL – Key Benefits
Java Companion
Java Companion
Feb 1, 2026 · Databases

How I Completed a 100+ Table Migration in One Month Using Navicat Tricks

In under a month the author migrated more than 100 heterogeneous tables from MySQL and MongoDB to PostgreSQL across isolated networks by automating Navicat's import/export logic, streaming data, handling special characters, configuring flexible sync strategies, and using OSS as a bridge to avoid OOM and lock‑contention.

Data MigrationMongoDBMySQL
0 likes · 20 min read
How I Completed a 100+ Table Migration in One Month Using Navicat Tricks
DevOps Coach
DevOps Coach
Jan 31, 2026 · Databases

7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance

The article reveals seven common PostgreSQL architectural oversights—such as neglecting vacuum, misusing UUID primary keys, treating the database as a queue, missing indexes, over‑relying on ORMs, ignoring write‑side scaling, and failing to partition large tables—that silently degrade performance and reliability, and provides concrete fixes and best‑practice configurations.

IndexingORMPartitioning
0 likes · 7 min read
7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance
ITPUB
ITPUB
Jan 31, 2026 · Databases

How OpenAI Scaled PostgreSQL to Support 800 Million Users and Millions of QPS

OpenAI’s engineering team expanded a single‑primary PostgreSQL cluster with nearly 50 read‑only replicas, migrated write‑heavy workloads to Azure Cosmos DB, and applied extensive optimizations to reliably serve the global traffic of ChatGPT and the OpenAI API for 800 million users at multi‑million queries per second.

AzureHigh AvailabilityPostgreSQL
0 likes · 24 min read
How OpenAI Scaled PostgreSQL to Support 800 Million Users and Millions of QPS
macrozheng
macrozheng
Jan 27, 2026 · Databases

Why Leading Companies Choose PostgreSQL Over MySQL: A Technical Comparison

This article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, native sequences, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while also acknowledging MySQL's strengths in simplicity and read‑heavy web workloads.

ComparisonExtensionsPostgreSQL
0 likes · 9 min read
Why Leading Companies Choose PostgreSQL Over MySQL: A Technical Comparison
AI Engineering
AI Engineering
Jan 24, 2026 · Databases

Can One PostgreSQL Instance Power 800 Million Users? OpenAI’s Trade‑offs Unpacked

OpenAI runs a single primary PostgreSQL with about 50 replicas to serve roughly 800 million ChatGPT users, employing PgBouncer connection pooling, cache‑lock mechanisms, query and schema optimizations, workload isolation, multi‑layer throttling, and cascade replication, while acknowledging the architecture’s limits and the complexity of full sharding.

Azure CosmosDBCascade ReplicationDatabase Scaling
0 likes · 8 min read
Can One PostgreSQL Instance Power 800 Million Users? OpenAI’s Trade‑offs Unpacked
Radish, Keep Going!
Radish, Keep Going!
Jan 23, 2026 · Databases

How OpenAI Really Scaled PostgreSQL for Hundreds of Millions of Users

The article debunks OpenAI's sensational claim of handling 800 million ChatGPT users with a single PostgreSQL instance, revealing a pragmatic hybrid architecture that combines many read replicas, Azure CosmosDB for write‑heavy workloads, and top‑tier hardware, while highlighting cost and complexity considerations.

Azure CosmosDBDatabase ArchitecturePostgreSQL
0 likes · 6 min read
How OpenAI Really Scaled PostgreSQL for Hundreds of Millions of Users
java1234
java1234
Jan 20, 2026 · Databases

Why Do Some Projects Still Choose MySQL Over PostgreSQL?

The article compares PostgreSQL and MySQL, detailing PostgreSQL’s richer data types, true sequence support, extensible ecosystem, advanced monitoring and replication features, while also acknowledging MySQL’s simplicity and strong points, to help readers decide which database fits their workload best.

Database ComparisonExtensionsMVCC
0 likes · 9 min read
Why Do Some Projects Still Choose MySQL Over PostgreSQL?
Architect's Tech Stack
Architect's Tech Stack
Jan 19, 2026 · Databases

Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why major Chinese cloud providers and enterprises are building PostgreSQL‑based distributed, cloud‑native databases instead of MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced replication, licensing advantages, and MVCC implementation, while also noting MySQL's remaining strengths.

Data TypesDatabase ComparisonExtensions
0 likes · 10 min read
Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
dbaplus Community
dbaplus Community
Jan 18, 2026 · Databases

Avoid These Common SQL Performance Pitfalls for Faster Queries

This guide enumerates frequent misconceptions in SQL performance—from over‑indexing and SELECT * misuse to improper transaction handling and outdated monitoring practices—explains why they hurt efficiency, and provides concrete, version‑aware solutions to optimize queries, schema design, and database operations.

DatabaseMySQLOptimization
0 likes · 26 min read
Avoid These Common SQL Performance Pitfalls for Faster Queries
Java Companion
Java Companion
Jan 18, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, true sequence support, powerful extensions, built‑in monitoring, advanced replication, open‑source licensing, and MVCC implementation, while acknowledging MySQL's strengths in quick deployment and read‑heavy workloads.

Database ComparisonExtensionsMVCC
0 likes · 10 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jan 13, 2026 · Databases

Turn PostgreSQL into a Graph Database with Apache AGE

This guide explains how Apache AGE extends PostgreSQL with OpenCypher‑compatible graph capabilities, covering architecture, installation, storage schema, Cypher‑SQL integration, common graph operations, and a LangChain example that turns natural‑language questions into executable graph queries.

Apache AGECypherGraph Database
0 likes · 11 min read
Turn PostgreSQL into a Graph Database with Apache AGE
dbaplus Community
dbaplus Community
Jan 11, 2026 · Databases

Why Using Only Postgres Can Replace Redis, RabbitMQ, and Elasticsearch

The article argues that a single PostgreSQL instance can handle caching, queuing, full‑text search, and real‑time notifications, eliminating the need for separate services like Redis, RabbitMQ, and Elasticsearch, while reducing cost and complexity.

Database ConsolidationFull-text SearchMessage Queue
0 likes · 12 min read
Why Using Only Postgres Can Replace Redis, RabbitMQ, and Elasticsearch
Efficient Ops
Efficient Ops
Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

Database ComparisonGISJSONB
0 likes · 9 min read
Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained
Ray's Galactic Tech
Ray's Galactic Tech
Jan 2, 2026 · Databases

How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs

PostgreSQL offers four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—each preventing specific concurrency anomalies like dirty reads, non‑repeatable reads, and phantom reads, and the article explains their behavior, configuration commands, practical usage, performance trade‑offs, and production best practices.

PostgreSQLSQLTransaction Isolation
0 likes · 9 min read
How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs
Ray's Galactic Tech
Ray's Galactic Tech
Dec 30, 2025 · Databases

When to Combine PostgreSQL and MongoDB: A Practical Guide for Enterprise Architecture

This article explains why modern enterprises should avoid single‑database solutions, compares PostgreSQL and MongoDB across core philosophy, technical capabilities, ecosystem extensions, and cost, and provides a decision framework, real‑world case studies, and a hybrid architecture blueprint for scalable, low‑risk systems.

MongoDBPostgreSQLhybrid architecture
0 likes · 9 min read
When to Combine PostgreSQL and MongoDB: A Practical Guide for Enterprise Architecture
Ray's Galactic Tech
Ray's Galactic Tech
Dec 29, 2025 · Databases

Mastering PostgreSQL Backup & Replication: A Complete Enterprise Guide

An in‑depth enterprise guide explains why backup and replication are critical for PostgreSQL, compares physical, logical, and logical replication methods, provides step‑by‑step command examples, outlines high‑availability architectures, automation scripts, disaster‑recovery procedures, monitoring queries, and common pitfalls to ensure robust data protection.

Disaster RecoveryHigh AvailabilityPostgreSQL
0 likes · 8 min read
Mastering PostgreSQL Backup & Replication: A Complete Enterprise Guide
ITPUB
ITPUB
Dec 29, 2025 · Databases

Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25

VectorChord‑BM25 is a PostgreSQL extension that adds native BM25 ranking and tokenization, delivering up to three‑fold query‑per‑second improvements over ElasticSearch while maintaining comparable relevance scores, and includes detailed installation, usage examples, and performance analysis.

BM25Database ExtensionFull-text Search
0 likes · 17 min read
Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25
Alibaba Cloud Observability
Alibaba Cloud Observability
Dec 29, 2025 · Cloud Native

How Alibaba Cloud Log Service Supercharges Dify’s Scaling and Cuts DB Costs

This article examines Dify’s production‑scale bottlenecks caused by heavy PostgreSQL logging, explains why a cloud‑native log service (SLS) better matches the append‑only, high‑throughput nature of workflow logs, and provides a step‑by‑step migration guide that dramatically reduces database pressure, storage cost, and unlocks advanced analytics.

Alibaba Cloud Log ServiceCloud NativeDify
0 likes · 17 min read
How Alibaba Cloud Log Service Supercharges Dify’s Scaling and Cuts DB Costs
Top Architect
Top Architect
Dec 29, 2025 · Databases

Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why leading Chinese tech firms are increasingly adopting PostgreSQL instead of MySQL, detailing PostgreSQL‑based products, comparing data‑type support, sequence handling, extensions, monitoring tools, replication mechanisms, licensing, community openness, and MVCC implementation, while also outlining MySQL's limitations.

Database ComparisonMySQLOpen Source
0 likes · 11 min read
Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
DevOps Coach
DevOps Coach
Dec 26, 2025 · Databases

Achieving Sub‑Second Queries on 1.2 B‑Row PostgreSQL Using BRIN, pg_cron & Query Folding

The article recounts how a PostgreSQL instance on a modest 2‑CPU, 4 GB VM handling 1.2 billion rows was dramatically accelerated by adding BRIN indexes, scheduling maintenance with pg_cron, applying query folding and tuning memory and parallel settings, achieving sub‑second query times without additional hardware.

BRIN IndexPartitioningPostgreSQL
0 likes · 9 min read
Achieving Sub‑Second Queries on 1.2 B‑Row PostgreSQL Using BRIN, pg_cron & Query Folding
Ray's Galactic Tech
Ray's Galactic Tech
Dec 26, 2025 · Databases

Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops

This comprehensive guide explains PostgreSQL's Write-Ahead Logging (WAL) fundamentals, its role in durability, crash recovery, PITR and streaming replication, details the checkpoint mechanism, essential monitoring queries, production‑grade configuration recommendations, backup and recovery procedures, and practical DBA checklists for reliable operations.

Database AdministrationPostgreSQLWAL
0 likes · 7 min read
Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops
Data STUDIO
Data STUDIO
Dec 23, 2025 · Databases

Is the Vector Database Dead? PostgreSQL’s New pgvector Feature Puts Closed‑Source Solutions on the Spot

The article examines how PostgreSQL’s latest pgvector 0.8.0 release adds iterative index scans and smart query planning, enabling fully free vector search within an existing relational database, compares performance, cost, and architecture against dedicated vector databases like Pinecone, and outlines migration steps and best‑practice guidelines.

AIDatabasePostgreSQL
0 likes · 14 min read
Is the Vector Database Dead? PostgreSQL’s New pgvector Feature Puts Closed‑Source Solutions on the Spot
FunTester
FunTester
Dec 21, 2025 · Backend Development

Why River Is the Go‑Friendly Queue That Guarantees Transactional Consistency

This article explains how the River library leverages PostgreSQL to provide a Go‑native job queue with true transactional guarantees, high concurrency via goroutines, and efficient scheduling using SKIP LOCKED, while offering step‑by‑step setup and code examples for rapid adoption.

GoMessage QueuePostgreSQL
0 likes · 15 min read
Why River Is the Go‑Friendly Queue That Guarantees Transactional Consistency
Architect
Architect
Dec 19, 2025 · Databases

Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL – Key Advantages Explained

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, native sequence support, powerful extensions, superior monitoring and replication features, and open‑source licensing, while also noting MySQL's simplicity and ecosystem strengths, to explain why many Chinese enterprises choose PostgreSQL for their core databases.

Database ComparisonExtensionsMySQL
0 likes · 9 min read
Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL – Key Advantages Explained
Ray's Galactic Tech
Ray's Galactic Tech
Dec 16, 2025 · Databases

PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide

Choosing between PostgreSQL and MySQL isn’t just a feature checklist; it requires weighing business complexity, team expertise, and future uncertainty, with this guide offering core design philosophies, multi-dimensional capability comparisons, actionable decision paths, and real-world case studies to help you make a production-grade database choice.

GISMySQLPostgreSQL
0 likes · 12 min read
PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide
Java Companion
Java Companion
Dec 16, 2025 · Databases

Why Choose PostgreSQL Over MySQL? A Detailed Feature Comparison

The article compares PostgreSQL and MySQL across data types, sequence handling, extensions, monitoring tools, replication, licensing, and MVCC implementation, showing why many Chinese tech giants prefer PostgreSQL for complex, high‑availability workloads while acknowledging MySQL’s strengths in simple web scenarios.

Database ComparisonFeature analysisMVCC
0 likes · 8 min read
Why Choose PostgreSQL Over MySQL? A Detailed Feature Comparison
DevOps Coach
DevOps Coach
Dec 15, 2025 · Databases

Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming

The article explains how PostgreSQL has evolved from a simple relational store into a versatile platform that supports full‑text search, vector similarity, geospatial queries, JSONB, message queues, and analytical workloads, allowing developers to replace multiple specialized tools with a single unified system.

Database ExtensionsEvent StreamingFull-text Search
0 likes · 6 min read
Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming