data-export | BestHub

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.

Approval WorkflowMySQLSQL parsing

0 likes · 15 min read

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

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.

Pythondata analysisdata-export

0 likes · 10 min read

Selected Java Interview Questions

Oct 15, 2024 · Databases

Analysis of a Complex SQL Query for Exporting Manually Added Contacts

This article breaks down a sophisticated SQL script used to export manually added contact data, explaining the involved tables, the construction of the @abc variable, the two UNIONed sub‑queries, and the final selection logic with detailed code examples.

DatabaseMySQLQuery Analysis

0 likes · 12 min read

Analysis of a Complex SQL Query for Exporting Manually Added Contacts

Architecture Digest

Apr 16, 2023 · Databases

Getting Started with DataGrip: Installation, Configuration, and Common Features

This guide introduces DataGrip, a JetBrains database client, covering download, installation, theme selection, driver management, connection setup, SQL editing shortcuts, data export/import, table creation, navigation, and various productivity features for efficient database development.

DataGripJetBrainsSQL

0 likes · 12 min read

Getting Started with DataGrip: Installation, Configuration, and Common Features

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.

EasyExcelExcelJava

0 likes · 23 min read

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

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 DataEasyExcel

0 likes · 22 min read

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

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.

EasyExcelJavadata-export

0 likes · 22 min read

Efficient Import and Export of Massive Data Using POI and EasyExcel

Architect's Tech Stack

Sep 29, 2022 · Databases

Comprehensive Guide to Using JetBrains DataGrip for Database Management

This article provides a detailed tutorial on JetBrains DataGrip, covering installation, driver management, connection configuration, SQL editing shortcuts, data import/export, schema visualization, and various productivity features for efficiently working with relational databases.

DataGripDatabase ManagementJetBrains

0 likes · 11 min read

Comprehensive Guide to Using JetBrains DataGrip for Database Management

Top Architect

Mar 27, 2022 · Backend Development

EasyExcel Quick Guide: Features, Annotations, Dependencies, and Usage Examples

This article introduces Alibaba's EasyExcel library, explains its memory‑efficient design, lists its main advantages and common annotations, provides Maven dependencies, and demonstrates import and export code snippets for Java backend applications.

EasyExcelExcelJava

0 likes · 8 min read

EasyExcel Quick Guide: Features, Annotations, Dependencies, and Usage Examples

Sohu Tech Products

Feb 9, 2022 · Backend Development

Java Excel Export Utility: Design, Implementation, and Usage with Apache POI

This article explains how to build a flexible Java utility for exporting large volumes of report data to Excel using Apache POI, covering customizable headers, field formatting, multithreaded data retrieval, asynchronous processing, and deployment steps.

Apache POIExcelJava

0 likes · 13 min read

Java Excel Export Utility: Design, Implementation, and Usage with Apache POI

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.

CSVPHPbackend

0 likes · 3 min read

Efficient CSV Export in PHP for Large Datasets

Python Programming Learning Circle

Jan 19, 2021 · Backend Development

Exporting Large Datasets to Excel Using Python (openpyxl and xlwt)

This article explains how to export massive amounts of data from Python to Excel by installing openpyxl, providing complete code examples for reading and writing both .xlsx and .xls files, comparing xlrd/xlwt with openpyxl, and recommending the best approach for large‑scale data export.

CSVExcelPython

0 likes · 10 min read

Exporting Large Datasets to Excel Using Python (openpyxl and xlwt)

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.

@ImportFastExcelGenerators

0 likes · 5 min read

Using Laravel FastExcel for Efficient Import and Export of Large Datasets

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.

ExcelJavaMulti-threading

0 likes · 15 min read

Implementing a Flexible Excel Export Utility in Java with Apache POI

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 POIExcel ExportJava

0 likes · 12 min read

Export Excel Files in Java Using Apache POI

System Architect Go

Nov 7, 2017 · Backend Development

Exporting Excel Files on the Server with js-xlsx and exceljs

This article explains how to generate and serve XLSX files from a backend server using the JavaScript libraries js-xlsx and exceljs, covering data preparation, server implementation, and styling options for rows, columns, and cells.

Exceldata-exportexceljs

0 likes · 3 min read

Exporting Excel Files on the Server with js-xlsx and exceljs

System Architect Go

Jul 1, 2017 · Frontend Development

Exporting Table Data to CSV on the Frontend Using Blob and a.download

This article explains how to generate and download CSV files directly in the browser by converting JSON data into comma‑separated values, using the Blob API and the anchor element’s download attribute, and includes advanced techniques for custom headers and handling Excel formatting issues.

CSVJavaScriptblob

0 likes · 5 min read

Exporting Table Data to CSV on the Frontend Using Blob and a.download

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.

Database OperationsMySQLSQL

0 likes · 10 min read

SQL Data Import/Export and Table Operations Tutorial