mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Server stats:

8.4K
active users

#duckdb

6 posts6 participants1 post today
Jan van der Laan<p><span class="h-card" translate="no"><a href="https://mastodon.online/@statstas" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>statstas</span></a></span> <a href="https://datasci.social/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> can connect to external databases using odbc (<a href="https://duckdb.org/docs/stable/clients/odbc/windows.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">duckdb.org/docs/stable/clients</span><span class="invisible">/odbc/windows.html</span></a>) and can write parquet. That might work (I have zero experience with this).</p>
hrbrmstr 🇺🇦 🇬🇱 🇨🇦<p>I track Stratosphere's 🐘 posts &amp; their bot has a daily top 10 sketch IPs list. My 🧠 kept 👀 lots of "*.100" IPs &amp; I was curious how frequently they showed up. Went back 200 posts w/GH:McKael/madonctl using both R and DuckDB. Def block these. — <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23DuckDB" target="_blank">#DuckDB</a>: <a href="https://ray.so/SdMcBZa" rel="nofollow noopener" target="_blank">ray.so/SdMcBZa</a> — <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23RStats" target="_blank">#RStats</a>: <a href="https://ray.so/naTBBMS" rel="nofollow noopener" target="_blank">ray.so/naTBBMS</a></p>
boB Rudis 🇺🇦 🇬🇱 🇨🇦<p>I track <span class="h-card" translate="no"><a href="https://infosec.exchange/@stratosphere" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>stratosphere</span></a></span>'s posts &amp; their bot has a daily top 10 sketch IPs list. My 🧠 kept 👀 lots of "*.100" IPs &amp; I was curious how frequently they showed up.</p><p>Went back 200 posts w/GH:McKael/madonctl using both R and DuckDB.</p><p>Def block these.</p><p>— <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a>: <a href="https://ray.so/SdMcBZa" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">ray.so/SdMcBZa</span><span class="invisible"></span></a><br>— <a href="https://mastodon.social/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RStats</span></a>: <a href="https://ray.so/naTBBMS" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">ray.so/naTBBMS</span><span class="invisible"></span></a></p>
Thomas Sandmann<p>This week, I learned how to create and explore a data lake with duckdb, using its new ducklake extension. It was surprisingly easy to hand over the creation and management of parquet files with larg(ish) tables to ducklake. I loved being able to explore the data using R, python or plain SQL - even within the same Quarto document! <a href="https://tomsing1.github.io/blog/posts/ducklake/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tomsing1.github.io/blog/posts/</span><span class="invisible">ducklake/</span></a> <a href="https://genomic.social/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RStats</span></a> <a href="https://genomic.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>python</span></a> <a href="https://genomic.social/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> <a href="https://genomic.social/tags/ducklake" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ducklake</span></a> <a href="https://genomic.social/tags/quarto" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>quarto</span></a></p>
Olivier Leroy<p><span class="h-card" translate="no"><a href="https://mapstodon.space/@kylebarron" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>kylebarron</span></a></span> For the neophyte, who is behind that project? <a href="https://fosstodon.org/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a> has very easy to identify leaders since your bring that comparison.</p>
Douglas J Hunley<p>Analyzing <a href="https://fosstodon.org/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a> Trends Through 1.8 Million Hacker News Headlines <a href="https://fosstodon.org/tags/mongo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mongo</span></a> <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> <a href="https://fosstodon.org/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> <a href="https://camelai.com/blog/hn-database-hype/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">camelai.com/blog/hn-database-h</span><span class="invisible">ype/</span></a></p>
Ryan Kennedy<p>I wrote a bit of <a href="https://hachyderm.io/tags/Golang" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Golang</span></a> code to call the Strava API to fetch all of my activities back to 2008. The Go writes each activity as NDJSON, which I then query from <a href="https://hachyderm.io/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a>.</p><p>Surprised to learn I ran+walked+hiked more than 1,000 miles in 2022. I didn't think I'd had any 1k+ mile years so far.</p>
:rss: DevelopersIO<p>DuckDBを使ってS3に格納されているParquetファイルを調査してみた<br><a href="https://dev.classmethod.jp/articles/analyze-s3-parquet-with-duckdb/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.classmethod.jp/articles/an</span><span class="invisible">alyze-s3-parquet-with-duckdb/</span></a></p><p><a href="https://rss-mstdn.studiofreesia.com/tags/dev_classmethod" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dev_classmethod</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a></p>
Ghost Letters<p><span class="h-card" translate="no"><a href="https://chaos.social/@gom" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>gom</span></a></span> <span class="h-card" translate="no"><a href="https://eupolicy.social/@bert_hubert" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>bert_hubert</span></a></span> <span class="h-card" translate="no"><a href="https://mastodon.nl/@joyofcoding" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>joyofcoding</span></a></span> <span class="h-card" translate="no"><a href="https://mastodon.social/@bagder" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>bagder</span></a></span> </p><p>Now (again) I want to try out <a href="https://fosstodon.org/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a></p>
Habr<p>Работа с данными в DuckDB или не pandas’ом единым сыт DS</p><p>В проектах по разработке ML-моделей я регулярно сталкиваюсь с тем, что значительная часть времени уходит не на саму модель, а на приведение данных в нужный формат: очистку, трансформацию, агрегацию. Этот этап требует не только времени, но и вычислительных ресурсов, особенно когда речь идет о больших объемах информации. В этой статье я расскажу о своем небольшом исследовании DuckDB — инструменте, который может значительно упростить и ускорить работу с данными.</p><p><a href="https://habr.com/ru/companies/cinimex/articles/913878/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/cinimex/</span><span class="invisible">articles/913878/</span></a></p><p><a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>анализ_данных</span></a> <a href="https://zhub.link/tags/%D0%B1%D0%B0%D0%B7%D1%8B_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>базы_данных</span></a> <a href="https://zhub.link/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>python</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> <a href="https://zhub.link/tags/pandas" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pandas</span></a> <a href="https://zhub.link/tags/polars" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>polars</span></a></p>
Habr<p>Что в чёрной коробочке? Выясняем самостоятельно, не привлекая внимания коллег</p><p>Всем привет, меня зовут Миша, и я разрабатываю платформу Яндекс Еды. Первые компоненты были написаны почти 10 лет назад (когда Еда ещё была стартапом Foodfox), и у нас накопилось много кода, который просто хорошо работает, а иногда даже «работает — не трогай». Но в процессе развития и устоявшиеся части системы нужно трогать, про что мои коллеги уже писали — как мы повышали версию PHP , пилили монолит и снимали нагрузку с БД . Наконец настал черёд рассказать про процессинг заказов доставки еды из кафе и ресторанов (а также продуктов из магазинов и многого другого). За годы эволюционного развития он значительно разросся, что стало заметно затруднять дальнейшее развитие — например, изменения, связанные с выходом на новые рынки, — а также влиять на надёжность. Поэтому мы решили вынести процессинг заказа в отдельный специализированный сервис. Чтобы определить, что выносить, а что оставлять, нужно было составить исчерпывающий и актуальный список процессов, которые происходят с заказом. И здесь мы столкнулись с вызовом: это знание распределено по многим людям и документам, поскольку на протяжении долгого времени в процессинг заказов вносили изменения многие команды. И перед нами встал вопрос — как собрать нужную информацию о системе с заметной долей легаси быстро, да так, чтобы информация была актуальна?</p><p><a href="https://habr.com/ru/companies/yandex/articles/921122/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/yandex/a</span><span class="invisible">rticles/921122/</span></a></p><p><a href="https://zhub.link/tags/process_mining" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>process_mining</span></a> <a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>анализ_данных</span></a> <a href="https://zhub.link/tags/tidyverse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tidyverse</span></a> <a href="https://zhub.link/tags/%D1%82%D1%80%D0%B8%D0%B7" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>триз</span></a> <a href="https://zhub.link/tags/%D1%80%D0%B5%D1%84%D0%B0%D0%BA%D1%82%D0%BE%D1%80%D0%B8%D0%BD%D0%B3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>рефакторинг</span></a> <a href="https://zhub.link/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> <a href="https://zhub.link/tags/%D0%B0%D1%80%D1%85%D0%B8%D1%82%D0%B5%D0%BA%D1%82%D1%83%D1%80%D0%B0_%D0%BF%D0%BE" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>архитектура_по</span></a> <a href="https://zhub.link/tags/%D1%8F%D0%BD%D0%B4%D0%B5%D0%BA%D1%81_%D0%B5%D0%B4%D0%B0" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>яндекс_еда</span></a> <a href="https://zhub.link/tags/%D0%BC%D0%BE%D0%BD%D0%BE%D0%BB%D0%B8%D1%82" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>монолит</span></a></p>
Curated Hacker News<p>My Database Is My Application: Rethinking Webhook Logic with DuckDB and SQL</p><p><a href="https://www.hey.earth/posts/duckdb-webhook-gateway" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">hey.earth/posts/duckdb-webhook</span><span class="invisible">-gateway</span></a></p><p><a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
Jesus Castagnetto 🇵🇪<p>"Using <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a> <a href="https://mastodon.social/tags/WASM" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WASM</span></a> + <a href="https://mastodon.social/tags/Cloudflare" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Cloudflare</span></a> <a href="https://mastodon.social/tags/R2" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>R2</span></a> to host and query big <a href="https://mastodon.social/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data</span></a> (for almost free)"</p><p><a href="https://mastodon.social/tags/BigData" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BigData</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a></p><p><a href="https://andrewpwheeler.com/2025/06/29/using-duckdb-wasm-cloudflare-r2-to-host-and-query-big-data-for-almost-free/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">andrewpwheeler.com/2025/06/29/</span><span class="invisible">using-duckdb-wasm-cloudflare-r2-to-host-and-query-big-data-for-almost-free/</span></a></p>
Data Quine<p>Discovering DuckDB Use Cases via GitHub - Petrica Leuca</p><p>"TL;DR: In this post, we use the GitHub API to find repositories that mention DuckDB, then use DuckDB itself to parse and query the results efficiently with SQL."</p><p>Think a lot of projects/organisations would like some of the techniques shown in this post for finding out who else is using their code on GitHub and for what purpose.</p><p><a href="https://duckdb.org/2025/06/27/discovering-w-github" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">duckdb.org/2025/06/27/discover</span><span class="invisible">ing-w-github</span></a></p><p><a href="https://datasci.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://datasci.social/tags/GitHub" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GitHub</span></a> <a href="https://datasci.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a></p>
hrbrmstr 🇺🇦 🇬🇱 🇨🇦<p>Good <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23DuckDB" target="_blank">#DuckDB</a> vibes in today's Drop given all the horrible that happened today and this week in general. — DuckPlot is a useful ObsPlot+DuckDB homunculus — The DuckDB Viz MCP == no SQL req'd interactive dataviz —&nbsp;DuckDB-QuickJS extension adds serious JS powers to DuckDB queries<br><br><a href="https://dailydrop.hrbrmstr.dev/2025/06/27/drop-672-2025-06-27-if-it-walks-like-a/" rel="nofollow noopener" target="_blank">Drop #672 (2025-06-27): If It ...</a></p>
boB Rudis 🇺🇦 🇬🇱 🇨🇦<p>Looks like I shld spend an ~hour or so poring over the <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a> docs, b/c TIL `UNNEST` has optional parameters for making it easier to get a nice, flat table from deeply nested JSON (et al.).</p><p>I'll bet I've missed other hidden gems like that despite having stared at the docs many times.</p>
hrbrmstr 🇺🇦 🇬🇱 🇨🇦<p>Looks like I shld spend an ~hour or so poring over the <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23DuckDB" target="_blank">#DuckDB</a> docs, b/c TIL `UNNEST` has optional parameters for making it easier to get a nice, flat table from deeply nested JSON (et al.). I'll bet I've missed other hidden gems like that despite having stared at the docs many times.</p>
aerique<p>At <span class="h-card" translate="no"><a href="https://mastodon.nl/@joyofcoding" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>joyofcoding</span></a></span>!</p><p>Great talk by Hannes Mühleisen of <a href="https://genart.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a> about tables being a fundamental technology to civilization and not dismissing databases, SQL &amp; ACID just because some implementation are getting old in the tooth.</p><p>DuckDB sounds awesome and I know <span class="h-card" translate="no"><a href="https://mastodon.nl/@bert_hubert" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>bert_hubert</span></a></span> is a big fan.</p><p><a href="https://genart.social/tags/JoyOfCoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>JoyOfCoding</span></a> <a href="https://genart.social/tags/JoyOfCoding2025" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>JoyOfCoding2025</span></a></p>
:rss: DevelopersIO<p>「コカコーラ大好き」と彼は何回言ったのか?WebスクレイピングとDuckDBで集計してみた<br><a href="https://dev.classmethod.jp/articles/scraping-cola-mentions-with-duckdb/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.classmethod.jp/articles/sc</span><span class="invisible">raping-cola-mentions-with-duckdb/</span></a></p><p><a href="https://rss-mstdn.studiofreesia.com/tags/dev_classmethod" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dev_classmethod</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/DevelopersIO" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DevelopersIO</span></a></p>
boB Rudis 🇺🇦 🇬🇱 🇨🇦<p>Drop #669 (2025-06-23): Monday Morning (Barely) Grab&nbsp;Bag</p><p>The Monday Drop discusses 3 main topics: a Rube Goldberg-inspired data pipeline to archive X posts into <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DuckDB</span></a>, the <a href="https://mastodon.social/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RStats</span></a> package {fplot} for automating distribution plot creation in R, and an article from CSS-Tricks on advanced CSS color techniques, detailing color spaces and models for modern web development.</p><p><a href="http://dailydrop.hrbrmstr.dev/2025/06/23/drop-669-2025-06-23-monday-morning-barely-grab-bag/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">http://</span><span class="ellipsis">dailydrop.hrbrmstr.dev/2025/06</span><span class="invisible">/23/drop-669-2025-06-23-monday-morning-barely-grab-bag/</span></a></p>