BestHub
Sign in
Tagged articles

Data Export

42 articles · Page 1 of 1
Cloud Architecture
Cloud Architecture
Aug 6, 2026 · Big Data

Exporting 10 Billion Elasticsearch Records: From Simple Script to Enterprise Offline Platform

The article analyses why exporting billions of Elasticsearch documents requires a full‑stack platform rather than a one‑off script, detailing the pitfalls of naive pagination, the benefits of PIT + search_after + slicing, and a complete architecture with Kafka, Redis, MySQL, Kubernetes and observability for reliable, scalable offline data export.

Big DataData ExportElasticsearch
0 likes · 40 min read
Exporting 10 Billion Elasticsearch Records: From Simple Script to Enterprise Offline Platform
Top Architect
Top Architect
Jun 9, 2026 · Backend Development

Master SpringBoot Excel Export with EasyExcel: A Complete Guide

This guide walks through integrating EasyExcel with Spring Boot, covering Maven setup, entity definition, utility class creation, basic and advanced export scenarios such as complex headers, cell merging, custom formatting, and large‑scale paging, plus common pitfalls like dependency conflicts and annotation misuse.

Data ExportEasyExcelExcel export
0 likes · 11 min read
Master SpringBoot Excel Export with EasyExcel: A Complete Guide
Ray's Galactic Tech
Ray's Galactic Tech
Jan 22, 2026 · Big Data

Export 1 Billion Elasticsearch Docs in 3 Hours Using PIT + Slice

This guide explains how to reliably export over a billion Elasticsearch documents within a few hours by using Point‑In‑Time (PIT) snapshots combined with parallel Slice processing, covering diagnostics, performance modeling, consistency levels, failure recovery, and resource isolation.

Big DataData ExportElasticsearch
0 likes · 7 min read
Export 1 Billion Elasticsearch Docs in 3 Hours Using PIT + Slice
Architect's Guide
Architect's Guide
Jan 1, 2026 · Backend Development

How to Efficiently Import and Export Millions of Records with POI and EasyExcel

This article explains how to handle massive Excel import/export tasks in Java by comparing POI workbook implementations, selecting the appropriate class based on data size, and using EasyExcel with batch processing, JDBC transactions, and pagination to achieve fast, low‑memory operations for hundreds of millions of rows.

Data ExportEasyExcelPOI
0 likes · 21 min read
How to Efficiently Import and Export Millions of Records with POI and EasyExcel
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 27, 2025 · Information Security

Improving Data Export Workflows and Security: From 1.0 to 2.0 with Classification and Dynamic Approval

This article examines the security challenges of data export work orders in MySQL environments, outlines the shortcomings of the original 1.0 workflow, and presents a comprehensive 2.0 redesign that introduces dynamic approvals, data classification, execution‑plan analysis, and code‑level solutions to mitigate data leakage risks.

Data ExportDatabase SecurityMySQL
0 likes · 15 min read
Improving Data Export Workflows and Security: From 1.0 to 2.0 with Classification and Dynamic Approval
Java Backend Technology
Java Backend Technology
Feb 14, 2025 · Backend Development

Master Efficient Excel Import/Export in Java with EasyExcel and Thread Pools

Learn how to efficiently handle large-scale Excel import and export in Java web applications using EasyExcel, leveraging Java 8 functional programming, reflection, thread pools, and custom ReadListener implementations to minimize memory usage, improve performance, and support flexible data mapping and dynamic schema handling.

Data ExportEasyExcelExcel import
0 likes · 14 min read
Master Efficient Excel Import/Export in Java with EasyExcel and Thread Pools
Test Development Learning Exchange
Test Development Learning Exchange
Dec 18, 2024 · Fundamentals

How to Import and Export Data in Pandas

This guide explains how to use Pandas to import data from various file formats such as CSV, Excel, JSON, SQL, HTML, HDF5, Pickle, TSV, fixed‑width files and the clipboard, and also demonstrates how to export DataFrames to formats like CSV, Excel, JSON, SQL, HTML, HDF5 and Pickle, providing clear code examples for each operation.

Data AnalysisData ExportPython
0 likes · 10 min read
How to Import and Export Data in Pandas
Python Crawling & Data Mining
Python Crawling & Data Mining
Oct 26, 2024 · Databases

Export MongoDB Data to CSV, Excel, JSON and More with mongo2file

This article introduces the mongo2file Python library that converts MongoDB collections into various table formats such as CSV, Excel, JSON, Pickle, Feather, and Parquet, explains its PyArrow dependency, shows installation and usage examples, discusses performance bottlenecks, and provides API reference details.

