ITPUB
Author

ITPUB

Official ITPUB account sharing technical insights, community news, and exciting events.

2.8k
Articles
0
Likes
899
Views
0
Comments
Recent Articles

Latest from ITPUB

100 recent articles max
ITPUB
ITPUB
Mar 16, 2026 · Artificial Intelligence

Why OpenClaw Failed and 7 Safer Open‑Source AI Assistants to Choose

OpenClaw’s rapid rise and fall in early 2026 exposed severe security flaws, high deployment costs, and usability issues, prompting a wave of lightweight, secure, and locally‑run AI assistant alternatives that address these shortcomings with smaller codebases, sandboxed execution, and broader platform support.

AI AssistantOpenClawalternatives
0 likes · 12 min read
Why OpenClaw Failed and 7 Safer Open‑Source AI Assistants to Choose
ITPUB
ITPUB
Mar 8, 2026 · Fundamentals

How Valerie Aurora’s Tiny Kernel Patch Saved Billions of Disk Writes

Valerie Aurora, a pioneering Linux kernel developer, introduced a concise relative‑atime patch that dramatically reduces unnecessary disk writes, improving performance and energy efficiency while maintaining compatibility with software that relies on access‑time information.

FilesystemKernelLinux
0 likes · 6 min read
How Valerie Aurora’s Tiny Kernel Patch Saved Billions of Disk Writes
ITPUB
ITPUB
Mar 7, 2026 · Backend Development

Transform Messy Code with DDD + CQRS: A Practical Guide for Clean Architecture

Learn how to break the cycle of unreadable, tangled code by applying Domain-Driven Design and Command-Query Responsibility Segregation, with concrete examples, step-by-step refactoring, architecture diagrams, code snippets, and practical tips for gradually adopting these patterns in real-world backend projects.

CQRSDDDDomain Modeling
0 likes · 16 min read
Transform Messy Code with DDD + CQRS: A Practical Guide for Clean Architecture
ITPUB
ITPUB
Mar 5, 2026 · Databases

How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide

This article explains what the Oracle TRUNCATE command does, why recovery is challenging, and provides detailed step‑by‑step instructions for four practical tools—FY_Recover_Data, ODU, BBED, and GDUL—to restore data from a mistakenly truncated table.

Data RecoveryDatabase AdministrationOracle
0 likes · 5 min read
How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide
ITPUB
ITPUB
Mar 3, 2026 · Databases

Why Is Installing Modern Databases Still So Painful?

Even in 2026, installing databases like Oracle remains a complex, error‑prone process, and this article explores the historical roots, recent AI‑assisted attempts, and four key reasons why database installation still challenges engineers.

AIDevOpsInstallation
0 likes · 8 min read
Why Is Installing Modern Databases Still So Painful?
ITPUB
ITPUB
Mar 2, 2026 · Backend Development

Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems

This article explains why traditional offset‑based pagination can cause duplicate or missing records when data changes, compares three practical solutions—including cursor pagination with timestamp + unique key, fixed‑window timestamp filtering, and Elasticsearch’s search_after/scroll methods—detailing their implementation, pros, cons, and suitable scenarios.

CursorElasticsearchPagination
0 likes · 14 min read
Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems
ITPUB
ITPUB
Feb 24, 2026 · Databases

Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day

A real‑world MySQL incident shows that using INSERT … SELECT without proper indexing can cause full‑table scans and progressive row locks, leading to massive payment failures, but adding an index on the filter column prevents the lock and restores safe batch migration.

INSERT SELECTIndexMySQL
0 likes · 8 min read
Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day
ITPUB
ITPUB
Feb 23, 2026 · Operations

How to Quickly Test Network Speed on Linux Using Ping, Curl, iperf, and iftop

Learn several straightforward Linux commands—ping for latency, curl or wget for download throughput, iperf for precise bandwidth measurement, and iftop for real‑time traffic monitoring—to accurately assess network speed and stability, with example syntax and usage tips for both client and server setups.

LinuxNetwork Speedcurl
0 likes · 5 min read
How to Quickly Test Network Speed on Linux Using Ping, Curl, iperf, and iftop
ITPUB
ITPUB
Feb 22, 2026 · Backend Development

Designing a Cost‑Controlled “Cut‑One‑Knife” Promotion Engine for Massive Concurrency

This article breaks down the algorithm and architecture behind Pinduoduo's "cut‑one‑knife" promotion, explaining how dynamic pricing based on user value, Zeno’s paradox, Redis atomic operations, and anti‑fraud measures ensure users receive phones without the platform incurring losses even under massive traffic and bot attacks.

High ConcurrencyZeno paradoxanti-fraud
0 likes · 8 min read
Designing a Cost‑Controlled “Cut‑One‑Knife” Promotion Engine for Massive Concurrency