bolha.us

4 posts4 participants2 posts today

Jesus Castagnetto 🇵🇪<a href="https://mastodon.social/tags/TIL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TIL</a> about a <a href="https://mastodon.social/tags/CLI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CLI</a> <a href="https://mastodon.social/tags/Ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Ruby</a> tool to do <a href="https://mastodon.social/tags/dataviz" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dataviz</a> in the <a href="https://mastodon.social/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#terminal</a>: Youplot -- <a href="https://github.com/red-data-tools/YouPlot" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/red-data-tools/YouPlot</a>Found it while reading the <a href="https://mastodon.social/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> documentation (<a href="https://duckdb.org/docs/stable/guides/data_viewers/youplot" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/docs/stable/guides/data_viewers/youplot</a>)

Johnny Graber<a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> Friday #273: Query Excel Files With <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a><a href="https://pythonfriday.dev/2025/04/273-query-excel-files-with-duckdb/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://pythonfriday.dev/2025/04/273-query-excel-files-with-duckdb/</a>

Data QuineThanks to a live Data Camp session I found out that there are helper aggregate functions for linear regression in SQL in DuckDBe.g. regr_slope() regr_intercept()<a href="https://duckdb.org/docs/stable/sql/functions/aggregates.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/docs/stable/sql/functions/aggregates.html</a><a href="https://datasci.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://datasci.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a>

Esk 🐌⚡💜howdy, <a href="https://hachyderm.io/tags/hachyderm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hachyderm</a>!over the last week or so, we've been preparing to move hachy's <a href="https://hachyderm.io/tags/DNS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DNS</a> zones from <a href="https://hachyderm.io/tags/AWS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AWS</a> route 53 to bunny DNS.since this could be a pretty scary thing -- going from one geo-DNS provider to another -- we want to make sure *before* we move that records are resolving in a reasonable way across the globe.to help us to do this, we've started a small, lightweight tool that we can deploy to a provider like bunny's magic containers to quickly get DNS resolution info from multiple geographic regions quickly. we then write this data to a backend S3 bucket, at which point we can use a tool like <a href="https://hachyderm.io/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> to analyze the results and find records we need to tweak to improve performance. all *before* we make the change.then, after we've flipped the switch and while DNS is propagating -- :blobfoxscared: -- we can watch in real-time as different servers begin flipping over to the new provider.we named the tool hachyboop and it's available publicly --> <a href="https://github.com/hachyderm/hachyboop" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/hachyderm/hachyboop</a>please keep in mind that it's early in the booper's life, and there's a lot we can do, including cleaning up my hacky code. :blobfoxlaughsweat: attached is an example of a quick run across 17 regions for a few minutes. the data is spread across multiple files but duckdb makes it quite easy for us to query everything like it's one table.<a href="https://hachyderm.io/tags/sre" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sre</a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://hachyderm.io/tags/mastodon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mastodon</a> <a href="https://hachyderm.io/tags/infrastructure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#infrastructure</a>

James C :python:In the end, I round-tripped it through DuckDB. I've always loved their super simple table output - nice type information on each column too.This gave me the vertical division I needed between those datestamps. 😅 <a href="https://a2mi.social/@samfirke" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@samfirke</a> <a href="https://mastodon.social/@hugovk" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@hugovk</a> <a href="https://fosstodon.org/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a>

Tatu LeppämäkiThank you to <a href="https://mstdn.social/tags/Kone" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Kone</a> & Mai and Tor Nessling Foundations for supporting this work. A quantitative work like this would not be possible without a robust suite of FOSS tools. My thanks to the maintainers of <a href="https://mstdn.social/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#QGIS</a>, <a href="https://mstdn.social/tags/pandas" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pandas</a>, <a href="https://mstdn.social/tags/geopandas" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#geopandas</a>, <a href="https://mstdn.social/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a>, <a href="https://mstdn.social/tags/dask" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dask</a>, <a href="https://mstdn.social/tags/statsmodels" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#statsmodels</a>, <a href="https://mstdn.social/tags/jupyter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#jupyter</a> and many more!

Johnny Graber<a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> Friday #272: Extensions for <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a><a href="https://pythonfriday.dev/2025/03/272-extensions-for-duckdb/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://pythonfriday.dev/2025/03/272-extensions-for-duckdb/</a>