CSVData ExportExcel
0 likes · 11 min read
Export MongoDB Data to CSV, Excel, JSON and More with mongo2file
Hacker Afternoon Tea
Hacker Afternoon Tea
Aug 10, 2024 · Databases

Exploring ClickHouse’s Multiple Approaches to JSON Processing

This guide outlines ClickHouse’s various techniques for loading, inferring schemas, designing, exporting, and handling different JSON formats—including NDJSON and advanced modeling—while noting the upcoming native JSON type that will replace the deprecated Object Data Type.

ClickHouseData ExportNDJSON
0 likes · 3 min read
Exploring ClickHouse’s Multiple Approaches to JSON Processing
Open Source Tech Hub
Open Source Tech Hub
Aug 7, 2024 · Backend Development

Boost PHP Excel Performance with the High‑Speed xlswriter Extension

The article introduces xlswriter, a high‑performance PHP C extension for reading and writing Excel 2007+ XLSX files across major operating systems, compares it with PHPExcel, presents benchmark results, explains PECL installation, and provides detailed code examples for exporting, importing, and chart generation.

Data ExportExcelPHP
0 likes · 7 min read
Boost PHP Excel Performance with the High‑Speed xlswriter Extension
Java Interview Crash Guide
Java Interview Crash Guide
Aug 10, 2023 · Big Data

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains the differences between POI's HSSFWorkbook, XSSFWorkbook and SXSSFWorkbook, provides guidelines for selecting the right workbook based on data volume and Excel features, and demonstrates batch export and import of hundreds of millions of rows using EasyExcel, JDBC batch inserts, and transaction control to achieve high performance and low memory consumption.

Data ExportEasyExcelPOI
0 likes · 22 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Top Architect
Top Architect
Jan 31, 2023 · Backend Development

Handling Large-Scale Excel Import/Export with POI and EasyExcel in Java

This article explains how to efficiently import and export massive Excel datasets in Java by comparing POI implementations, selecting the appropriate workbook type, and using EasyExcel with batch processing, pagination, and JDBC transactions to achieve high performance for hundreds of thousands to millions of rows.

Data ExportEasyExcelExcel
0 likes · 23 min read
Handling Large-Scale Excel Import/Export with POI and EasyExcel in Java
Open Source Linux
Open Source Linux
Jan 10, 2023 · Databases

Essential MySQL Scripts: Export, Import, and Manage Databases & Tables

This guide compiles a comprehensive set of MySQL command‑line scripts for exporting whole databases, individual tables or schemas, importing data, and performing common database and table operations such as creation, selection, alteration, deletion, granting privileges, and viewing structure, all illustrated with ready‑to‑use code examples.

DDLData ExportDatabase
0 likes · 11 min read
Essential MySQL Scripts: Export, Import, and Manage Databases & Tables
Alibaba Cloud Native
Alibaba Cloud Native
Dec 26, 2022 · Cloud Native

Mastering ZooKeeper Data Import/Export with MSE’s New Feature

This guide explains the underlying snapshot and transaction‑log storage of ZooKeeper, outlines three key scenarios for using MSE’s import‑export feature, and provides step‑by‑step instructions with code snippets to back up, migrate, or analyze ZooKeeper clusters efficiently.

Cloud NativeData ExportTransaction Log
0 likes · 7 min read
Mastering ZooKeeper Data Import/Export with MSE’s New Feature
Java High-Performance Architecture
Java High-Performance Architecture
Dec 4, 2022 · Backend Development

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains the challenges of large‑scale Excel import/export in Java, compares POI workbook implementations, introduces EasyExcel for high‑performance handling of hundreds of thousands to millions of rows, and provides detailed code examples for batch querying, sheet management, and JDBC batch insertion with transaction control.

Batch ProcessingData ExportEasyExcel
0 likes · 23 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Java Architect Essentials
Java Architect Essentials
Nov 14, 2022 · Big Data

Efficient Import and Export of Millions of Records Using Apache POI and EasyExcel

This article explains how to handle massive Excel import and export tasks in Java by comparing traditional POI implementations, selecting the appropriate Workbook type based on data volume, and leveraging Alibaba's EasyExcel library together with batch JDBC operations to process over three million rows with minimal memory usage and high performance.

Apache POIBig DataData Export
0 likes · 22 min read
Efficient Import and Export of Millions of Records Using Apache POI and EasyExcel
Su San Talks Tech
Su San Talks Tech
Oct 6, 2022 · Backend Development

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains how to handle massive Excel import and export tasks in Java by comparing POI's HSSFWorkbook, XSSFWorkbook, and SXSSFWorkbook, selecting the right implementation, and using Alibaba's EasyExcel together with batch queries and JDBC batch inserts to process three million rows efficiently without memory overflow.

