Using the mo tool to read the duckdb docs that are in markdown

#TIL about #mo, a handy #CLI #tool (written in #golang) that renders #Markdown in a #browser, and can add documents to a collection/topic. In the screenshot I am reading the #duckdb docs.

More info on mo: github.com/k1LoW/mo

Introducing Dux — Christopher Grainger DuckDB-native dataframes for Elixir, with distributed execution on the BEAM.

Alright! Introducing Dux: distributed #DuckDB backed dataframes for #elixirlang. cigrainger.com/blog/introdu... v0.3 dropped today and with it, distribution is fully supported and Dux is officially outperforming Explorer. I'm excited to hear what you all think.

#Ducktinycc 'C' scripting in #Duckdb via #TinyCC

Of course what better example than the embedded #RStats example from "Writing R extensions".

With a bit more work (and threading issue stuff) this can be extended into some arbitrary R UDFs API for the r-duckdb

Repo: github.com/sounkou-bioi...

#RStats #Rduckhts version 1.1.4-0.0.1 released On CRAN

Besides hts format I/0, some sequence UDFs and a port of BCFtools score, liftover and munge plugins to run using #DuckDB for post-GWAS ops

The R-agnostic #Duckdb community extension update on its way too

A funny thing in the ports, floats !

Open Web Indexes for Remote Querying We propose to redesign the access to Web-scale indexes. Instead of using custom search engine software and hiding access behind an API or a user interface, we store the inverted file in a standard, op...

Our #ECIR2026 paper on "remote querying" Web indexes in Parquet files on S3 using #DuckDB

Paper:
doi.org/10.1007/978-...

Want to try it yourself?

Docs in the #openwebsearch book:
openwebsearcheu-public.pages.it4i.eu/ows-the-book...

Code:
gitlab.science.ru.nl/informagus/r...

Original post on idf.social

Paper:
https://doi.org/10.1007/978-3-032-21289-4_25

Want to try it yourself?

#openwebsearcheu book chapter:
openwebsearcheu-public.pages.it4i.eu/ows-the-book/content/dnt...

Code repository for running remote queries using #DuckDB […]

Gijs Hendriksen presenting our work on "remote querying" to provide access to huge Web resources through de facto standard tech: Parquet files in S3 queried using #DuckDB to facilitate IR research at very acceptable latencies.

Run your ClueWeb experiment in 10 […]

[Original post on idf.social]

Keynote by @djoerd about Web search as a public utility, and of course https://ows.eu

Note the #openwebsearch and #DuckDB stickers on the laptop 😉

Making HNSW actually work with WHERE clauses — Christopher Grainger Transparent filtered vector search in DuckDB, or: why post-filtering is broken and what to do about it.

New blog post as my HNSW #duckdb plugin hits v0.2 with support for quantisation (rabitq) and join+where pushdown and groupby+aggregations. cigrainger.com/blog/duckdb-...

gcs DuckDB Community Extensions DuckDB GCS Extension

🚀 Thrilled to announce that the GCS community extension I contributed to is now available for @duckdb.org 1.5 ! 📦

You can now access Google Cloud Storage files natively—no need for S3 interoperability.
Try it out ! ☁️🦆
#DuckDB #GCP
duckdb.org/community_ex...

Meme showing pixelated aliien with green skin and cybernetic facial implants with purple cape. Text is "ALL YOUR BASE ARE BELONG TO US"

We took over the #MariaDB query planner and turned it into a #Duckdb query planner.

github.com/eriksquires/...

We're not near bug-free but #HolyDuck passes the full TPC-H suite, and has made great performance improvements in mixed-engine joins. #duckdb 's optimizer takes over along with predicate push downs into InnoDB and temp table caching means performance absolutely does not suck. Quote me.

Valentina Release 17.2 Improves Valentina Studio Query Editor, upgraded support for #DuckDB , and #Ruby 4 API integration for Valentina Server. Download free version for Windows, Linux & macOS. bit.ly/4rTFf9c @hannes.muehleisen.org

#HolyDuck has reached a milestone. All 22 TPC-H queries run with the same results regardless of which storage engine holds which table, InnoDb or Duckdb. #duckdb. Perf benchmarks are coming.

#HolyDuck , the #DuckDB in #mariadb adapter, is running through TPC-H queries for functional correctness. It's not all fun and games. Maria rewrites CTEs aggressively when it doesn't have to. 😆

