🤖robot.villas
PostsTagsStatsStatusAbout

© 2025 - 2026 Nat Welch. All rights reserved.

← All bots

Roland Bouman's blog

@roland_boumans_blog@robot.villas

Roland Bouman writes about SQL, MySQL, DuckDB, analytics, query performance, business intelligence, and software development.

Source: https://rpbouman.blogspot.com/feeds/posts/default

Homepage: https://rpbouman.blogspot.com

Follow from your server

Enter the server your account is on. You'll finish following there.

or
Or search your app for@roland_boumans_blog@robot.villas

Don't have an account? Find a server at joinmastodon.org

Posts
25
Followers
0
Following
0

Posts

  • DuckDb Performance: min, max, and median vs quantile #DuckDB #Analytics #Performance

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454378

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454378

    Don't have an account? Find a server at joinmastodon.org

    Aug 6, 2026

  • DataZen winter meetup 2025 #Data #Analytics #Community

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454383

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454383

    Don't have an account? Find a server at joinmastodon.org

    Jan 22, 2025

  • DuckDB Bag of Tricks: Reading JSON, Data Type Detection, and Query Performance #DuckDB #SQL #DataEngineering

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454392

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454392

    Don't have an account? Find a server at joinmastodon.org

    Dec 19, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454399

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454399

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454409

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454409

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454419

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454419

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454428

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454428

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454443

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454443

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454450

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454450

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

  • DuckDB Bag of Tricks: First Splash #DuckDB #Analytics #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454462

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454462

    Don't have an account? Find a server at joinmastodon.org

    Jul 11, 2024

  • SAP HANA Trick: DISTINCT STRING_AGG #SQL #Analytics #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454470

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454470

    Don't have an account? Find a server at joinmastodon.org

    Mar 26, 2024

  • UI5 Tips: Persistent UI State #UI5 #WebDev #Software

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454476

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454476

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2024

  • UI5 Tips: Persisting JSONModel data using browser Storage #UI5 #WebDev #DataStorage

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454485

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454485

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2024

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454493

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454493

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2024

  • UI5 Tips: Buffering Events to avoid a request-storm #UI5 #WebDev #Performance

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454503

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454503

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2024

  • UI5 Tips: Manipulating the sap.m.TabContainer close buttons with custom CSS #SAPUI5 #WebDev #CSS

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454511

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454511

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2024

  • UI5 Tips: Adding a Splash-Screen / Loading indicator #UI5 #WebDev #Frontend

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454522

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454522

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2024

  • Year-to-Date on Synapse Analytics 5: Using Window Functions #SQL #Analytics #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454531

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454531

    Don't have an account? Find a server at joinmastodon.org

    Feb 22, 2021

  • Year-to-Date on Synapse Analytics 4: Using UNION and GROUP BY #SQL #Analytics #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454540

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454540

    Don't have an account? Find a server at joinmastodon.org

    Feb 22, 2021

  • Year-to-Date on Synapse Analytics 3: Using a Subquery #SQL #Analytics #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454547

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454547

    Don't have an account? Find a server at joinmastodon.org

    Feb 22, 2021

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

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454554

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454554

    Don't have an account? Find a server at joinmastodon.org

    Feb 22, 2021

  • Year-to-Date on Synapse Analytics 1: Background #Analytics #SQL #Data

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454561

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454561

    Don't have an account? Find a server at joinmastodon.org

    Feb 22, 2021

  • Building a UI5 Demo for SAP HANA Text Analysis: Part 4 #SAP #Analytics #Dev

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454569

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454569

    Don't have an account? Find a server at joinmastodon.org

    Dec 1, 2019

  • Building a UI5 Demo for SAP HANA Text Analysis: Part 3 #SAP #Analytics #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454577

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454577

    Don't have an account? Find a server at joinmastodon.org

    Dec 1, 2019

  • Building a UI5 Demo for SAP HANA Text Analysis: Part 2 #SAP #Analytics #Dev

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454585

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/roland_boumans_blog/posts/22454585

    Don't have an account? Find a server at joinmastodon.org

    Nov 30, 2019