Johnny Graber<a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> Friday #271: Querying Data With <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a><a href="https://pythonfriday.dev/2025/03/271-querying-data-with-duckdb/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://pythonfriday.dev/2025/03/271-querying-data-with-duckdb/</a>

Ben Companjen 🟥I should have looked at <a href="https://code4lib.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> before, but with the built-in UI with notebooks (<a href="https://duckdb.org/2025/03/12/duckdb-ui.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/2025/03/12/duckdb-ui.html</a>) it feels really slick. So note to self: refresh your <a href="https://code4lib.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> !

Curated Hacker NewsShow HN: GizmoSQL – Run DuckDB as a Server with Arrow Flight SQL<a href="https://github.com/gizmodata/gizmosql-public/blob/main/README.md" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/gizmodata/gizmosql-public/blob/main/README.md</a><a href="https://mastodon.social/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> <a href="https://mastodon.social/tags/github" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#github</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a>

Hacker NewsPreview: Amazon S3 Tables and Lakehouse in DuckDB<a href="https://duckdb.org/2025/03/14/preview-amazon-s3-tables.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/2025/03/14/preview-amazon-s3-tables.html</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/Amazon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Amazon</a> <a href="https://mastodon.social/tags/S3" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#S3</a> <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> <a href="https://mastodon.social/tags/Lakehouse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Lakehouse</a> <a href="https://mastodon.social/tags/DataAnalytics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataAnalytics</a> <a href="https://mastodon.social/tags/CloudComputing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CloudComputing</a> <a href="https://mastodon.social/tags/BigData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#BigData</a>

Alex G RiceIn Geodata Ramblings blog, a new post: GIS command-line "gems" for Linux and macOS. Let me know of any other good ones which I should have listed.<a href="https://mapstodon.space/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#linux</a> <a href="https://mapstodon.space/tags/gdal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#gdal</a> <a href="https://mapstodon.space/tags/ogr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ogr</a> <a href="https://mapstodon.space/tags/cng" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cng</a> <a href="https://mapstodon.space/tags/CNG2025" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CNG2025</a> <a href="https://mapstodon.space/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> <a href="https://mapstodon.space/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a> <a href="https://mapstodon.space/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgis</a> <a href="https://mapstodon.space/tags/gis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#gis</a> <a href="https://ricegeo.dev/gis-cli-gems/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ricegeo.dev/gis-cli-gems/</a>

Thomas AdamI've been playing around with <a href="https://bsd.network/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> and this fits perfectly.Hence I'm now working on porting this over to <a href="https://bsd.network/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> as a result.I'm trying to do all of this in <a href="https://bsd.network/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> as much as I can to minimise any post-processing.I've also decided to switch the current page to a <a href="https://bsd.network/tags/hugo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hugo</a> rendered page as wel. I think <a href="https://bsd.network/tags/hugo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hugo</a> has matured to the point where it supports this use case.At the moment this effort is solo (myself). If anyone wishes to help, please get in touch..l I don't bite! :)

Mohit Sindhwani$ duckdb -version v1.2.1 8e52ec4395Ok, <a href="https://ruby.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> updated - it's time to try the UI! <a href="https://duckdb.org/2025/03/12/duckdb-ui" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/2025/03/12/duckdb-ui</a><a href="https://ruby.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a>

hrbrmstr 🇺🇦 🇬🇱W00T In <a class="hashtag" href="https://bsky.app/search?q=%23DuckDB" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> 1.2.1 you can just do: ```bash $ duckdb -ui ``` to get this !

Michael SimonsWow.<a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> just got a built-in <a href="https://mastodon.social/tags/UI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UI</a> since 1.2.1.In the screenshot, I am running it on my photovoltaics database. Because I have all interesting reports written as views, I now have a thing that I just can give out to non-programmers that can do cool stuff with it.Well done, <a href="https://discuss.systems/@hannes" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@hannes</a> and team at <a href="https://data-folks.masto.host/@motherduck" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@motherduck</a> <3Update: Read their blog - <a href="https://duckdb.org/2025/03/12/duckdb-ui" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/2025/03/12/duckdb-ui</a>

