Tagged articles

34 articles

Page 1 of 1

Apr 3, 2025 · Backend Development

Implementing a FIFO Export Queue for Large Data Exports in a Spring Backend

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.

ExportQueueconcurrency

0 likes · 10 min read

Implementing a FIFO Export Queue for Large Data Exports in a Spring Backend

Java Architect Essentials

Dec 8, 2024 · Backend Development

Universal Java Class to Excel Export Using Reflection and Apache POI

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 POIExportReflection

0 likes · 11 min read

Universal Java Class to Excel Export Using Reflection and Apache POI

Architecture Digest

Sep 29, 2024 · Backend Development

Implementing a Fixed‑Size FIFO Export Queue in a Java Backend with Spring and EasyExcel

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.

BackendExportQueue

0 likes · 12 min read

Implementing a Fixed‑Size FIFO Export Queue in a Java Backend with Spring and EasyExcel

Liangxu Linux

Sep 10, 2024 · Databases

Essential MySQL Scripts for Export, Import, and Database Management

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.

DDLExportImport

0 likes · 10 min read

Essential MySQL Scripts for Export, Import, and Database Management

Architect's Tech Stack

Jun 24, 2024 · Backend Development

Implementing a FIFO Export Queue for Large‑Scale Data Export in Java

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.

ExportQueueeasyexcel

0 likes · 11 min read

Implementing a FIFO Export Queue for Large‑Scale Data Export in Java

Java Architect Essentials

Mar 11, 2024 · Backend Development

Designing a Bounded FIFO Export Queue for Large MySQL Data Exports in Java Spring

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.

ExportQueueconcurrency

0 likes · 11 min read

Designing a Bounded FIFO Export Queue for Large MySQL Data Exports in Java Spring

Open Source Tech Hub

Nov 10, 2023 · Backend Development

Master Excel Import/Export in Webman with PhpSpreadsheet

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

Master Excel Import/Export in Webman with PhpSpreadsheet

Rare Earth Juejin Tech Community

Oct 22, 2023 · Frontend Development

Front‑End API Management Strategies Using Mapping Tables and Export Patterns

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

Front‑End API Management Strategies Using Mapping Tables and Export Patterns

Aikesheng Open Source Community

Oct 12, 2023 · Databases

How to Import Large Volumes of Data into MySQL: Tools, Commands, and Performance Tips

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.

ExportMySQL ShellSELECT OUTFILE

0 likes · 16 min read

How to Import Large Volumes of Data into MySQL: Tools, Commands, and Performance Tips

Java High-Performance Architecture

Jun 4, 2023 · Backend Development

How to Build a Powerful Annotation‑Driven Excel Export Tool in Java

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.

ExcelExportPOI

0 likes · 34 min read

How to Build a Powerful Annotation‑Driven Excel Export Tool in Java

Laravel Tech Community

Apr 27, 2023 · Backend Development

Easy Excel: A PHP Library for Efficient Low‑Memory Excel Read/Write

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

Easy Excel: A PHP Library for Efficient Low‑Memory Excel Read/Write

Bilibili Tech

Aug 30, 2022 · Game Development

Unlocking Unity Avatar Creation with Bilibili’s Open‑Source BVA Format

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

Python Programming Learning Circle

Jun 22, 2022 · Backend Development

alanpoi: A Java Library for Efficient Excel Import and Export

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.

BackendExportImport

0 likes · 6 min read

alanpoi: A Java Library for Efficient Excel Import and Export

Programmer DD

Nov 22, 2021 · Backend Development

Master EasyExcel: Fast, Low‑Memory Excel Import/Export in Java

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.

ExcelExportImport

0 likes · 7 min read

Master EasyExcel: Fast, Low‑Memory Excel Import/Export in Java

Open Source Linux

Oct 13, 2021 · Fundamentals

Mastering the export Command: How to View and Set Environment Variables in Linux

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.

Environment VariablesExportLinux

0 likes · 3 min read

Mastering the export Command: How to View and Set Environment Variables in Linux

ZhiKe AI

Oct 11, 2021 · Cloud Native

How to Import and Export Docker Images for Migration

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.

CLIContainerDocker

0 likes · 5 min read

How to Import and Export Docker Images for Migration

Liangxu Linux

Aug 17, 2021 · Databases

