DEV Community

Judy profile picture

Judy

Like open source, follow open source

One Year Club
8 Week Community Wellness Streak
4 Week Community Wellness Streak
Writing Debut
2 Week Community Wellness Streak
4 Week Writing Streak
1 Week Community Wellness Streak
Structured Text computing: SPL Practice

Structured Text computing: SPL Practice

6
Comments 1
18 min read

Want to connect with Judy?

Create an account to connect with Judy. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Data Comparison between Different Types of Databases-SPL Practice

Data Comparison between Different Types of Databases-SPL Practice

6
Comments
5 min read
How to Speed Up Conditional Filtering on Enumerated Fields with esProc

How to Speed Up Conditional Filtering on Enumerated Fields with esProc

7
Comments
6 min read
How to Speed Up EXISTS in Primary-Subtable Joins with esProc

How to Speed Up EXISTS in Primary-Subtable Joins with esProc

6
Comments
5 min read
How to Speed Up Associations between Large Primary and Sub Tables with esProc

How to Speed Up Associations between Large Primary and Sub Tables with esProc

7
Comments 1
4 min read
How to Implement Mixed Computations Between Oracle and MySQL with esProc

How to Implement Mixed Computations Between Oracle and MySQL with esProc

6
Comments 2
4 min read
How to Implement JOIN Operations Between Tables from Different Databases with esProc?

How to Implement JOIN Operations Between Tables from Different Databases with esProc?

6
Comments 1
8 min read
How to operate large CSV files with esProc SPL

How to operate large CSV files with esProc SPL

6
Comments 6
3 min read
Data storing using file or database, which is more suitable?

Data storing using file or database, which is more suitable?

7
Comments 2
9 min read
Is This a Refreshing Way to Understand Association?

Is This a Refreshing Way to Understand Association?

6
Comments 1
7 min read
Using SQL for data analysis seems to be a false proposition

Using SQL for data analysis seems to be a false proposition

9
Comments 7
6 min read
What should we do when SQL (and stored procedure) runs too slowly?

What should we do when SQL (and stored procedure) runs too slowly?

13
Comments 6
13 min read
How to merge overlapping time intervals with esProc

How to merge overlapping time intervals with esProc

6
Comments 1
3 min read
Ordered grouping

Ordered grouping

6
Comments
6 min read
How to Build a Streaming Deduplication Pipeline with Kafka, GlassFlow, and ClickHouse

How to Build a Streaming Deduplication Pipeline with Kafka, GlassFlow, and ClickHouse

11
Comments
12 min read
How to check the same status of data in each row within a group with esProc

How to check the same status of data in each row within a group with esProc

6
Comments
2 min read
How to Operate nested JSON from RESTful with esProc

How to Operate nested JSON from RESTful with esProc

6
Comments
4 min read
How to quickly transform multi-layer sets in JSON strings

How to quickly transform multi-layer sets in JSON strings

7
Comments
2 min read
A programming language coding in a grid

A programming language coding in a grid

5
Comments
17 min read
How to simplify the Merge Operations Across Tables from Multiple Databases

How to simplify the Merge Operations Across Tables from Multiple Databases

6
Comments
6 min read
How to simply perform the difference set operation of a continuous interval ?

How to simply perform the difference set operation of a continuous interval ?

6
Comments 1
3 min read
How to supplement the missing capabilities of database SQL with esProc

How to supplement the missing capabilities of database SQL with esProc

6
Comments
6 min read
How to set duplicate content in a dataset to null with esProc

How to set duplicate content in a dataset to null with esProc

5
Comments
2 min read
Statistics by time window: SPL VS SQL #16

Statistics by time window: SPL VS SQL #16

6
Comments
3 min read
How to Dump Database Tables into Files to Speed Up Queries with esProc

How to Dump Database Tables into Files to Speed Up Queries with esProc

7
Comments
5 min read
How to Use esProc to Speed Up JOIN to Avoid Wide Tables

How to Use esProc to Speed Up JOIN to Avoid Wide Tables

6
Comments
6 min read
How to Implement Hot-Cold Data Mixed Computing with esProc

How to Implement Hot-Cold Data Mixed Computing with esProc

6
Comments
4 min read
This Is Likely the Computing Technology that Supports the Most Data Sources

This Is Likely the Computing Technology that Supports the Most Data Sources

8
Comments
5 min read
How to Speed Up COUNT DISTINCT with esProc

How to Speed Up COUNT DISTINCT with esProc

7
Comments
4 min read
Deduplicate between an uncertain number of columns:SQL VS SPL #15

Deduplicate between an uncertain number of columns:SQL VS SPL #15