Hacker NewsThe DuckDB Local UI<a href="https://duckdb.org/2025/03/12/duckdb-ui.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://duckdb.org/2025/03/12/duckdb-ui.html</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> <a href="https://mastodon.social/tags/Local" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Local</a> <a href="https://mastodon.social/tags/UI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UI</a> <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> <a href="https://mastodon.social/tags/Data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Data</a> <a href="https://mastodon.social/tags/Analytics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Analytics</a> <a href="https://mastodon.social/tags/Open" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Open</a> <a href="https://mastodon.social/tags/Source" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Source</a> <a href="https://mastodon.social/tags/UI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UI</a> <a href="https://mastodon.social/tags/Tools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Tools</a> <a href="https://mastodon.social/tags/Data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Data</a> <a href="https://mastodon.social/tags/Science" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Science</a>

💧🌏 Greg CocksSatellite Imagery You Can Play With -- <a href="https://hackaday.com/2025/03/10/satellite-imagery-you-can-play-with/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://hackaday.com/2025/03/10/satellite-imagery-you-can-play-with/</a> <-- shared technical article -- <a href="https://tech.marksblogg.com/satellogic-open-data-feed.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://tech.marksblogg.com/satellogic-open-data-feed.html</a> <-- shared ‘how to’ article -- [this post should not be considered an endorsement of any product or service] <a href="https://techhub.social/tags/GIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GIS</a> <a href="https://techhub.social/tags/spatial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spatial</a> <a href="https://techhub.social/tags/mapping" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mapping</a> <a href="https://techhub.social/tags/Satellogic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Satellogic</a> <a href="https://techhub.social/tags/EarthView" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EarthView</a> <a href="https://techhub.social/tags/satellite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#satellite</a> <a href="https://techhub.social/tags/cubesat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cubesat</a> <a href="https://techhub.social/tags/NewSat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NewSat</a> <a href="https://techhub.social/tags/microsatellites" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#microsatellites</a> <a href="https://techhub.social/tags/GDAL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GDAL</a> <a href="https://techhub.social/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a> <a href="https://techhub.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a> <a href="https://techhub.social/tags/H3" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#H3</a> <a href="https://techhub.social/tags/JSON" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#JSON</a> <a href="https://techhub.social/tags/Lindel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Lindel</a> <a href="https://techhub.social/tags/Parquet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Parquet</a> <a href="https://techhub.social/tags/remotesensing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#remotesensing</a> <a href="https://techhub.social/tags/earthobservation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#earthobservation</a> <a href="https://techhub.social/tags/Aleph" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Aleph</a> <a href="https://techhub.social/tags/NORAD" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NORAD</a> <a href="https://techhub.social/tags/location" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#location</a> <a href="https://techhub.social/tags/howto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#howto</a> <a href="https://techhub.social/tags/tutorial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tutorial</a> <a href="https://techhub.social/tags/code" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#code</a> <a href="https://techhub.social/tags/coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#coding</a> <a href="https://techhub.social/tags/metadata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#metadata</a> <a href="https://techhub.social/tags/imagery" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#imagery</a>

Eric R. ScottThere are now so many "backends" for {dplyr}—duckdb with {duckplyr}, polars with {tidypolars}, various database engines with {dbplyr}, {data.table} with {dtplyr}. Is there a blog post or flow chart somewhere with pros and cons of each? Like, comparisons of memory requirements, speed, and how likely they are to "just work"?<a href="https://fosstodon.org/tags/rstats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rstats</a> <a href="https://fosstodon.org/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#duckdb</a> <a href="https://fosstodon.org/tags/dplyr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dplyr</a> <a href="https://fosstodon.org/tags/tidyverse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tidyverse</a> <a href="https://fosstodon.org/tags/polars" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#polars</a>

Johnny Graber<a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> Friday #269: Introducing <a href="https://mastodon.social/tags/DuckDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DuckDB</a><a href="https://pythonfriday.dev/2025/03/269-introducing-duckdb/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://pythonfriday.dev/2025/03/269-introducing-duckdb/</a>

Recent searches

Search options

Administered by:

Server stats:

#duckdb