Tagged articles
Export
35 articles · Page 1 of 1
The article explains why concurrent Excel exports can overload a Java backend, describes a FIFO queue with a fixed capacity to serialize export tasks, shows the full implementation with Spring, EasyExcel and synchronized wait/notify, and discusses test results and remaining limitations.
BackendConcurrencyEasyExcel
0 likes · 12 min read

The article describes a backend solution that uses a fixed‑size FIFO queue to throttle concurrent MySQL export operations, provides Java implementations of the ExportQueue, an abstract EasyExcel‑based exporter, a concrete ExportImpl service, and a test controller, and discusses remaining challenges and alternative approaches.
ConcurrencyEasyExcelExport
0 likes · 10 min read

This article demonstrates how to create a generic utility that, through Java reflection and Apache POI, can export any list of objects—regardless of their class—into a CSV/Excel file, with optional custom column names via annotations.
Apache POIExportJava
0 likes · 11 min read

This article explains how to design and implement a fixed-size FIFO export queue in a Java backend using Spring components and EasyExcel, covering business requirements, class definitions, code examples, testing results, and considerations for further enhancements such as Redis queues and high‑concurrency scenarios.
BackendEasyExcelExport
0 likes · 12 min read

This guide provides a comprehensive collection of MySQL command‑line scripts covering database and table export/import, creation, deletion, schema inspection, data manipulation, user privilege management, and common DDL operations, all with practical examples.
DDLData ManipulationExport
0 likes · 10 min read

This article explains how to design and implement a fixed-size FIFO export queue in Java to manage large‑scale MySQL data exports, detailing the ExportQueue class, abstract export logic with EasyExcel, a concrete ExportImpl service, and a test controller, while discussing performance considerations and future enhancements.
EasyExcelExportJava
0 likes · 11 min read

To prevent performance degradation during large MySQL data exports, this article presents a Java Spring implementation of a bounded FIFO export queue, detailing the ExportQueue class, abstract export handling with EasyExcel, concrete service and controller code, and test results demonstrating queue limits and concurrency considerations.
ConcurrencyEasyExcelExport
0 likes · 11 min read

This guide shows how to integrate PhpSpreadsheet into a Webman PHP project, covering Composer installation, detailed code for safely importing Excel files with validation and data extraction, and generating Excel exports with styled headers, custom column widths, and base64‑encoded file delivery.
ComposerExcelExport
0 likes · 7 min read

The article presents a front‑end API management approach that organizes CRUD functions into unified export statements, object‑oriented modules, and a central mapping table, demonstrating how these patterns improve code readability, maintainability, and development efficiency for large backend‑driven projects.
APIExportMapping
0 likes · 11 min read

This article compares various MySQL data import/export methods—including mysqldump, mydumper, SELECT OUTFILE, and MySQL Shell utilities—explaining their commands, configuration options, performance results, and best‑practice recommendations based on testing with a 10‑million‑row table.
ExportMyDumperMySQL
0 likes · 16 min read

This guide walks you through creating a full‑featured Java Excel export utility using custom annotations, POI, reflection, and grouping, covering sheet configuration, titles, headers, styles, fonts, dynamic titles, column auto‑sizing, and performance considerations with complete code examples.
ExcelExportJava
0 likes · 34 min read

Easy Excel is a PHP library built on openspout that enables fast, low‑memory reading and writing of xlsx, csv, and ods files, providing installation steps, environment requirements, and code examples for exporting, importing, and handling Excel data in backend applications.
BackendExcelExport
0 likes · 4 min read

This article introduces Bilibili’s self‑developed BVA avatar file format, compares it with VRM, details its features such as unified model specifications, advanced material support, dynamic bone physics, and provides step‑by‑step Unity integration, export procedures for avatars, scenes, and runtime loading, along with sample code and resources.
3D modelingBVAExport
0 likes · 12 min read

The article introduces alanpoi, a Java library that streamlines Excel import and export with millisecond‑level parsing, multi‑sheet support, error feedback, and extensible consumption interfaces, providing configuration, inheritance, and invocation examples along with annotation‑driven export capabilities.
BackendExportJava
0 likes · 6 min read

This guide explains how to use Alibaba's EasyExcel library for efficient, low‑memory Excel import and export in Java, covering its core features, common annotations, Maven dependencies, listener implementation, and practical code examples for both HTTP‑based and local file operations.
EasyExcelExcelExport
0 likes · 7 min read

This guide explains the Linux export command, detailing its purpose for converting shell variables and functions into environment variables, the syntax, available options such as -f, -n, -p, and provides practical examples for listing, setting, and removing environment variables.
ExportLinuxcommand-line
0 likes · 3 min read

This guide explains how to migrate Docker images by using the docker load/save commands for image‑level import/export and the docker import/export commands for container‑level import/export, detailing each command's options and providing concrete examples.
DockerExportImage
0 likes · 5 min read

This guide walks you through installing DataGrip, configuring connections and drivers, using its powerful SQL editor, navigating objects, exporting and importing data, and leveraging advanced shortcuts and features to streamline database development and management.
DataGripExportIDE
0 likes · 12 min read