Apache POIData ExportEasyExcel
0 likes · 20 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Architect
Architect
Oct 3, 2022 · Big Data

Efficient Import and Export of Massive Data Using POI and EasyExcel

This article explains how to handle large‑scale Excel import and export in Java by comparing traditional POI workbooks, selecting the appropriate implementation based on data volume and requirements, and presenting a high‑performance solution with EasyExcel, batch processing, and JDBC transactions for hundreds of millions of rows.

Data ExportEasyExcelPOI
0 likes · 22 min read
Efficient Import and Export of Massive Data Using POI and EasyExcel
Programmer DD
Programmer DD
Oct 18, 2021 · Backend Development

Master Excel Processing in Java with Alibaba EasyExcel: Setup, Read, and Export

This guide walks through integrating Alibaba's EasyExcel library into a Java project, covering Maven dependencies, environment setup, reading Excel files with less or more than 1000 rows (including custom sheet and row offsets), and exporting data using simple lists, model mapping, and multiple sheets, all illustrated with complete code examples.

Data ExportEasyExcelExcel
0 likes · 17 min read
Master Excel Processing in Java with Alibaba EasyExcel: Setup, Read, and Export
ITPUB
ITPUB
Jun 22, 2021 · Databases

Master DataGrip: Essential Tips for Efficient Database Management

This guide walks you through installing DataGrip, configuring drivers, connecting to various databases, using its powerful SQL editor with shortcuts, customizing appearance, performing data export/import, and leveraging advanced navigation and editing features to boost productivity.

Data ExportDataGripDatabase Management
0 likes · 12 min read
Master DataGrip: Essential Tips for Efficient Database Management
php Courses
php Courses
May 8, 2021 · Backend Development

Efficient CSV Export in PHP for Large Datasets

This article explains how to efficiently export large datasets to CSV files using PHP, describing the CSV format, why a simple streaming approach outperforms PHPExcel, performance expectations for 200,000 rows, and provides a complete PHP function that handles encoding, buffering, and memory‑friendly output.

CSVData ExportPHP
0 likes · 3 min read
Efficient CSV Export in PHP for Large Datasets
Python Crawling & Data Mining
Python Crawling & Data Mining
Jan 7, 2021 · Fundamentals

Master Excel Export with Pandas: Styling, Formatting, and Engine Tricks

This guide walks you through preparing data with Pandas, saving it to Excel using direct to_excel, ExcelWriter with custom date and number formats, applying styles via Pandas Styler, leveraging both xlsxwriter and openpyxl engines for advanced formatting, auto‑adjusting column widths, and using templates for reusable layouts, all illustrated with code snippets and screenshots.

Data ExportExcelStyling
0 likes · 22 min read
Master Excel Export with Pandas: Styling, Formatting, and Engine Tricks
Laravel Tech Community
Laravel Tech Community
Apr 27, 2020 · Backend Development

Using Laravel FastExcel for Efficient Import and Export of Large Datasets

Laravel FastExcel provides a memory‑friendly alternative to Laravel Excel for importing and exporting data, demonstrating installation via Composer, basic export of collections or models, handling large datasets with generators, and various import configurations, while emphasizing performance considerations such as max_execution_time.

Data ExportFastExcelPHP
0 likes · 5 min read
Using Laravel FastExcel for Efficient Import and Export of Large Datasets
Java Captain
Java Captain
Oct 13, 2019 · Backend Development

Implementing a Flexible Excel Export Utility in Java with Apache POI

This article explains how to design a reusable Java utility for exporting large volumes of data to Excel using Apache POI, covering header configuration, data transformation, cell formatting, multi‑threaded data retrieval, asynchronous processing, and provides sample code and usage instructions.

Data ExportExcelPOI
0 likes · 15 min read
Implementing a Flexible Excel Export Utility in Java with Apache POI
Java Captain
Java Captain
Jun 20, 2018 · Backend Development

Export Excel Files in Java Using Apache POI

This article demonstrates how to use Apache POI in Java to export collections of JavaBean objects to Excel files, covering generic reflection‑based implementation, styling, handling of dates, booleans, images, and integration with a servlet for download.

Apache POIData ExportExcel export
0 likes · 12 min read
Export Excel Files in Java Using Apache POI
Practical DevOps Architecture
Practical DevOps Architecture
Jul 1, 2016 · Databases

SQL Data Import/Export and Table Operations Tutorial

This tutorial demonstrates how to create a MySQL database and table, import data from /etc/passwd, add an auto‑increment primary key, export selected records to a file, and perform common SQL queries, conditions, and table‑record manipulations such as insert, update, and delete.

Data ExportDatabase OperationsMySQL
0 likes · 10 min read
SQL Data Import/Export and Table Operations Tutorial