This article explains how to automate the replacement of Excel row data into Word templates using Python, offering two approaches—one with python-docx and win32com for .doc conversion, and another leveraging zipfile to edit the underlying XML—complete with code examples and troubleshooting tips.
This article explains how to use mysqldump for various MySQL backup scenarios, provides command‑line examples for full, structure‑only, and selective backups, shows how to restore dumps, and demonstrates a Bash script combined with crontab to automate daily backups with retention management.
This guide explains how to set up a GitHub Actions workflow that automatically fetches the latest blog posts via RSS and updates the special README.md of a same‑named GitHub profile repository, using scheduled runs and repository_dispatch events triggered by a curl command.
This article reviews the 13‑year evolution of Ant Group's registration center, analyzes the scaling and reliability challenges of multi‑cluster service discovery, and explains how the SOFARegistry 6.0 redesign—featuring meta‑driven consistency, slot‑based sharding, application‑level discovery, chaos testing, and automated operations—addresses those challenges while preparing the project for open‑source community growth.
This guide walks you through creating a Node.js tool that automatically generates chat screenshots with customizable themes, avatars, and text, complete with code snippets, size calculations, drawing functions, and integration into workflow tools like Alfred and macOS Shortcuts for instant clipboard copying.
This article demonstrates how to use Python's Selenium WebDriver to log into Alibaba International, scrape company contact information across multiple pages, save the data to CSV, download product images, and embed them into an Excel file, providing a complete automation workflow.
This guide demonstrates how to use Python on macOS to scrape love quotes, store them, and automatically launch QQ to send a random quote each day, including code snippets and steps to set up an Automator app for startup execution.
The article outlines the background, mission, technical choices, and comprehensive features of the Tianyan Quality Platform—an internal testing solution built with Vue and Spring Boot that streamlines API automation, environment management, and DevOps integration across multiple business lines.
The article outlines twenty‑four essential capabilities—including version control, automated deployment, continuous integration, trunk‑based development, test automation, lean management, and cultural practices—that together drive high‑performance software delivery and organizational effectiveness.
Qunar’s DBA team overhauled their MySQL monitoring and alert system—originally built on Nagios and NRPE—by integrating a Kafka‑based pipeline, a custom alarm service, and MySQL‑stored alert templates, achieving flexible thresholds, granular silencing, high‑availability processing, and early‑stage intelligent management of alerts, slow queries, and disk space.
This tutorial walks through creating a Windows‑10 Python script that captures the 4399 mini‑game “Pet Link‑Match Classic 2”, identifies icons via image processing, builds a matrix, finds connectable pairs with a path‑finding algorithm, and simulates mouse clicks to automatically clear the board.
This tutorial shows how to use Python's pyautogui and APScheduler libraries to automatically open WeChat, locate the chat window, type a message, and send it precisely at midnight, providing a practical example of desktop automation and scheduled tasks.
This tutorial demonstrates how to analyze an e‑commerce search page, use Selenium to automate browsing, extract product details across multiple pages, and store the collected data into a MySQL database, providing complete Python code and step‑by‑step explanations.
This article walks you through six Python methods—including two newly added approaches—to automatically combine all sheets from every Excel file in nested folders, saving hours of manual copy‑paste and reducing errors for data‑processing tasks.
This document outlines a comprehensive software testing plan covering project overview, test preparation, detailed strategies for unit, interface, functional, UI, UAT, and performance testing, along with scheduling, common standards, and checklist guidelines to ensure quality and risk mitigation.
This article explains how to use Python's pandas, os, and glob libraries to automatically locate, read, and concatenate all sheets from multiple Excel workbooks across nested folders, offering four concise code solutions, visual results, and practical tips for reliable batch merging.
This guide explains why and how to change HTTP request headers during Selenium WebDriver automation, covering three practical approaches—using REST‑Assured, employing a BrowserMob proxy, and configuring a Firefox extension—complete with code examples and step‑by‑step instructions.
This guide explains Jira's planning and tracking features, provides step‑by‑step instructions for installing the Data Center version, details initial configuration, demonstrates project and module creation, and shows how to integrate Jira with Jenkins and GitLab for automated CI/CD workflows.
This article examines Baidu's Tekes platform—its evolution from automated component publishing to a full‑stack mobile DevOps service—detailing its architecture, workflow engine, event‑driven pipeline, and how it boosts development efficiency across hundreds of repositories and product lines.
This article explains how the Apollo testing framework was redesigned to enable scenario‑based API testing, reduce case creation and maintenance costs, improve quality checks, and support advanced features like traffic replay, ultimately enhancing automation efficiency for large‑scale business services.
This tutorial explains how to create a Python Selenium script that automatically opens Taobao, logs in via QR code, navigates to the shopping cart, waits for a preset flash‑sale time, selects all items, and completes the checkout process.
The article explains test orchestration as a coordinated, automated testing workflow that enhances software quality and delivery speed by eliminating manual errors, integrating with CI/CD pipelines, and leveraging tools such as Ansible, Jenkins, and Kubernetes to streamline testing processes across DevOps environments.
The article describes an intelligent grading and risk‑assessment framework for commercial platforms that unifies process control, feature mining, data collection, storage, strategy management, and annotation, enabling automated testing conversion with 94% accuracy, 90% recall, 8% conversion uplift, and surfacing dozens of bugs while supporting scalable, configurable deployment.
This article explains how to use the mysqldump command to back up MySQL databases, provides various command examples for full or partial backups, demonstrates a Bash script for automated daily backups with log management, and shows how to schedule these tasks using crontab.
This article presents a detailed case study of the "Hummingbird" DevOps platform built by Zhongtai Securities' R&D team, describing its background, architecture, CI/CD pipeline, integration with tools like JIRA, container management, automated testing, monitoring, and the measurable efficiency gains achieved across development, testing, and production.
This article introduces the role of shell scripts in automating system operations, presents a free 70‑page practical handbook covering fundamentals to advanced topics, and offers 100 ready‑to‑run script examples ranging from basic hello‑world to complex monitoring and deployment tasks, helping readers quickly boost their scripting skills.
An AI‑driven image‑recognition system using TensorFlow Lite cameras on checkout scales replaces barcode PLU lookup with hierarchical product categories, caches offline selections for incremental model updates, and delivers instant, offline‑capable identification, dramatically speeding fresh produce checkout, cutting labor costs, and offering a reusable framework for other retail sectors.
This article describes Alipay’s client‑side high‑availability strategy that combines offline risk mining, function‑interface “minesweeping”, RPC/config/jsapi checks, and automated fuzz testing on Android and iOS to detect and eliminate crash‑inducing bugs before release.
This tutorial walks Java developers through the fundamentals of Linux shell scripting, covering how to create and run scripts, check and set the default shell, manage permissions, define and manipulate variables, and implement flow‑control constructs such as if/else, case, for, and while loops with practical code examples.
This guide walks you through using Postman to automate API testing, covering result validation, batch execution, variable handling, environment management, and dependency resolution with practical JavaScript snippets and step‑by‑step instructions.
This article outlines the essential categories of DevOps tools—from planning and issue tracking to source control, build, test, CI/CD, configuration management, cloud platforms, container orchestration, monitoring, communication, and knowledge sharing—explaining why each is vital and listing popular examples for teams seeking efficient delivery pipelines.
Learn how to transform Postman's often‑overlooked features into a powerful automated API testing workflow, covering result validation, batch collections, data‑driven testing, scheduled monitors, variable handling, request dependencies, and custom scripting to boost efficiency and reliability for developers.
This tutorial shows how to use Python's Pillow library to automatically split any image into nine equal tiles with a concise script, explaining the calculations, code structure, and resulting output files, making image tiling easy for developers.
The article examines how AI-driven tools are reshaping DevOps practices, introducing concepts like AIOps and NoOps, evaluating their impact on development speed, quality, and the evolving role of engineers, and ultimately questioning whether AI will replace traditional DevOps personnel.
This article explains how to use Python and the openpyxl library to automatically locate rows where column A equals 10 (representing 10 am) across multiple Excel files, presents two practical solutions, and provides complete code snippets and screenshots for easy implementation.
This guide explains what ZZNohost is, why it is used, and provides step‑by‑step instructions—including account setup, environment creation, whistle configuration, mobile proxy capture, UI automation integration with code examples, and platform‑level usage in Jarvis and WatchDog—to streamline multi‑environment testing and debugging.
Gartner’s 2022 strategic technology trends highlight the rise of generative AI, data fabric, distributed enterprises, cloud‑native platforms, autonomic systems, decision intelligence, composable applications, hyperautomation, privacy‑enhancing computation, cybersecurity mesh, AI engineering and total experience as key drivers for growth and resilience in modern enterprises.
This article shares a real-world low-code implementation story, analyzes where low-code excels and fails, and offers five practical strategies for technical leaders to navigate efficiency gains, workforce impacts, and future-proof their development teams.
The article explains the critical differences between traditional test automation and continuous testing, detailing how continuous testing, integration, delivery, and deployment enhance software quality, speed, and team efficiency within a DevOps environment.
Gartner's 2022 report outlines twelve strategic technology trends—ranging from generative AI and data fabric to cloud‑native platforms, autonomous systems, decision intelligence, composable applications, hyper‑automation, privacy‑enhancing computation, cybersecurity mesh, AI engineering, and total experience—highlighting how data and intelligence will drive enterprise transformation over the next decade.
This article details Dada's journey from identifying costly business‑configuration pain points to designing and deploying an automated configuration center that isolates business settings, improves system stability, enhances robustness, accelerates development, secures data, and delivers measurable performance gains.
This article introduces a cloud‑based mobile testing platform, detailing its architecture, implementation with Spring Boot and Appium, and real‑world applications in compliance verification and online inspection, highlighting how AI integration and automated workflows dramatically improve testing efficiency and product quality.
This article outlines a comprehensive approach to handling call‑center incidents, covering common troubleshooting steps, proactive monitoring enhancements, well‑structured emergency plans, and intelligent event‑driven automation to reduce downtime and improve operational efficiency.
This guide presents twenty practical Linux command‑line shortcuts—including tab completion, directory navigation, command chaining, history search, log monitoring, and alias usage—that help both beginners and seasoned users work faster, avoid common pitfalls, and boost overall terminal efficiency.
This guide walks through Postman's advanced features—including response assertions, sandbox scripting, UI testing, request methods, cookie handling, authentication, collection organization, variable management, command‑line execution with Newman, and exporting test scripts to Python and Java for data‑driven API testing—providing step‑by‑step examples and screenshots.
This article explains how to import Swagger API documentation into a testing platform database, perform version control and diff using zjsonpatch, and seamlessly connect the documented APIs with automated test cases to improve efficiency for front‑end, back‑end, and QA teams.
The article summarizes major insights from three recent DevOps studies—Puppet's 2021 State of DevOps, the DevOps Institute's 2020 Upskilling Report, and Google DORA's 2021 Report—highlighting the roles of automation, cloud adoption, culture, documentation quality, and performance metrics in successful DevOps transformations.
This article examines the challenges faced by documentation engineers, proposes a documentation‑centric workflow, outlines key elements such as edit‑publish separation, automation, formalization, open collaboration, and versioning, and suggests metrics and practices to measure and improve the overall developer experience.
The initiative introduces fault‑drill and chaos‑engineering practices—defining steady‑state metrics, injecting real‑world failures in controlled experiments, automating continuous production tests, and limiting blast radius—to detect weaknesses early, accelerate fault location and recovery, boost emergency response metrics, and foster a resilient engineering culture.
The article explains why cross‑browser testing is essential for modern web applications, outlines the major challenges such as automation complexity, infrastructure maintenance, and browser version proliferation, and proposes practical solutions including tool selection, cloud‑based platforms, and prioritized testing strategies.
This guide walks you through using mysqldump to back up MySQL databases, restoring backups, and creating a Bash script with crontab to automate daily backups while retaining only the most recent 31 days of dump files.
This article presents a curated set of 140 software testing interview questions covering topics such as API testing, automation frameworks, performance testing, CI/CD, database operations, Selenium, mobile testing, and related concepts, offering valuable preparation material for candidates.
This article explains the various stages of a CI/CD pipeline, detailing the roles, processes, and tools involved in continuous integration, testing, building, deployment, and monitoring, and highlights why such pipelines are essential for fast, scalable software delivery in modern organizations.
This article explains how the GoGoCode AST‑based tool can automatically transform large Vue2 codebases to Vue3 by applying a set of around thirty migration rules, covering async components, custom directives, router and Vuex changes, and provides installation, usage examples, and a comprehensive rule table.
This guide explains how kubectl interacts with the Kubernetes API, walks through command‑completion setup, custom column output, multi‑cluster and namespace switching, and shows how to extend kubectl with plugins such as kubectx, krew, and custom scripts, boosting productivity for cloud‑native workflows.
The article explains the problems of manual cloud resource provisioning, introduces Terraform's Infrastructure as Code approach, describes a company-specific workflow using a front‑end request portal, GitOps, and Mobius automation, and outlines how to import existing resources and perform bulk exports with Terraformer.
This article examines the challenges of exploding microservice counts, rising infrastructure costs, and complex topologies, and details a cloud‑native, service‑decoupled DevOps infrastructure that uses standardization, declarative provisioning, intelligent automation, contract and diff testing, and a unified release engine to dramatically improve delivery efficiency and reliability.
This guide explains how to set up ADB on a Windows PC, connect an Android device, capture screenshots, and run a Python script that detects the game pieces and board in WeChat's Jump mini‑program to automatically perform jumps based on calculated distances.
This guide explains how to create a custom DingTalk robot using Python 3.7, covering webhook configuration, security signing, step‑by‑step setup in the PC client, and a complete code example for sending text messages.
The article shares a tester’s two‑year growth experience, illustrating how testing focus shifts from basic functional checks to comprehensive test plans that combine interface, data‑construction, mock, and debugging techniques for various backend, frontend, and full‑stack scenarios.
The article describes how a to‑B SaaS platform tackled exploding microservice counts, soaring infrastructure costs, complex topologies and high‑frequency releases by standardizing, declaratively provisioning, and intelligently automating cloud‑native DevOps services, resulting in dramatically improved delivery efficiency and reliability.
This article explains how automation drives DevOps practices by improving speed, consistency, and reliability across the software lifecycle, discusses tools and challenges, and outlines future trends for integrating automated testing and infrastructure-as-code in modern development operations.
The Creation Quality Platform (CQ) automates large‑scale detection of templates, mini‑programs, and special‑effect resources across ByteDance apps, combining automated pipelines, algorithmic classification, CV/NLP checks, and prioritized task routing to boost efficiency, accuracy, and creator experience while reducing manual effort.
JApiDocs is a zero‑annotation, out‑of‑the‑box tool that parses SpringBoot controller code and JavaDoc comments to automatically generate HTML API documentation, offering quick setup, client model export, and various features that simplify backend documentation workflows.
This article guides you through creating a Python script that fetches real‑time stock quotes, evaluates price changes, and automatically sends email notifications, while covering required libraries, scheduling, packaging as an executable, and future enhancements for quantitative trading.
This tutorial shows how to install the filestools library, use its curl2py command to convert cURL requests into ready‑to‑run Python code, and demonstrates the process with a real‑world example, saving time and avoiding manual copying of headers and parameters.
This guide explains how to use standard Linux utilities and a custom Bash script to view, modify, save, and restore file timestamps, enabling attackers or administrators to conceal or recover evidence of file changes on a server.
This article reveals powerful yet often overlooked Postman features—including environment variables, global and collection scopes, pre‑request scripts, test scripts, and token automation—demonstrating how to streamline API debugging across multiple environments, automate authentication, and manage variable lifecycles for more efficient development workflows.
This article examines the quality challenges of Alibaba's DEF frontend code review system, identifies issues such as short review times, low comment rates, and oversized changes, and proposes practical solutions including staged reviews, better notifications, comment defect tagging, reviewer recommendation, and static analysis integration.
The article explains how external results, cost‑only measurement before user adoption, and four principles—Build Quality In, Eliminate Waiting, Eliminate Trivial Work, and Monitor Everything—combine to speed up the verification loop and enable rapid, high‑quality software delivery.
This article explains how AI‑powered generative design transforms traditional design workflows by automating complex creations, enabling rapid iteration, highlighting both its efficiency gains and the paradox of too many choices, and showcases accessible online tools and striking artistic examples.
This guide explains how to set up IntelliJ IDEA templates to automatically generate class and method Javadoc comments, including adding author and date placeholders, creating live templates for @param and @return annotations, and customizing variable expressions with Groovy scripts.
This article describes a complete workflow for iOS UI development that centralizes color definitions in a JSON palette, synchronizes them via a CocoaPods post‑integrate hook, and automatically generates Objective‑C/Swift color constants and Xcode code snippets using Ruby and ERB templates, dramatically improving efficiency and reducing manual errors.
Learn how to replace manual rc.local startup scripts with elegant solutions using Crontab's @reboot feature and Systemd services, including step‑by‑step commands and advanced scheduling tricks for reliable automatic execution after a reboot.
This tutorial explains how to use Jenkins to integrate command‑line tools and webhooks for automating GitLab branch creation, covering API discovery, Postman testing, pipeline scripting, credential handling, shared library implementation, and final system configuration.
The automatic front‑end disaster‑recovery solution packages an npm tool and visual backend that generates on‑demand API fallback data, uses a whitelist and static parameters to target backups, syncs results to developers, and after deployment raised coverage from ~30% to ~70%, automating 80% of backups.
This tutorial explains how to build a Python alarm clock that plays a sound, uses text‑to‑speech for voice alerts, and optionally sends an email via QQ SMTP when the alarm triggers, providing full source code and step‑by‑step instructions.
The Blue Whale Job Platform (bk-job) by Tencent offers a comprehensive, front‑end/back‑end separated solution for script execution, file distribution, task scheduling, and workflow orchestration, providing secure command detection, versioned scripts, and extensible file source management to streamline enterprise operations.
This guide explains how to configure GitHub Actions to automatically synchronize GitHub repositories with Gitee, covering the basics of GitHub Actions, synchronization methods, action selection or creation, required preparation steps, workflow syntax, and practical code examples.
Facebook detailed its multi‑year journey from MySQL 5.6 to 8.0, explaining why it stayed on 5.6 for MyRocks development, the massive patch‑porting effort, replica‑set migration steps, adoption of row‑based replication, extensive automation testing, and the performance and compatibility issues uncovered along the way.
The 2021 State of Data Science report shows how COVID‑19 has impacted investment, highlights Python's dominance, examines automation's growing role, and reveals corporate attitudes toward open‑source contributions, offering data‑driven insights for professionals and educators alike.
This guide explains Selenium 4's deprecation of DesiredCapabilities, shows how to use Options for Chrome, Firefox, IE and Safari, demonstrates the updated Actions API for clicks, double‑clicks, right‑clicks and drag‑and‑drop, and details the FluentWait syntax changes with code examples.
This article outlines the five core competencies—automation, communication and collaboration, cloud computing, security, and operational support—that aspiring DevOps engineers need to master in order to deliver software quickly, reliably, and securely in today’s competitive market.
This guide shows three reliable ways to run custom scripts automatically after a Linux machine boots—by editing /etc/rc.local, using a crontab @reboot entry, or creating a dedicated systemd service—along with example commands and advanced timing options.
This article introduces a practical three‑question thinking framework and five guiding principles that help developers and product teams clarify goals, assess current status, and design effective implementation paths, ultimately improving productivity and reducing wasted effort.
This tutorial walks through setting up a Python environment, installing libraries, creating and editing Word documents with python-docx, converting files and generating PDFs using win32com, extracting Excel data with xlrd, visualizing scores with matplotlib, and automating batch document generation with docx-mailmerge.
The article explains why test suites in enterprise DevOps must run quickly—ideally within five to fifteen minutes—to keep developers productive, and outlines common causes of slow tests such as unnecessary sleep statements, poor test data handling, and lack of event‑driven design, recommending refactoring and optimization.
This article provides a comprehensive Python tutorial covering how to send GET and POST requests, handle HTTPS verification, perform file uploads and downloads, set request timeouts, use basic and token authentication, manage sessions, generate signatures, and organize a test automation framework with configuration, common utilities, test data, test cases, reporting, and execution scripts.
A global cybersecurity firm replaced its fragmented cron‑based build, test, and deployment processes with an automated Jenkins CI/CD pipeline, integrating GitLab, Docker, and monitoring tools to achieve continuous delivery, visibility, and faster, reliable releases across multiple projects.
This guide shows how to use a Windows batch file together with MySQL's mysqldump tool to create scheduled backups of one or multiple databases, including command options, full‑path execution, loop timing, and a ping‑based pause to avoid interference.
This article examines how a securities firm leveraged a low‑code development platform to build a visual operations‑on‑duty management system, detailing the background, requirements, implementation, benefits, deployment challenges, and future plans for an integrated operations development platform.
Learn how to manually create an iOS component library using CocoaPods, automate the process with the pod lib create scaffold, customize private templates, and develop a CocoaPods plugin to streamline library generation, complete with code examples and project structure details.
This article details the evolution of JD's Family Account frontend project, covering multi‑platform technical selection, React Native‑based architecture, three‑level component reuse, automation scripts for Redux, interface fault‑tolerance mechanisms, and future plans for broader data services and SDK support.
This article provides a step‑by‑step tutorial on building a DevOps pipeline that integrates Docker, Jenkins, GitLab, Maven, and SpringBoot, covering environment setup on CentOS, Maven pom configuration, Dockerfile creation, shell scripting for image building, multi‑machine deployment, and practical Jenkins job configuration.
Ansible, a rapidly rising open‑source automation platform, lets operations engineers streamline workflows, boost efficiency, and cut human error by offering thousands of built‑in modules and a simple, agent‑less interface that’s easy for beginners yet powerful enough for complex tasks.
This article outlines practical shell‑script guidelines for automating system and application operations, covering script header conventions, formatting, error handling, safe use of commands, variable handling, file packaging, pipeline restrictions, concurrency locks, logging, and risk‑mitigation strategies to make automation both efficient and secure.
Learn how to automate a web-based Sudoku game using Python's Selenium for data extraction, implement an efficient backtracking and bitwise algorithm to solve the puzzle, and programmatically fill the solution back into the browser, achieving performance improvements from 17 seconds to just over 3 seconds.
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.