7
Comments
2 min read
How to simplify MongoDB queries with esProc

How to simplify MongoDB queries with esProc

6
Comments
4 min read
How to simplify nested SQL in applications with esProc

How to simplify nested SQL in applications with esProc

11
Comments
4 min read
SPL: The Professional Choice for Processing Multi-Layered JSON Data

SPL: The Professional Choice for Processing Multi-Layered JSON Data

6
Comments
5 min read
Find the closest date match for each record from two tables:SQL VS SPL #14

Find the closest date match for each record from two tables:SQL VS SPL #14

5
Comments
2 min read
SPL assists MongoDB: Only keep the running total for the last item in the partition

SPL assists MongoDB: Only keep the running total for the last item in the partition

6
Comments
2 min read
How to query CSV as a database table in Java with esProc

How to query CSV as a database table in Java with esProc

6
Comments
3 min read
SPL assists MongoDB: Grouping adjacent documents

SPL assists MongoDB: Grouping adjacent documents

7
Comments
2 min read
Find the superset from the relationship table:SQL VS SPL#13

Find the superset from the relationship table:SQL VS SPL#13

6
Comments
1 min read
How to execute SQL on CSV files with esProc SPL

How to execute SQL on CSV files with esProc SPL

7
Comments
3 min read
Comparison of esProc SPL and DuckDB in Multi-Data Source Capabilities

Comparison of esProc SPL and DuckDB in Multi-Data Source Capabilities

5
Comments
4 min read
Space-time collision problem that renders MPP powerless to solve: SPL practice

Space-time collision problem that renders MPP powerless to solve: SPL practice

6
Comments
11 min read
Unconventional Yet Common Aggregation Operations

Unconventional Yet Common Aggregation Operations

6
Comments
6 min read
Get the records after and before the searched one:SQL VS SPL #12

Get the records after and before the searched one:SQL VS SPL #12

6
Comments
2 min read
esProc SPL: Equivalent to the Python-enhanced DuckDB

esProc SPL: Equivalent to the Python-enhanced DuckDB

6
Comments
2 min read
Do ordered grouping and aggregation within groups:SQL VS SPL #11

Do ordered grouping and aggregation within groups:SQL VS SPL #11

6
Comments
2 min read
This Is Probably the Most Lightweight Columnar Storage Technology

This Is Probably the Most Lightweight Columnar Storage Technology

7
Comments
4 min read
Track Production Operations Outcome Progression with Conditional NULLs :SQL VS SPL

Track Production Operations Outcome Progression with Conditional NULLs :SQL VS SPL

6
Comments
2 min read
Farewell to Window Functions, Embrace esProc SPL

Farewell to Window Functions, Embrace esProc SPL

6
Comments
5 min read
Complement a certain average value to ensure that the total sum remains unchanged:SQL VS SPL

Complement a certain average value to ensure that the total sum remains unchanged:SQL VS SPL

9
Comments
2 min read
Can you imagine such a short code solving the 24-point game?

Can you imagine such a short code solving the 24-point game?

6
Comments 1
3 min read
The Most Powerful grouping Operations in History, Bar None

The Most Powerful grouping Operations in History, Bar None

6
Comments
7 min read
Convert cross cell to row header, row header to column:From SQL to SPL

Convert cross cell to row header, row header to column:From SQL to SPL

6
Comments
2 min read
The Simplest Eight Queens Code You’ll Find Online

The Simplest Eight Queens Code You’ll Find Online

7
Comments 2
3 min read
Why Developers Are Ditching SQL Pain Points with Open-Source SPL

Why Developers Are Ditching SQL Pain Points with Open-Source SPL

6
Comments
7 min read
Flexible interval aggregation:From SQL to SPL

Flexible interval aggregation:From SQL to SPL

6
Comments
2 min read
SQL does data analysis dilemma, query language can not answer the truth

SQL does data analysis dilemma, query language can not answer the truth

6
Comments
6 min read
Data Analysis Showdown: Comparing SQL, Python, and esProc SPL

Data Analysis Showdown: Comparing SQL, Python, and esProc SPL

7
Comments
5 min read
The Open-source SPL Boosts MongoDB Computing Ability

The Open-source SPL Boosts MongoDB Computing Ability

7
Comments
3 min read
Align the existing data to the corresponding position and fill in any missing data with 0:From SQL to SPL

Align the existing data to the corresponding position and fill in any missing data with 0:From SQL to SPL

6
Comments
2 min read
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster ThanORACLE”anExaggeration?

Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster ThanORACLE”anExaggeration?

6
Comments
5 min read
loading...