Lmst

So many to choose from: In his latest post, Mark Litwintschik compares a range of global administrative #boundary datasets, from #OpenStreetMap to #NaturalEarth, assessing geometric #accuracy, data #completeness, and information content. The analysis, powered by #DuckDB...
https://spatialists.ch/posts/2025/12/13-so-many-to-choose-from/ #GIS #GISchat #geospatial #SwissGIS

I have published #DuckDB #NodeJS bindings for #FreeBSD. https://github.com/duckdb/duckdb-node-neo/discussions/349

You know, in case I ever need it (needed an excuse to play with sourcehut's CI).

From the @DSLC :rstats:chives:

:rstats: :python: :julia: DuckDB in Action: Club meetings & An introduction to DuckDB https://youtu.be/Cdi1lPdMfG8 #RStats #PyData #JuliaLang #DuckDB

:rstats: pharmaverse Examples: Demographic Table https://youtu.be/Vgpej0_C3lw #RStats

:rstats: R for Data Science: https://youtu.be/HicrANUfnj0 #RStats

Visit https://dslc.video for hours of new #DataScience videos every week!

Recent @DSLC club meetings:

🦆 DuckDB in Action: Executing SQL Queries https://youtu.be/EHgXpnrJAB4 #RStats #PyData #JuliaLang #duckdb

From the @DSLC :rstats:chives:

:rstats: Advanced R: Functionals https://youtu.be/tYqFMtmhmiI #RStats

:rstats: :javascript: JS4R: Managing JavaScript https://youtu.be/NyBUNAqENhg #RStats #JavaScript

:rstats: SMLTAR: Word Embeddings Part 1 https://youtu.be/2ZxXAUivrVc #RStats

Visit https://dslc.video for hours of new #DataScience videos every week!

The Advent of SQL has started 🎄

This year it's hosted by "Database School" and requires signing up: https://databaseschool.com/series/advent-of-sql/videos/308

I'll be solving the challenges using #DuckDB and my solutions for the first two days are up on my website: https://francoismichonneau.net/2025/12/advent-of-sql/

＜月刊＞S3+DuckDB+GrafanaでQiita記事メトリクスのダッシュボードをつくる vol.3 データのクエリと可視化【完結】
https://qiita.com/melknzw/items/a71b187267e0ae8aec01?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #AWS #S3 #grafana #duckdb #AmazonQ

I'm a tad bit nervous to be presenting an Introductory talk about #DuckDB at the RubySG Dec meetup today (9 Dec)! But I have a good 11million record synthetic dataset to show some of the features!

Register: https://luma.com/0em8ixuy

#Programming #Ruby #Singapore

Using the #duckdb COLUMNS(<regex>) pattern with capture groups to compute and rename multiple columns all in one line of SELECT is *sooo slick*

Been on a DuckDB learning spree lately and really proud of myself for figuring this out by just reading the docs with no AI help (they all come up with more verbose solutions than this and look gross)

$Screenshot showing a query that takes all *_length_mm columns in penguins dataset to derive new *_length_avg_cm columns which take the average values of each column and multiply by 10. With DuckDB, that can be expressed in 1 line of SELECT: `AVG(COLUMNS('(.*_length)_mm')) * 10 AS '\1_avg_cm'`$

No more sf::st_as_text() or st_geomfromtext() to move geospatial data between {sf} and duckdb spatial 😃 https://cidree.github.io/duckspatial/ #gisChat #Rstats #DuckDB

Show HN: DuckDB for Kafka Stream Processing

https://sql-flow.com/docs/tutorials/intro/

#duckdb #sql

Wel een mooie gelegenheid om snelheid te vergelijken. Een query op 10 adressen dichtst bij een WGS84 ('GPS') coordinaat van Radio Kootwijk: Postgis doet dit in ca 8 seconden. DuckDB (live view, geen snapshot dus) in ongeveer hetzelfde (7s), maar DuckDB op een snapshot (vergelijkbaar met Postgis) doet dit in **0.12s** ! 😲🤯 . #DuckDB is echt fantastisch (maar dat wist ik al). 🥰 🦆

Resultaat van een spatial query op 10 adressen bij Radio Kootwijk, met rechtsonder (erg klein) de tijd die dit neemt.

Recent @DSLC club meetings:

🦆 DuckDB in Action: Getting started with DuckDB https://youtu.be/SlIwq5JxKwc #RStats #PyData #JuliaLang #duckdb

From the @DSLC :rstats:chives:

:rstats: R Packages: What am I working on? https://youtu.be/aU4pQTki_tg #RStats

:rstats: RWTF: Read the source & Reproduce the Problem https://youtu.be/Bo77D_7zXj4 #RStats #debugging

Visit https://dslc.video for hours of new #DataScience videos every week!

Today felt more straightfoward than yesterday #aoc2025 #duckdb
https://github.com/mknoszlig/aoc2025/blob/main/4.sql

ran into some limitations wrt concurrency and garbage collection today, which is exactly why I'm doing this :) #aoc2025 #duckdb
https://github.com/mknoszlig/aoc2025/blob/main/3.sql

#orgmode and #duckdb with the lovely ob-duckdb is handy. Being able to do some exploratory data analysis, and then a little commentary to produce a standalone html file is great