EsProc
esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine.
Install / Use
/learn @SPLWare/EsProcREADME
About esProc SPL
esProc SPL is a programming language. Unlike most text-based programming languages, SPL code is written in a grid similar to Excel, and just like Excel, you can see the execution results step by step in real-time. This reduces the learning curve for beginners and provides an excellent interactive experience:
SPL provides standard programming language features like branching, looping, and even recursion. Notably, SPL has powerful set operation capabilities, making the code more concise. For instance, the famous eight queens puzzle can be solved in just a few lines.
You can try it at: https://try.esproc.com/splx?3VU, and find more code examples at: https://c.esproc.com/article/1688024127696#toc_h2_2.
SPL stands for Structured Process Language, and its main goal is structured data computation. Currently, SQL is the mainstream language in this field, but SQL has many limitations and often requires external help, such as Python, to implement a full computational task. SPL introduces discreteness based on set operations for structured data tables, integrating the shared advantages of SQL and Java, allowing you to achieve the effect of SQL+Python using only SPL.
From this essay The most powerful grouping operation in history, bar none, you can gain insight into one aspect of SPL's stronger language capabilities and understand why SPL can cover SQL+Python. With even more powerful features yet to be explored, SPL has the potential to revolutionize how complex data processing tasks are handled.
We are constantly collecting practical SQL problems and solving them in SPL here: https://c.esproc.com/tag/Application. Through these examples, you'll further appreciate SPL's elegance and powerful cappabilities.
esProc is developed entirely in Java, allowing it to be seamlessly integrated into Java applications and deployed as part of them. SPL also offers robust multi-data source capabilities, supporting a variety of data sources, including RDBs, NoSQL, and more - possibly the most in the industry.
esProc can easily implement lightweight multi-data source hybrid computations, rather than relying on a heavy logical data warehouse, making it an ideal embedded computation engine for report queries and other application systems.
Install and start
For open-source users, we have not provided an automatic installation package, but rather a ZIP file. You can find the installation instructions here: https://c.esproc.com/article/1718848717817.
Additionally,Eclipse developer can download the source code and obtain instructions here.
Note: the source code of com.scudata.ide module is located in ide directory, and you need to add its corresponding folder under "Source folders". Find more details in https://c.esproc.com/article/1677815008127.
For other editions, installation packages can be downloaded from https://www.esproc.com/download-esproc/. No further instructions are necessary, as the installation process is straightforward.
Learn esProc SPL
This book: SPL Programming is a good start for learning SPL syntax. The book intends for beginners who do not have any programming experiences. Look it through quickly if you are a veteran, but the object understanding explained in section 4.4 is worth a study. Chapter 5 is important, too. It explains SPL’s set-oriented way of thinking, which is q
Related Skills
oracle
341.2kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
prose
341.2kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
84.5kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
84.5kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
