Tagged articles
data export
43 articles · Page 1 of 1
This chapter from 'Architecture Fundamentals' details relational big data architecture patterns: sharding strategies, query optimization avoiding unbounded scans, async import/export with streaming I/O, idempotency, and a bottleneck-first evolution checklist that prioritizes product-level constraints over premature scaling.
Shardingasync processingbig data architecture
0 likes · 9 min read

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.
ElasticsearchJavaKafka
0 likes · 40 min read

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.
BackendEasyExcelExcel Export
0 likes · 11 min read

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.
ElasticsearchPITbig data
0 likes · 7 min read

This guide walks through creating a PHP-based feedback collection system, covering form creation, data validation, secure storage, automated email notifications, admin interface with authentication, tagging, and periodic CSV export for analysis.
Admin DashboardEmail NotificationForm Handling
0 likes · 6 min read

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.
EasyExcelJavaPOI
0 likes · 21 min read

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.
Database SecurityMySQLSQL parsing
0 likes · 15 min read

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.
EasyExceldata exportexcel-import
0 likes · 14 min read

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

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.
CSVExcelMongoDB
0 likes · 11 min read

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.
BackendMySQLSQL
0 likes · 12 min read

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.
ClickHouseJSONNDJSON
0 likes · 3 min read

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.
ExcelPECLPHP
0 likes · 7 min read

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.
EasyExcelJavaPOI
0 likes · 22 min read

This guide compiles essential MySQL command‑line scripts covering database and table export, import, creation, alteration, permission granting, and common DDL/DML operations, providing clear examples for managing schemas, data, and user privileges in a MySQL environment.
DDLDMLMySQL
0 likes · 10 min read

This article explains how to export large MySQL datasets in SpringBoot by streaming data directly to CSV, avoiding full‑memory loads that cause OutOfMemoryError, and provides complete JPA and MyBatis implementations, performance testing, and practical code examples for production use.
CSVJPAMyBatis
0 likes · 13 min read

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.
DataGripIDEJetBrains
0 likes · 12 min read

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

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.
DDLMySQLSQL
0 likes · 11 min read

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.
Transaction LogZooKeepercloud native
0 likes · 7 min read

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.
EasyExcelJDBCJava
0 likes · 23 min read

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 POIEasyExcelbig data
0 likes · 22 min read

This article analyzes traditional POI implementations, compares their strengths and weaknesses, and presents a high‑performance solution using EasyExcel for exporting and importing up to 3 million rows, including batch querying, sheet management, JDBC batch inserts, and detailed performance benchmarks.
EasyExcelJavaPOI
0 likes · 23 min read

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 POIEasyExcelJava
0 likes · 20 min read

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.
EasyExcelJavaPOI
0 likes · 22 min read

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.
DataGripIDEJetBrains
0 likes · 11 min read

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

This article walks through a real‑world Python question about converting several heterogeneous lists into a .txt file, presenting multiple code solutions, explaining the use of eval and loops, and showing the resulting output to help readers solve similar data‑export tasks.
Code ExampleEvalList
0 likes · 5 min read

This article introduces the mongo2file library for converting MongoDB collections into various table formats such as CSV, Excel, JSON, pickle, feather, and parquet, explains its PyArrow dependency, shows installation and quick‑start code, discusses performance bottlenecks, and provides a full reference API.
ExcelMongoDBParquet
0 likes · 11 min read

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

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.
EasyExcelExcelFile I/O
0 likes · 17 min read


ITPUBJun 22, 2021 · Databases
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.
DataGripIDEJetBrains
0 likes · 12 min read

This article provides a step‑by‑step walkthrough of installing DataGrip, configuring data sources, using its SQL console, creating tables, exporting and importing data, and leveraging powerful navigation and editor shortcuts to boost database productivity.
DataGripIDEJetBrains
0 likes · 12 min read

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.
BackendCSVPHP
0 likes · 3 min read

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.
BackendCSVExcel
0 likes · 10 min read

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.
ExcelStylingdata export
0 likes · 22 min read

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.
FastExcelLaravelPHP
0 likes · 5 min read

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.
ExcelJavaPOI
0 likes · 15 min read

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

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.
ExcelExcelJSXLSX
0 likes · 3 min read

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.
MySQLSQLSQL queries
0 likes · 10 min read

This guide introduces the free gDUL 3.0 tool for Oracle DBAs, detailing its export capabilities, directory layout, configurable parameters, platform‑specific setup tips, and step‑by‑step usage to recover data from inaccessible databases.
ASMFree ToolOracle
0 likes · 7 min read

This guide explains how to install the sar tool on various Unix-like systems, configure its data retention and collection intervals, export performance metrics in formats such as CSV, XML, and JSON, and visualize the results using built‑in or third‑party graphing utilities.
LinuxSystem Monitoringdata export
0 likes · 3 min read
