1 esProc SPL&Code

 

SPL Understanding

Low Code Written in the Grid
What to use for data analysis programming, SQL, Python, or esProc SPL?

This Is Probably the Most Interactive Data Analysis Programming
This is probably the most user-friendly programming for Excel data analysts

This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points
Using SQL for data analysis seems to be a false proposition
SPL: a database language featuring easy writing and fast running
Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs?
What can we do while facing the huge difficulty of writing too long, multiple-level nested SQL codes?


Is SPL more difficult or easier than SQL?
Can SPL and SQL be integrated?

Competition of data processing languages on JVM: Kotlin, Scala and SPL
Java or SQL, which is faster for data operation?
Using Java/Python in place of stored procedure for batch jobs?
Two major shortcomings of Python in enterprise applications
The impasse of SQL performance optimizing
What should we do when SQL (and stored procedure) runs too slowly?

Technical Discussion

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

Code Example

10 lines of code to achieve handwritten digit recognition

Calculate prime number table within 10000 using screening method
Calculate the first N terms of the Fibonacci sequence
Simulate random card issuance
Find the cycle section for infinite cyclic decimals
Count the occurrence rate of words
Perpetual Calendar
Eight Queens
24 Point Game

List the management structure tree
Barcode Inspection and Verification (# 60)