Master DataGrip: Essential Tips and Tricks for Efficient Database Management

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.

DataGripDatabase clientExport

0 likes · 12 min read

Master DataGrip: Essential Tips and Tricks for Efficient Database Management

Laravel Tech Community

Jul 29, 2021 · Databases

Common MySQL Commands and Operations Guide

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

Common MySQL Commands and Operations Guide

Node Underground

Jul 13, 2021 · Backend Development

Why Do export and import Behave Differently in Node.js ESM?

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.

ESMExportImport

0 likes · 7 min read

Why Do export and import Behave Differently in Node.js ESM?

Open Source Linux

Jan 22, 2021 · Fundamentals

Mastering the Linux export Command: A Beginner’s Guide to Environment Variables

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.

BashEnvironment VariablesExport

0 likes · 5 min read

Mastering the Linux export Command: A Beginner’s Guide to Environment Variables

Liangxu Linux

Jan 20, 2021 · Fundamentals

Master the Linux export Command: Beginner’s Guide to Environment Variables

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.

Environment VariablesExportLinux

0 likes · 6 min read

Master the Linux export Command: Beginner’s Guide to Environment Variables

Laravel Tech Community

Jan 4, 2021 · Backend Development

Laravel Excel Export with Merged Cells and Custom Column Formatting

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.

ExcelExportPHP

0 likes · 3 min read

Laravel Excel Export with Merged Cells and Custom Column Formatting

Big Data Technology & Architecture

Dec 7, 2020 · Databases

MySQL Billion‑Row Data Migration: Export, Import, and Performance Optimization

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.

Data MigrationExportImport

0 likes · 9 min read

Laravel Tech Community

Sep 29, 2020 · Databases

Comprehensive MySQL Database Operations: Export, Import, DDL, DML, and User Management

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

Comprehensive MySQL Database Operations: Export, Import, DDL, DML, and User Management

The Dominant Programmer

Aug 31, 2020 · Backend Development

Implement Excel Import/Export in RuoYi’s Front‑Back‑End Separation Using ElementUI and SpringBoot

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

Implement Excel Import/Export in RuoYi’s Front‑Back‑End Separation Using ElementUI and SpringBoot

dbaplus Community

Jul 23, 2020 · Databases

How to Export a 2TB Oracle LOB Table Using Rowid Partitioning

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 PumpExportLOB

0 likes · 8 min read

How to Export a 2TB Oracle LOB Table Using Rowid Partitioning

Programmer DD

Nov 21, 2019 · Backend Development

Mastering High‑Performance Excel Export in Java: A Complete Guide

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.

ExcelExportPOI

0 likes · 17 min read

Mastering High‑Performance Excel Export in Java: A Complete Guide

DevOps

Jun 13, 2019 · Operations

How to Import and Export Test Cases in TFS

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.

DevOpsExportImport

0 likes · 3 min read

How to Import and Export Test Cases in TFS

Architecture Talk

Sep 24, 2018 · Backend Development

How to Stop PHPExcel Exports from Timing Out or Exhausting Memory

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 QueueBackendExport

0 likes · 7 min read

How to Stop PHPExcel Exports from Timing Out or Exhausting Memory

ITPUB

Jul 25, 2017 · Operations

How to Accurately Plan Data Center Power with Dell’s Enterprise Infrastructure Planning Tool

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

How to Accurately Plan Data Center Power with Dell’s Enterprise Infrastructure Planning Tool

JD Retail Technology

May 16, 2017 · Big Data

2017 Belt and Road Cross‑Border E‑Commerce Consumption Trend Report

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 RoadChinaExport

0 likes · 9 min read

2017 Belt and Road Cross‑Border E‑Commerce Consumption Trend Report

Tencent IMWeb Frontend Team

May 9, 2017 · Frontend Development

Require vs Import: Mastering ES6 Modules and CommonJS in JavaScript

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.

CommonJSExportImport

0 likes · 10 min read

Require vs Import: Mastering ES6 Modules and CommonJS in JavaScript

ITPUB

Oct 5, 2016 · Databases

How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools

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.

BackupExportImport

0 likes · 5 min read

How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools

ITPUB

Apr 18, 2016 · Databases

Boost Oracle Data Pump Export/Import Speed: Key Parameters and Settings

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

Boost Oracle Data Pump Export/Import Speed: Key Parameters and Settings