BestHub
Sign in
dbaplus Community
Author

dbaplus Community

Enterprise-level professional community for Database, BigData, and AIOps. Daily original articles, weekly online tech talks, monthly offline salons, and quarterly XCOPS&DAMS conferences—delivered by industry experts.

2.3k
Articles
1
Likes
2.2k
Views
0
Comments
Recent Articles

Latest from dbaplus Community

100 recent articles max
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.

AIDatabaseFull-Text Search
0 likes · 19 min read
Why PostgreSQL Is the Better Choice in 99% of Scenarios
dbaplus Community
dbaplus Community
Apr 26, 2026 · Operations

Why the Lsof Command Is an Underrated Lifesaver in Production

The article explains how the Linux lsof utility can quickly identify port conflicts, lingering deleted files, and file‑handle leaks, offering practical commands, real‑world case studies, advanced options, performance tips, and integration techniques for effective system troubleshooting.

LinuxPerformance Optimizationfile handles
0 likes · 12 min read
Why the Lsof Command Is an Underrated Lifesaver in Production
dbaplus Community
dbaplus Community
Apr 25, 2026 · Backend Development

From Zero to One: Complete Architecture Design for a Billion‑Scale Short‑Video System

This article dissects the end‑to‑end architecture of a billion‑scale short‑video platform, detailing layered design, core services such as upload, transcoding, recommendation, interaction, storage, and the key challenges of massive video storage, high‑concurrency streaming, low‑latency playback, and real‑time recommendation reliability.

MicroservicesStorage OptimizationSystem Architecture
0 likes · 19 min read
From Zero to One: Complete Architecture Design for a Billion‑Scale Short‑Video System
dbaplus Community
dbaplus Community
Apr 22, 2026 · Fundamentals

Is UDP Really Faster Than TCP? A Deep Dive into Their Speed Trade‑offs

This article analytically compares UDP and TCP, detailing UDP’s minimalist design, low‑latency advantages, lack of congestion control and broadcast capabilities, while also explaining TCP’s reliability, congestion‑aware throughput and suitability for large or critical data, helping readers choose the optimal protocol for specific scenarios.

LatencyNetwork ProtocolsReal-time communication
0 likes · 12 min read
Is UDP Really Faster Than TCP? A Deep Dive into Their Speed Trade‑offs
dbaplus Community
dbaplus Community
Apr 20, 2026 · Operations

Unlock Lightning‑Fast Log Troubleshooting with Grep, Sed, and Awk

When a massive Nginx outage struck on a Double‑Eleven night, the author solved the crisis in seconds using a single‑line grep‑sed‑awk pipeline, then explains why these three Unix tools remain essential for any SRE or sysadmin dealing with huge log files.

GrepPerformanceShell scripting
0 likes · 38 min read
Unlock Lightning‑Fast Log Troubleshooting with Grep, Sed, and Awk
dbaplus Community
dbaplus Community
Apr 19, 2026 · Databases

Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search

This guide explains how traditional relational databases and SQL struggle with semantic queries needed for AI applications, introduces vector databases and HNSW indexing for efficient similarity search, compares their architectures, and presents a real‑world fraud detection system that combines both technologies.

AIB+TreeHNSW
0 likes · 17 min read
Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search
dbaplus Community
dbaplus Community
Apr 18, 2026 · Cloud Native

How Code Container Lets AI Coders Run with Root Access Safely in Seconds

The article introduces Code Container, an open‑source Docker‑based solution that gives AI coding assistants like Claude Code, OpenCode, and Codex full root and network privileges within isolated containers, explains its lightweight design, installation steps, workflow, and how it boosts productivity while maintaining system safety.

AICLICode Container
0 likes · 9 min read
How Code Container Lets AI Coders Run with Root Access Safely in Seconds