esProc SPL Community Discussions

refers http://c.raqsoft.com/article/1687916213139 In addition to common static code, sometimes dynamic code is also needed to solve problems, such as generating code (or part of code) based on parameters and dynamically executing it. For... Read more

Many small and micro applications also require certain data processing and computing abilities. Integrating a database will make the application too heavy. In this case, SQLite is a good choice for its simple framework, easy-integration, ability of storing data persistently and, it provides SQL... Read more

In our daily work, we often need to query and analyze data files (such as csv/xls file), most of which have quite regular form (each row corresponds to one record) and can be regarded as a database table, and it will be relatively convenient to calculate such files in SQL. However, we often have... Read more

This article is about applying SPL, explains various operations over big file, illustrates how to make the computation faster using parallel processing, and gives concise sample programs in esProc SPL. Structured text file processing, such as TXT and CSV files, is common data analysis work.... Read more

Many scenarios need to use programming language to analyze and process the desktop data such as Excel and csv. In these scenarios, simple tasks include querying multiple files of same format through parameter, batch splitting or merging files, processing larger files, etc.; complex tasks include... Read more

refer to http://c.raqsoft.com/article/1642763952755

In terms of structured data calculation outside the database, Stream has taken a step from scratch; Kotlin has slightly enhanced this capability, but the nature of the compiled language makes it impossible to go further; To really solve the problem of structured data computing outside the... Read more

Many big data calculations are implemented in SQL. When running slowly, we have to optimize SQL, but we often encounter situations that we can do nothing about it. SPL maybe a better choice, refter to Read more

After we retrieve data from the data source as a table sequence in SPL, we can perform all SQL-style operations, such as filtering, aggregation, inter-column calculations, sorting, grouping & aggregation, top-N, post-grouping top-N, distinct, post-grouping distinct, and join to name a few.... Read more

esProc can be used for analytical databases and middleware. Its computing power and expression ability far exceed traditional SQL, and it is suitable for online query and offline batch running scenarios. Refer to Read more