Roland Bouman's blog

DataZen winter meetup 2025

DuckDB Bag of Tricks: Reading JSON, Data Type Detection, and Query Performance

DuckDB bag of tricks: Processing PGN chess games with DuckDB - Rolling up each game's lines into a single game row (6/6)

DuckDB bag of tricks: Processing PGN chess games with DuckDB - Extracting Tagpairs with Regular Expressions (5/6)

DuckDB bag of tricks: Processing PGN chess games with DuckDB - Keeping the lines of a game together (4/6)

DuckDB bag of tricks: Processing PGN chess games with DuckDB - Distinguishing the Line Type (3/6)

DuckDB bag of tricks: Processing PGN chess games with DuckDB - Ingesting raw text with the CSV Reader (2/6)

DuckDB bag of tricks: Processing PGN chess games with DuckDB - An Introduction to PGN (1/6)

DuckDB Bag of Tricks: First Splash

SAP HANA Trick: DISTINCT STRING_AGG

UI5 Tips: Persistent UI State

UI5 Tips: Persisting JSONModel data using browser Storage

UI5 Tips: Change expand/collapse icons for Tree, Panel and TreeTable using only CSS

UI5 Tips: Buffering Events to avoid a request-storm

UI5 Tips: Manipulating the sap.m.TabContainer close buttons with custom CSS

UI5 Tips: Adding a Splash-Screen / Loading indicator

Year-to-Date on Synapse Analytics 5: Using Window Functions

Year-to-Date on Synapse Analytics 4: Using UNION and GROUP BY

Year-to-Date on Synapse Analytics 3: Using a Subquery

Year-to-Date on Synapse Analytics 2: Using a self-JOIN and GROUP BY

Year-to-Date on Synapse Analytics 1: Background

Building a UI5 Demo for SAP HANA Text Analysis: Part 4

Building a UI5 Demo for SAP HANA Text Analysis: Part 3

Building a UI5 Demo for SAP HANA Text Analysis: Part 2

Building a UI5 Demo for SAP HANA Text Analysis: Part 1