A knowledge-sharing platform for Sohu's technology products. As a leading Chinese internet brand with media, video, search, and gaming services and over 700 million users, Sohu continuously drives tech innovation and practice. We’ll share practical insights and tech news here.
This article examines MySQL InnoDB deadlocks by analyzing error logs, explaining the two‑phase locking protocol and various lock types, demonstrates how to reproduce a deadlock scenario, categorizes lock behaviors, and offers practical strategies to prevent and monitor deadlocks in database applications.
This guide explains why Apple now mandates UIScene for all UIKit apps built with the latest SDK after iOS 26, how UIScene differs from the traditional UIApplicationDelegate model, and provides step‑by‑step instructions—both automated and manual—for Flutter developers to migrate their iOS projects and plugins.
As multimodal AI models become capable of generating realistic images, videos, and audio, the OpenMMSec benchmark provides a comprehensive, open‑source dataset and evaluation metrics that help researchers and developers detect and localize AI‑generated forgeries across all three modalities, addressing emerging security challenges.
Androidify lets users create personalized Android robot avatars by uploading selfies and using AI-powered image verification, description generation, and custom rendering, with the app built on Jetpack Compose, CameraX, Firebase AI Logic, Gemini, and ML Kit, available on both web and Google Play.
Learn a quick, step‑by‑step method to capture a website’s UI, convert it into a design.json file, and use that JSON to guide AI tools in producing a visually faithful web page without the tell‑tale purple gradient.
Facing 200‑second peak compile times, the FoxFriend iOS team replaced CocoaPods with Swift Package Manager and introduced a three‑layer interface‑implementation‑service architecture, reducing average incremental builds from 120 seconds to 50 seconds, saving 3.1 developer‑hours per day and achieving a 58% overall compile‑time reduction.
This article explores the technical architecture of Android dynamic photos, detailing the three‑layer file structure, XMP metadata specifications, and differences among Xiaomi Micro Video, Google Motion Photo, and OPPO O Live Photo, and provides a unified Kotlin solution for detection, parsing, and playback.
PixelPrompt is a Dart-based terminal UI (TUI) framework that brings Flutter‑style declarative UI, component hierarchy, layout engines, and efficient ANSI‑based rendering to the console, using character cells, double buffering, and diff rendering to create interactive, styled terminal applications.
An open-source, Kaggle‑ranked solution for the Mitsui Commodity Prediction Challenge details data preprocessing, feature engineering, and multiple tree‑based modeling strategies—including multi‑target, single‑target, and price‑difference models—with code, evaluation metrics, and suggestions for further improvements.
This article compares MySQL’s SELECT DISTINCT and GROUP BY clauses, explaining their syntax, functional differences, performance implications, and ideal scenarios through detailed examples, index usage analysis, and a feature comparison table, helping developers choose the right approach for deduplication or aggregation tasks.
