2 SPL Application Development

 

Something Could Double the Development Efficiency of Java Programmers
Understand SPL in three aspects

A Universal File Format N Times Faster Than CSV
This Is Probably the Most Lightweight Columnar Storage Technology

SPL Reporting: Cross-Database Migratable Reports
SPL Reporting: Make Lightweight, Mixed-Source Reports without Logical Data Warehouse
SPL Reporting: Lightweight, Low-Cost, Realtime Hot Data Reporting Solution
This Is Probably the Most Lightweight Alternative Technology to Logical Data Warehouses
This Is Likely the Computing Technology that Supports the Most Data Sources
SPL Reporting: Hot-Swapping and Microservitization

Middleware

DCM: A New Member of Middleware Family
SPL: The Open-source Java Library to Process Structured Data

Goodbye, Stored Procedures - the Love/Hate Thing
Data business in applications: Java or SQL?

Open-source SPL Makes Microservices More “Micro”
SPL: The Sharpest Tool for Handling Post-SQL Computations

Open-source SPL that can execute SQL without RDB
Which Tool Is Ideal for Diverse Source Mixed Computations
Computing engine on open-format files
Handling Excel Files in Java: From POI to SPL
Computing engine on WEB
From JSONPath and XPath to SPL
The Open-source SPL Boosts MongoDB Computing Ability

What to use for data preparation in report, query or analysis business?
The Open-source SPL Optimizes Report Application and Handles Endless Report Development Needs
Create Easy and Efficient T+0 Queries with Open-source SPL

The significance of open computing ability from the perspective of SPL
Open-source SPL: The Breaker of Closed Database Computing System
Data storing using file or database, which is more suitable?

Why ETL Becomes ELT or Even LET?
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases
Routable computing engine implements front-end database

esProc SPL, the challenger of SQLite
Interpreting Low-Code from the perspective of open-source SPL

HowTo

Mixed Computing on Multi Datasources

How to execute SQL on CSV files with esProc SPL
How to operate large CSV files with esProc SPL
How to query CSV as a database table in Java with esProc
How to Operate nested JSON from RESTful with esProc
How to Implement Merge Operations Across Tables from Multiple Databases with esProc

How to Implement Mixed Computations Between Oracle and MySQL with esProc

How to Implement Hot-Cold Data Mixed Computing with esProc

Dump Data to Speed up

How to Dump Database Tables into Files to Speed Up Queries with esProc
How to Speed Up COUNT DISTINCT with esProc
How to Speed Up JOIN to Avoid Wide Tables with esProc
How to Speed Up Associations between Large Primary and Sub Tables with esProc
How to Speed Up EXISTS in Primary-Subtable Joins with esProc
How to Speed Up Conditional Filtering on Enumerated Fields with esProc

Development Optimization

How to simplify nested SQL in applications with esProc
How to supplement the missing capabilities of database SQL with esProc
How to simplify MongoDB queries with esProc

Other Practices

Application Computing

SPL Practice: Structured Text computing
SPL Practices: Cross-database SQL Migration
SPL Practice Series: Data Dump and Comparison
SPL Practices:Mixed-Source Computing
SPL Practice Series: JDBC Parallel Data Retrieval
SPL Practice: Data Comparison between Different Types of Databases