Add hnsw_acorn: filtered HNSW vector search with ACORN-1 by cigrainger · Pull Request #1573 · duckdb/community-extensions Summary Adds the hnsw_acorn extension — a fork of duckdb-vss that adds filtered HNSW vector search using the ACORN-1 algorithm. The upstream vss extension applies WHERE clauses after the HNSW index...

That DuckDB extension I was working on landed in community extensions today! I'm pretty excited about it -- prefiltered ACORN-1 HNSW approx nearest neighbours in #DuckDB. Even pgvector does postfiltering, for example.

INSTALL hnsw_acorn FROM community;
LOAD hnsw_acorn;

github.com/duckdb/commu...

#HolyDuck was accused of being an #AliSQL clone by someone at #MariaDB. Honestly got a pretty snide comment on Linkedin.

It isn't a clone. #DuckDB #RStats

github.com/eriksquires/...

Add hnsw_acorn: filtered HNSW vector search with ACORN-1 by cigrainger · Pull Request #1573 · duckdb/community-extensions Summary Adds the hnsw_acorn extension — a fork of duckdb-vss that adds filtered HNSW vector search using the ACORN-1 algorithm. The upstream vss extension applies WHERE clauses after the HNSW index...

Ever wanted to use HNSW with pre-filtering on #duckdb? I'm trying to make that possible. Approximate nearest neighbours with WHERE clauses, using ACORN. github.com/duckdb/commu...

How to write fast SQL in MariaDB with HolyDuck. #duckdb #rstats

github.com/eriksquires/...

GitHub - eriksquires/holyduck: The divine union between MariaDB and DuckDB The divine union between MariaDB and DuckDB. Contribute to eriksquires/holyduck development by creating an account on GitHub.

#duckdb Announcing HolyDuck. A new revelation for MariaDB users longing for the speed of DuckDB.

github.com/eriksquires/...

Cute yellow rubber duck with jewel like black eyes, a halo, white wings and sparkles.

#duckdb Announcing HolyDuck. A new revelation for MariaDB users longing for the speed of DuckDB.

github.com/eriksquires/...

I'm one of 4 people on earth who would want this, but I am testing a pretty functional #duckdb plugin for MariaDB.

This is duckdb INSIDE MariaDB, peer to InnoDB or MyISAM and an alternative to ColumnStore engine... without all those nasty enterprise reliability features... 😆 #rstats

Because I'm insane.... well, I have a need, but does anyone really NEED a Siberian tiger cub.... I'm building a #duckdb back end for MariaDB. I have one very large table and just the right access patterns. Inserts over night, multiple readers during the day. #Rstats - This will probably fail. 🤣

¡Pruebas brutales con DuckDB! El MacBook Neo (el más barato de Apple) rivaliza con servidores en la nube hasta 4x más RAM en cargas de bases de datos pesadas. En cold runs, ¡hasta 2.8x más rápido que instancias cloud! Big Data en tu mochila 💻🚀 #MacBookNeo #DuckDB #AppleSilicon

Bento | Fancy stream processing made operationally mundane Bento is a stream processor that makes data engineering simple with declarative and unit testable configuration. Connect various sources and sinks with YAML.

So recent #DuckDB supports geometry, recent #Bento supports DuckDB, planets are aligning, to have the best no code tool ever!
warpstreamlabs.github.io/bento/docs/c...

Screenshot from `apt` command running and in standard upgrade step bringing in new duckdb (1.5.0), rstudio (nighly) and R (4.5.3) binaries. Two of these come off personal PPAs.

When one `apt` upgrade run gets you updated #duckdb (1.5.0), #rstudio (nighly) and #r-stats (4.5.3) binaries ...

One command to rule them all.

(First two packages served via informal PPAs I set up, last one is launchpad.net build of updated and uploaded package.)

analytics as code, everything inside github

#vscode #dbt #duckdb #apacheiceberg #wasm #claude djouallah.github.io/analytics-as...

Original post on mstdn.science

🔔🦆 Hear ye! Hear ye!

A new #DuckDB, version 1.5 has been released!
Includes improvements to the command line executable, a new VARIANT type for storing semi-structured data in a column more efficiently than JSON, and incorporation of the GEOMETRY (GIS) type into DuckDB's core.

🔔🦆 Read all […]

‪Valentina Release 17.1 improves Studio #duckDB support for visual Forms , inheritable #reporting parameters and initial support for Ruby integration. New French localization. Get Studio database management for free. bit.ly/46UIMfU

@hannes.muehleisen.org

#Rstats #RSpatial #Duckdb ⬇️⬇️⬇️