Learn how to efficiently create, open, edit, and save Excel workbooks using Python’s openpyxl library, covering worksheet management, cell operations, merging, formatting, formulas, row/column iteration, and value-only extraction, with practical code examples for both small and large files.
This guide walks you through building a free Python Tkinter desktop application that merges multiple PNG or JPG images with background audio into a video using FFmpeg, covering environment setup, GUI design, file handling, log capture, video generation, and preview steps.
This article describes the challenges of private deployment for micro‑service architectures at JD's Transaction Center and presents a cloud‑native rapid‑deployment platform that uses standardized metadata, drag‑and‑drop component design, automated resource initialization, and probe‑based health checks to achieve fast, low‑cost, and reliable service rollout.
This tutorial demonstrates how to write a short Python script that continuously monitors for a USB drive, automatically copies its contents to a specified folder, and then shows how to package the script into a standalone Windows executable using PyInstaller with various options.
This guide shows how to set up an iPhone shortcut that instantly displays your health code with a single tap, detailing each step from adding the code to the home screen to configuring a trigger in the Accessibility settings.
This article describes how QA engineers automated the repetitive Excel‑based mapping and validation process of a valuation system by using Python pandas scripts to filter, compare, and export data, reducing manual effort from ten minutes to under one minute while improving accuracy and coverage.
This tutorial walks you through installing Selenium and ChromeDriver, configuring the environment, and using Python code to automatically navigate Dangdang's bestseller pages, extract book details with pyquery, and save the results into a CSV file for further analysis.
Learn how to use Postman for practical API testing by walking through three hands‑on examples—searching Baidu, interacting with WeChat’s public API, and triggering alerts on a specialized radio communication system—covering request setup, parameter handling, assertions, and common pitfalls.
This article provides a detailed tutorial on using various Python libraries such as xlrd, xlwt, xlutils, xlwings, openpyxl, XlsxWriter, win32com, and pandas for reading, writing, modifying, and visualizing Excel files, complete with code examples and best‑practice tips.
The article emphasizes that a well‑designed CI/CD pipeline should automate the entire build and deployment process into a single command or script, enabling new developers to produce deployable artifacts quickly, while warning against excessive manual steps that hinder efficiency.
DevOps combines development and operations into a unified lifecycle—continuous development, integration, testing, feedback, monitoring, deployment, and maintenance—offering faster delivery, improved collaboration, automated processes, and higher software quality, with tools such as Git, Jenkins, Docker, and Ansible supporting each phase.
This article explains the origins of DevOps, its evolution from agile practices, and how containers and Kubernetes enable a seamless, automated pipeline—from code checkout and build to testing, code analysis, artifact storage, image creation, and staged deployment—illustrated with real‑world Jenkins pipelines and logs.
This guide explains why static /etc/fstab entries can waste resources, introduces the autofs daemon for on‑demand mounting, and provides step‑by‑step commands and configuration examples to set up automatic CD‑ROM mounting on a Linux server.
This article explains the fundamentals and query process of the Domain Name System (DNS), then details Qunar's evolving DNS architecture—including the initial system, DNSDB management, DNS view, EDNS, HTTPDNS, and intelligent traffic switching—highlighting operational automation and security enhancements.
This article explores the fundamentals of IT monitoring, examines common challenges such as scalability, reliability, and alert fatigue, compares four implementation approaches—from open‑source to fully custom solutions—and presents practical techniques like alert convergence, suppression, and automation to build a robust, adaptable monitoring platform.
This article outlines the essential requirements, common challenges, and practical best‑practice guidelines for transitioning a monolithic system to a microservices architecture, emphasizing team autonomy, automation, resilience, and standardized development, deployment, and operations processes.
This article explores the complexity of IT operations, outlining common misconceptions, essential capabilities, organizational and individual pain points, and presents self‑help strategies such as SRE, DevOps, automation, and AIOps to achieve sustainable, scalable, and intelligent operations within enterprises.
This article compiles the 20 most common DevOps interview questions, providing detailed explanations of concepts such as the DevOps‑Agile distinction, core benefits, key tools, anti‑patterns, KPI metrics, automation advantages, containers, microservice frameworks, version control practices, Git revert techniques, post‑mortem meetings, asset vs configuration management, continuous testing elements, and essential development and infrastructure operations.
This article presents JD Daojia's practice of containerizing MySQL, detailing the underlying resource platform, custom container scheduling algorithm, high‑availability design, monitoring system, and an automated operations platform that together improve performance, cut costs, and boost operational efficiency.
This article describes Qunar's end‑to‑end automated workflow for detecting high‑risk Jar component vulnerabilities, collecting asset information, orchestrating remediation with a SOAR platform, and leveraging the TCDEV auto‑upgrade service to reduce manual effort and improve security operations efficiency.
This tutorial walks you through creating an interactive Excel weather dashboard using Python's xlwings and requests libraries, covering API selection, data retrieval, code integration, Excel macro setup, UI design, and dynamic updates for multiple Chinese cities.
This article shares three years of experience building an automated performance‑testing platform for Alibaba Cloud Elastic Compute, covering what performance testing is, how to design comprehensive tests for CPU, memory, storage, network and OS, and the essential skills engineers need to become true performance architects.
A sysadmin narrates how he monitors four Redis nodes, detects master failure with PING, promotes a slave using SLAVEOF, reconfigures the remaining replicas, and ultimately automates the entire process with a custom Sentinel program and a multi‑node Sentinel cluster for high availability.
This article explains the DevOps lifecycle—covering planning, coding, building, testing, releasing, deploying, operating, monitoring, and CI/CD—and lists popular tools for each stage to help teams achieve continuous delivery and efficient collaboration.
This article details ByteDance's evolution of chaos engineering platforms and high‑availability practices, covering service types, architectural upgrades, fault‑center design, explosion‑radius control, steady‑state algorithms, automated experiments, and future plans for resilient infrastructure.
The article explains that a successful outcome‑driven enterprise data strategy requires a well‑aligned technical roadmap covering architecture, governance, storage, analytics, automation and emerging technologies such as AI and blockchain, and offers practical steps for assessing readiness and prioritizing implementation.
Learn how to use Python to send real-time progress updates and completion alerts via email for long-running tasks such as model training, data processing, and financial modeling, by leveraging the email, smtplib, and MIME libraries to build customizable notifications with images and attachments.
Learn how to write a few lines of Python that continuously monitor for a USB drive, automatically copy its contents to a specified folder, and then package the script into a standalone Windows executable using PyInstaller with optional parameters for single‑file output, hidden console, and custom icons.
This guide shows Windows users how to programmatically change the desktop background using Python's ctypes library, walk through retrieving the script’s directory, filtering image files, selecting one at random, and applying it with SystemParametersInfoW, all without installing external packages.
This guide explains how to automate Linux tasks by configuring boot‑time services with chkconfig and rc.local, using the at command for one‑off jobs, and setting up recurring jobs with crontab, complete with syntax, examples, and practical shell script integration.
This guide explains why manual regression testing of a WeChat mini‑program becomes a bottleneck, compares Jest‑based SDK and Minium frameworks, shows how to set up the environment, write page‑object scripts, configure and run tests, generate reports, and troubleshoot common issues.
This article surveys the rapidly growing no-code and low-code ecosystem, explaining the concepts, distinguishing between no-code and low-code, and presenting a curated list of 145 startups across categories such as website builders, mobile app creators, internal tools, workflow automation, data platforms, finance, payments, commerce, analytics, and form builders.
The article details Ctrip's development of a cloud‑native AVD IaaS platform that leverages Kubernetes, Docker, and Android Virtual Devices to provide scalable, cost‑effective, and high‑availability mobile automated testing infrastructure, addressing hardware costs, performance, and operational challenges while supporting continuous integration pipelines.
This guide shows how to configure IntelliJ IDEA to automatically generate Javadoc class and method comments using file templates and live templates, including step‑by‑step settings, custom Groovy scripts for @param and @return, and verification of the results.
This guide explains the architecture of ADB, how to install it, and provides a comprehensive list of commands for connecting devices, managing apps, transferring files, capturing screenshots, controlling the shell, and performing performance analysis on Android devices.
This article explains what DevSecOps is, why integrating security into DevOps is essential in fast‑paced software delivery, outlines its key characteristics and benefits, and provides practical guidance on organizational, process, and tooling practices—including CI/CD pipelines and open‑source security tools.
Learn step-by-step how to use Python's Selenium library to automate login, scroll through QQ Space, extract historical posts and download album photos, including driver setup, code snippets for login, shuoshuo retrieval, and photo downloading, enabling you to preserve nostalgic content.
This guide walks you through installing AutoKey on Linux, configuring its UI, creating typo‑fix phrases, setting window filters, assigning hotkeys, and writing Python scripts to automate repetitive typing tasks, helping you streamline your workflow and reduce keystroke effort.
This article shares seven practical Python scripts—from web‑scraping Zhihu images and chatting bots to AI poem analysis, lottery generation, automatic apology letters, screen recording, and GIF creation—demonstrating how to avoid reinventing the wheel while learning useful automation techniques.
iQIYI’s technology team built a non‑intrusive robustness‑testing platform that injects engineered “dirty data” into intercepted HTTP responses via an ASM‑hooked SDK, letting users configure mutation rules through a web console and run UI, monkey, or manual tests that have already uncovered numerous hidden crashes, achieving over 50 % defect‑closure and markedly improving app stability.
Facing rising traffic, JD Daojia’s in‑house load‑testing platform was redesigned to automate script management, enable distributed JMeter execution, integrate real‑time monitoring, and support custom RPC protocols, dramatically lowering manual effort, cutting test cycles from an hour to fifteen minutes while ensuring system stability.
An operations engineer narrates how he monitors a four‑node Redis cluster, detects master failure with continuous PINGs, promotes a slave to master, reconfigures replicas, and automates the entire process with a sentinel program and a sentinel cluster for high availability.
This tutorial introduces Python's openpyxl library for reading, writing, and manipulating Excel files, covering installation, basic methods, and four practical examples including creating multiplication tables, inserting rows, transposing data, and importing text files into spreadsheets.
This article presents a collection of Python 3.6.4 scripts that demonstrate how to scrape Zhihu images, converse with chatbots, classify Tang poems using NLP, generate random lottery numbers, automatically compose apology letters, capture screen images, and create animated GIFs, providing practical code examples for each task.
This article explains how DevOps transforms software testing by moving from isolated, waterfall‑style testing to continuous, automated, shift‑left practices, and outlines best‑practice recommendations such as test automation, tool selection, metrics, documentation, and the role of test‑automation engineers.
This article explains how Python can automate everyday file‑management tasks—deleting old files, sorting files by type, and scheduling the process with crontab—by providing clear step‑by‑step code examples that turn repetitive work into a few seconds of effort.
This tutorial explains how to set up Python and Appium on a PC, configure Android SDK and device debugging, and write a Python script that automatically reads and replies to QQ messages on an Android phone.
This guide shows how to use Python to post text, markdown, and image‑text (news) messages to a WeChat Work webhook, covering required headers, payload structures, and example code for each message type.
This article explains what a CI/CD pipeline is, why it is essential for DevOps, outlines its standard stages, discusses implementation steps and tool‑selection principles, highlights current cloud‑native trends, and warns against common anti‑patterns that can hinder continuous delivery.
This article introduces the Jenkins Deploy Dashboard plugin, explains how to visualize deployment status across environments, and provides step‑by‑step instructions with code examples for adding deployments to the dashboard, creating the view, and adding deployment buttons to pipelines.
The article describes how a rapidly growing development team built a one‑click, cloud‑native platform that automates the provisioning, configuration, Docker image creation, and Kubernetes deployment of diverse test environments, addressing challenges such as heterogeneous tech stacks, middleware variety, and configuration inconsistencies.
This article presents fifteen practical Linux command‑line techniques—including quick file truncation, large file generation, secure disk wiping, system‑disk creation, process runtime inspection, real‑time log monitoring, timestamp conversion, execution timing, ASCII lookup, handling garbled filenames, retrieving public IP, batch downloading, and command‑history shortcuts—to help users automate tasks and improve efficiency.
This article compiles a comprehensive set of Bash scripts that automate common Linux server tasks such as file consistency checks, log cleanup, network traffic monitoring, port scanning, user management, firewall rules, and service health checks, providing sysadmins with ready‑to‑use solutions for efficient operations.
ByteDance’s cloud‑native migration of stateful services uses a custom SolarService extending StatefulSet with Budset CRD to handle versioned data, shard‑aware routing, NUMA‑aware scheduling, advanced storage, eBPF monitoring, and automated PDB eviction, delivering efficiency, cost savings, and reliable rolling upgrades.
This article introduces latexify_py, an open‑source Python tool that automatically converts Python functions into LaTeX math expressions, dramatically simplifying the creation of complex formulas for research papers and eliminating the tedious manual editing in Word.
This article compiles a comprehensive set of Bash scripts that demonstrate how to verify file consistency across servers, schedule log cleaning, monitor network traffic, count numeric characters in files, manage users and passwords, automate firewall rules, and perform various other Linux system administration tasks, providing ready-to-use code snippets for each scenario.
This guide demonstrates how to use Python's requests library for sending GET, POST, and HTTPS requests, handling file uploads and downloads, managing timeouts, performing authentication, session and token handling, generating signatures, and organizing a complete API test automation framework.
This article explains why mesh regression is needed for 3D cloud design tools, defines mesh, outlines its application scenarios such as BIM plumbing, custom door windows, and hard‑floor tiles, and details a step‑by‑step design, implementation, bug detection methods, performance improvements, and future plans.
This article explains how combining real‑device operations with computer‑vision techniques creates an app‑agnostic automation framework that automatically adapts and validates page layouts across countless devices, apps, and business scenarios, dramatically reducing manual debugging, testing cost, and user‑experience risks.
The article outlines the six essential DevOps capabilities—collaboration, automation, continuous integration, continuous testing, continuous delivery, and continuous monitoring—explaining how each contributes to improving efficiency, reducing errors, and ensuring reliable software delivery in modern IT environments.
To streamline app quality assurance, a comprehensive mobile bug‑reporting SDK was built that automates screenshot, screen‑recording, network and log collection, auto‑fills device and app data, and integrates with the Max backend, reducing feedback latency and simplifying the reporting workflow for developers and testers.
This comprehensive guide walks you through Postman's core capabilities—including installation, interface navigation, sending requests, handling query parameters, forms, JSON and file uploads, response analysis, collection management, batch execution, logging, assertions, variables, pre‑request scripts, and request chaining—empowering developers and testers to automate and streamline API testing workflows.
Discover 15 essential Python packages—from data‑visualization tools like Dash to web frameworks such as Flask, multimedia libraries like Pygame, and utilities for JSON handling, progress bars, and home automation—each explained with key features, typical use‑cases, and illustrative code snippets.
This guide explains how to use ProxySQL's stats_mysql_query_digest to detect rarely accessed MySQL tables, export table lists, script the retrieval of last access times, and safely rename or drop unused tables after verification, helping reduce storage waste and metadata overhead.
This article chronicles Alibaba’s three‑year evolution of frontend intelligence, detailing the origins of AI‑driven code generation, key technologies like imgCook, BizCook and UICook, the methodology, toolchain, organizational integration, and future directions for boosting development efficiency and business value.
This article introduces PowerShell, explains its advantages over cmd and Linux shells, walks through launching it, and demonstrates essential commands such as get-help, get-command, get-process, and stop-process for managing Windows processes.
This article introduces Youzan's testing team, detailing its growth to over 120 engineers across three cities, the test‑development responsibilities, automation and load‑testing practices, quality‑assurance framework, training programs, and the open, growth‑focused team culture that candidates can expect.
This article explores the evolution from ProCode to LowCode and NoCode in front‑end development, detailing iceluna's challenges, the design of visual logic orchestration, node abstraction, automatic layout, schema‑code conversion, debugging features, and future prospects for low‑code adoption.
This guide explains why GitHub is slow in China due to DNS latency, shows how to manually edit the hosts file on various platforms, and demonstrates using the SwitchHosts tool to automate hosts updates, refresh DNS caches, and ensure reliable access to GitHub resources.
This article details how Fangduoduo built an integrated, cloud‑native CI/CD release system—combining Vue front‑end, Python back‑end, Jenkins, Gerrit, Docker Swarm and Kubernetes—to automate builds, deployments, version control, testing, and service maintenance, dramatically boosting development efficiency.
This article details the step‑by‑step creation of a Python‑based API automation testing framework, covering project structure, configuration files, a reusable logging module, HTTP request handling with requests, common utilities for Excel and XML, MySQL database access, email reporting, and the test runner setup.
The article presents a general solution that streamlines daily business issue diagnosis by aggregating multi‑service data via GraphQL, converting it into human‑readable semantics, and automatically detecting anomalies with a rule engine, enabling one‑click retrieval, reduced hand‑offs, and extensible monitoring for platforms such as Xianyu.
The article presents a three‑stage pipeline that automatically transforms Sketch design drafts into a DSL view tree, infers layout and style properties, and generates Meituan‑compatible static front‑end code, while offering visual tools for layer cleanup, component recognition, and property adjustment to ensure high‑fidelity mobile UI reproduction.
This article explains why modern enterprises need cloud‑native architecture, introduces the SESORA maturity model, and provides a detailed, practical walkthrough of deploying a cloud‑native application on Alibaba Cloud SAE, covering namespace creation, app configuration, SLB binding, service discovery, elasticity, observability, resilience, and automation.
This article examines the challenges of chain performance testing without branch handling, proposes logical branch controls and synchronized test termination, and provides concrete Java code examples to improve reliability and accuracy of load‑testing pipelines.
This step‑by‑step guide shows how to set up Python, Appium, JDK, Android SDK and a screen‑mirroring tool, connect an Android phone, verify the ADB connection, and run a complete Appium script that automatically reads and replies to QQ chats.
The article examines how the rapid adoption of cloud computing, DevOps, AIOps, and FinOps is reshaping the role of IT operations, highlighting new trends, evolving work boundaries, and the essential characteristics of a modern, automated, secure, and cost‑optimized operations system.
The article outlines six key DevSecOps best practices—including establishing a security model, enforcing governance policies, automating security tasks, training developers, applying network segmentation, and limiting administrative privileges—to help organizations overcome staffing and collaboration challenges while maintaining consistent security throughout the development and operations lifecycle.
The article examines how software testing has expanded beyond bug detection in 2021, covering left‑shift/right‑shift testing, cloud‑based cross‑browser testing, AI‑driven tools, Selenium’s evolution, IoT performance testing, QAOps, blockchain testing, cloud automation, and the emerging NoOps model.
The article details how an online education provider progressively enhanced its live‑streaming performance testing framework—from rudimentary "stone age" checks to automated, data‑driven "information age" practices—by restructuring services, refining test scenarios, introducing traffic replay, and automating script generation to achieve more reliable and efficient stability assurance.
This article details how the Anjuke mini‑program team tackled frequent, fragmented releases across multiple platforms by standardizing processes, introducing local SDK‑based uploads, integrating Jenkins, and ultimately building a platform‑based service with UI automation using Puppeteer, resulting in reduced cost, higher transparency, and scalable multi‑program support.
This article provides a comprehensive overview of modern DevOps practices and popular tools—including version control, containerization, orchestration, automation, collaboration, and monitoring—explaining their purposes, key features, and how they fit into the software delivery lifecycle.
This article walks through reading monthly rainfall data with pandas, cleaning missing values, calculating rainfall deviations, generating descriptive paragraphs, and rendering a formatted Word report using docxtpl, providing complete code snippets and example outputs for each step.
This guide walks you through essential Linux automation techniques—including boot‑time service startup with chkconfig and rc.d, one‑off scheduling using at, and recurring jobs with crontab and shell scripts—so you can manage web servers efficiently without manual intervention.
This article outlines how a bank’s DBA team transformed traditional, slow, and error‑prone database release processes into a fully automated DevOps pipeline, covering modeling tools, the DBgo release engine, monitoring, AI‑ops, and practical lessons from real‑world deployments.
The article explains that a successful outcome‑driven enterprise data strategy requires a well‑defined technical roadmap covering architecture, governance, storage, analytics, automation and emerging technologies such as AI and blockchain, all aligned with business priorities and goals.
This article outlines Youku's end‑to‑end service‑side quality assurance framework, detailing the factors that affect quality across the development lifecycle, the automated testing practices integrated into the release pipeline, the platform capabilities built for data collection and replay, and the metrics used to measure improvements in reliability and development efficiency.
This guide demonstrates how to set up Laravel Mix with the laravel-mix-template-minifier plugin to automatically compress Blade template files, configure watching scripts, enable boot-time execution, and optimize npm scripts to produce minified HTML, CSS, and JavaScript while preserving PHP code.
The article explains how digital transformation reshapes the customer journey in consumer finance, highlighting its definition, four key capabilities—automation, personalization, contextual interaction, and journey innovation—and outlining stages from acquisition to advocacy to guide firms in building comprehensive, data‑driven experiences.
This article provides a detailed shell-script tutorial for installing MySQL 5.7 on a Linux node, initializing the database, setting the root password, and automatically creating multiple user accounts with random passwords, suitable for operations and database administrators. The guide includes full script listings, explains repository configuration, service management, and error handling, making it a practical reference for DevOps engineers.
This article explains practical techniques for generating varied request parameters—such as random numbers, thread‑safe identifiers, random strings, and upstream data extraction—to avoid identical inputs in multi‑call performance tests and improve test reliability.
This article explores the challenges of building business UI components across PC, mobile, and mini‑app platforms, details a unified fusion development approach using React, Rax, and Alibaba’s Fusion toolchain, and shares practical solutions for tooling, build pipelines, and automated component publishing.
The article demonstrates how to configure API endpoints and use Java's Apache HttpClient to retrieve authentication cookies and perform subsequent requests, providing a full code example for beginners in interface automation testing.
This article introduces the fundamentals of full‑chain load testing, explains why it is essential for large‑scale distributed systems, outlines the DESP model with its four simulation dimensions, and presents a detailed case study of New Oriental's continuation‑class platform including architecture, data preparation, load design, automation and recruitment information.
This article explains how to install the Gooey library, convert a Python command‑line program into a graphical user interface using decorators and GooeyParser, explore the supported widget types, and finally package the GUI application into a standalone executable with PyInstaller.
This article compiles practical Linux shell commands for locating and moving files, batch extracting archives, using sed for text manipulation, checking directory existence, monitoring disk usage, analyzing logs, managing firewalls, and automating common sysadmin tasks, all presented with clear examples and explanations.
JApiDocs is a plug‑and‑play SpringBoot tool that automatically generates HTML API documentation and client models without extra annotations, offering quick setup, code‑as‑doc, multi‑platform support, and customizable features to streamline backend development workflows.
InfoSpider is an open‑source Python‑based web‑scraping toolbox that securely aggregates personal data from over 24 sources—including email, e‑commerce, and social platforms—provides a GUI for easy operation, stores results in JSON, and offers basic visual analysis, making personal data integration and insight generation straightforward.
This guide shows how to use Ansible's register feature to capture a task's output, examine the detailed result fields, and reuse the stored data in subsequent tasks, illustrated with a simple whoami example and complete playbook runs.
This article walks you through creating a simple Python lottery draw program, explains how to prepare the names CSV file, shows the GUI logic, provides key code snippets for random name generation and interface handling, and demonstrates packaging the script into a standalone executable with PyInstaller.
