I dislike Obsidian but I know alot of folks here like and use it. This is some neat #DuckDB functionality for it (and the "AI" detractors can skip the "agentic" stuff altogether — at least I think so on first glance read.)

https://motherduck.com/blog/obsidian-vault-duckdb-ai-agents/

Your Obsidian Vault Can Now Run SQL (and Your Agent Can Read It)

Run DuckDB SQL inside your Obsidian notes and freeze the results as plain markdown tables, local files or MotherDuck cloud data alike. Your vault becomes a local knowledge base your AI agent can read without ever querying the warehouse | Reading time: 6 min read

MotherDuck

Did something change in #DuckDB v1.5.3 in how the import filename works? If you did a `.cd` to the folder with the files and imported files using `READ_CSV ... filename=true` normally you got just the basename - now it seems to be like `.\FILE_DATA_20260602.csv`

🤔

#Database

Gosh I love the creativity of the #DuckDB ecosystem folks.

This DuckDB OpenTelemetry Extension seems pretty spiffy.

https://smithclay.github.io/duckdb-otlp/

DuckDB OpenTelemetry Extension

duckdb-otlp: query OpenTelemetry traces, logs, and metrics with DuckDB.

DuckDB OpenTelemetry Extension

if i can do almost all of that without looking at the cheat-sheet, have i become a Data Analyst already ?

#linux #python #sql #perl #sqlite #duckdb

Duckle is an open-source project created by Sourav Roy. It is currently in public beta at v0.0.12, dual-licensed under MIT and Apache-2.0. https://hackernoon.com/what-the-heck-is-duckle #duckdb
What the Heck is Duckle? | HackerNoon

Duckle is an open-source project created by Sourav Roy. It is currently in public beta at v0.0.12, dual-licensed under MIT and Apache-2.0.

What if you could run analytical queries inside Postgres without an ETL pipeline? At POSETTE 2026, Nitin Jadhav (Microsoft) demos pg_duckdb on Azure Database for PostgreSQL, querying tables & Parquet files from object storage.

Mark your calendar for POSETTE Livestream 4 on Thu 18 Jun

https://posetteconf.com/2026/talks/pg_duckdb-in-action-accelerating-analytics-on-azure-database-for-postgresql/

#PosetteConf #PostgreSQL #Postgres #Database #Community #Microsoft #Azure #DuckDB #Analytics #OpenSource #Parquet

#DuckDB has announced Quack - a new remote protocol over HTTP that enables multiple DuckDB instances to connect to and work with the same database across a network.

Quack brings client-server capabilities to a database that has traditionally been local and embedded.

🔗 Learn more: https://bit.ly/4foyrOp

#InfoQ #AI #DataAnalytics #DistributedData

I've just published a new blog post in my series on #DuckDB. This one explores DuckDB's Vector Similarity Search extension, the Quack protocol and how they can be used together.

Please read, share and let me know if you have any feedback!

https://peterdohertys.website/blog-posts/double-shot-of-duck.html

A Double Shot of DuckDB - peterdohertys.website

Pete Doherty is a NYC based software developer

It's great to be able to find your own post to help you with a new setup! This time #DuckDB #Ruby gem installation on #Windows! You need to do a couple of things so it works.

https://notepad.onghu.com/2025/duck-db-windows-ruby/

#Programming #Database

Using DuckDB on Windows and with Ruby

DuckDB is a fast, open-source database for Online Analytics Processing (OLAP) workloads. It is similar to SQLite3 in the sense that it’s intended to be built directly into a host process and runs within it rather than a separate stand-alone server. Let’s look at setting this up and using it in Windows and also from Ruby.

#Bioinformatics #VEP #DuckDB
I just got the realization that instead of trying to parse in C ensembl VEP's caches (ridiculous idea given the perl serialization format), duckdb has a mysql reader and i can just load this into duckdb the ensembl DB tables i need ! this make the duckvep project much more manageable and mostly sql kernel work now since we already have variant keys and cgranges udfs in the duckhts extension https://github.com/RGenomicsETL/duckhts