This article provides a comprehensive collection of MySQL command-line instructions for exporting databases or tables, importing data, managing databases and tables, performing DDL and DML operations, handling field types, and configuring user privileges, all illustrated with practical code examples.
DDLDMLDatabase Commands
0 likes · 10 min read

This article explores how various export syntaxes in ES modules affect the binding behavior of imported values in Node.js, demonstrating differences between named exports, default exports, destructuring, and circular dependencies with clear code examples.
ESMExportNode.js
0 likes · 7 min read

This guide explains how the Linux export command works, shows how to list, set, and export variables and functions, and demonstrates configuring persistent environment settings for Bash users.
Exportbashenvironment variables
0 likes · 5 min read

This article explains how to use the Linux export command to set and view environment variables, demonstrates common options such as listing all exports, exporting specific variables, exporting functions, and shows how to persist settings in shell configuration files, providing practical examples for beginners.
ExportLinuxenvironment variables
0 likes · 6 min read

This article demonstrates how to create a Laravel export class using Maatwebsite\Excel that supports merging cells, custom column formatting, and handling large numeric values, providing a complete PHP implementation with constructor, collection, event registration, and column format methods for generating Excel files.
ExcelExportFormatting
0 likes · 3 min read

This article documents a step‑by‑step MySQL data migration case involving 140 million rows, covering export via SELECT INTO OUTFILE, import with LOAD DATA INFILE, and a series of performance tweaks such as index removal, session variable tuning, engine selection, and monitoring to achieve sub‑10‑minute load times.
ExportMySQLdata migration
0 likes · 9 min read

This guide provides step‑by‑step instructions for exporting entire MySQL databases or individual tables, importing data, performing common DDL and DML operations such as creating, altering, renaming, and dropping databases and tables, managing fields, and configuring user permissions, all illustrated with concrete command‑line examples.
DDLDMLExport
0 likes · 9 min read

This guide walks through adding an Excel import dialog with ElementUI, configuring upload handling, token authentication, progress and success callbacks, and a SpringBoot POI‑based import endpoint, then shows how to create an export button that uses RuoYi’s ExcelUtil and annotation‑driven export logic.
ElementUIExcelExport
0 likes · 12 min read

This article details a real‑world migration from Oracle 11g on IBM AIX to Oracle 19c, focusing on exporting a 2 TB LOB‑heavy table by adjusting undo retention, then using ROWID‑based modulo queries with Data Pump to achieve balanced, error‑free parallel exports.
Data PumpDatabase MigrationExport
0 likes · 8 min read

This article explains how to build a reusable Java utility for exporting massive Excel reports, covering customizable headers, field formatting, multithreaded data retrieval, asynchronous processing, and provides full source code with detailed analysis and usage instructions.
ExcelExportJava
0 likes · 17 min read


DevOpsJun 13, 2019 · Operations
This guide explains how to use the TFS Test Plan Management tool to import and export test cases, detailing step‑by‑step procedures, example screenshots, default file locations, and answers to common questions for testers seeking to manage their test case data efficiently.
DevOpsExportTFS
0 likes · 3 min read

This article explains why PHPExcel data exports often hit timeout or memory limits, analyzes the underlying causes, and provides practical solutions such as cell caching, memory‑efficient coding, and asynchronous queue processing to ensure reliable export performance.
Async QueueBackendCaching
0 likes · 7 min read


ITPUBJul 25, 2017 · Operations
This guide explains why precise power usage assessment is crucial for data‑center safety and efficiency, introduces Dell’s free online Enterprise Infrastructure Planning Tool, provides the web and download links, and walks through step‑by‑step configuration of voltage, devices, PSU selection, summary view, and exporting results to PDF or Excel.
ConfigurationDellEIPT
0 likes · 6 min read

JD Data Research Institute’s 2017 Belt and Road cross‑border e‑commerce consumption trend report shows Chinese products sold in 54 Belt‑and‑Road nations, with mobile phones, computers, electronic accessories and home goods leading exports, while smart devices, automotive parts and health‑beauty items experience the fastest sales growth, alongside notable improvements in import volumes and logistics speed.
Belt and RoadChinaCross-border E-commerce
0 likes · 9 min read

This article compares Node's CommonJS require/module.exports with ES6's import/export syntax, explains their differences, usage patterns, and pitfalls, and offers guidance on when to adopt import over require as JavaScript engines evolve toward full ES6 support.
CommonJSES6Export
0 likes · 10 min read


ITPUBOct 5, 2016 · Databases
This guide walks through exporting Oracle PL/SQL user objects and table data with PL/SQL Developer, then restoring them by dropping the existing user, recreating it with necessary privileges, executing the exported SQL script, and importing table data while handling constraints and triggers.
ExportOraclePL/SQL
0 likes · 5 min read


ITPUBApr 18, 2016 · Databases
This guide details the most effective Oracle Data Pump parameters and related database settings—such as access_method, parallel, network_link, and NLS options—to dramatically improve export and import performance while avoiding common pitfalls.
Data PumpDatabase ParametersExport
0 likes · 12 min read
