-
-
lisongbo • Promote • 1 Reply 19 View • 2026-07-10 18:34:33
Code-as-Documentation: An SQL Development Paradigm for the AI Era
-
jinxing • Promote • 1 Reply 25 View • 2026-07-09 10:19:23
SQLazy：Conditional Running Total with Reset
-
lisongbo • Promote • 1 Reply 27 View • 2026-07-08 09:40:05
Compilable and Executable Pseudocode (spec) Solves AI Coding Hallucinations
-
lisongbo • Promote • 1 Reply 27 View • 2026-07-01 17:08:51
SQLazy: Querying the Start Timestamp of the Next Group from the Event Table
-
lisongbo • Promote • 1 Reply 19 View • 2026-07-01 17:04:16
SQLazy: Merging Overlapping Time Intervals
-
-
lisongbo • Promote • 1 Reply 30 View • 2026-06-30 14:28:40
SQLazy: Account-based Grouping with Sequence Number Reset on Gaps Exceeding 1 Hour
-
lisongbo • Promote • 1 Reply 30 View • 2026-06-22 20:20:58
When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data
-
lisongbo • Promote • 1 Reply 35 View • 2026-06-12 08:23:41
Stop trusting AI-generated SQL blindly: Build queries step-by-step with SQLazy
-
-
jinxing • esProc • 1 Reply 44 View • 2025-12-15 08:46:06
A Field Guide to Querying and Report Computations with SPL
-
mars • eBook • 1 Reply 50 View • 2025-10-24 17:00:44
Data Analytics Programming - From Beginner to Expert
-
chenhu • esProc • 1 Reply 84 View • 2025-08-01 21:52:52
A Lightweight Solution to Speed up Queries by Dumping Data to Files
-
lisongbo • esProc • 1 Reply 87 View • 2025-07-07 10:35:34
SPL Lightweight Multisource Mixed Computation Practices
-
lisongbo • esProc • 1 Reply 58 View • 2025-05-13 09:19:17
How to Implement JOIN Operations Between Tables from Different Databases with esProc
-
lisongbo • Promote • 1 Reply 82 View • 2025-04-28 11:53:30
How to Implement Merge Operations Across Tables from Multiple Databases with esProc
-
chenhu • eBook • 1 Reply 77 View • 2025-04-27 10:17:11
How to Speed Up Conditional Filtering on Enumerated Fields with esProc
-
chenhu • esProc • 1 Reply 74 View • 2025-04-30 09:01:36
How to Speed Up EXISTS in Primary-Subtable Joins with esProc
-
chenhu • esProc • 1 Reply 75 View • 2025-04-23 11:49:41
How to Speed Up Associations between Large Primary and Sub Tables with esProc
-
lisongbo • Promote • 1 Reply 69 View • 2025-04-22 08:42:33
How to Operate nested JSON from RESTful with esProc
-
lisongbo • Promote • 1 Reply 42 View • 2025-04-20 08:55:20
Analyzing DuckDB’s Performance Optimization through TOPN and COUNT DISTINCT Operations
-
lisongbo • esProc • 1 Reply 82 View • 2025-04-18 08:44:48
How to Dump Database Tables into Files to Speed Up Queries with esProc
-
chenhu • esProc • 1 Reply 86 View • 2025-04-29 10:06:34
How to Speed Up JOIN to Avoid Wide Tables with esProc
-
lisongbo • Promote • 1 Reply 59 View • 2025-04-11 11:18:13
How to Implement Hot-Cold Data Mixed Computing with esProc