s
Feb. 13, 2024, 5:57 p.m. |

Simon Willison's Weblog simonwillison.net

Announcing DuckDB 0.10.0


Somewhat buried in this announcement: DuckDB has Fixed-Length Arrays now, along with array_cross_product(a1, a2), array_cosine_similarity(a1, a2) and array_inner_product(a1, a2) functions.


This means you can now use DuckDB to find related content (and other tricks) using vector embeddings!


Also notable: "DuckDB can now attach MySQL, Postgres, and SQLite databases in addition to databases stored in its own format. This allows data to be read into DuckDB and moved between these systems in a convenient manner, as attached databases …

announcement arrays databases duckdb embeddings functions mysql postgres postgresql sql sqlite tricks vector vector embeddings

Data Engineer

@ Lemon.io | Remote: Europe, LATAM, Canada, UK, Asia, Oceania

Artificial Intelligence – Bioinformatic Expert

@ University of Texas Medical Branch | Galveston, TX

Lead Developer (AI)

@ Cere Network | San Francisco, US

Research Engineer

@ Allora Labs | Remote

Ecosystem Manager

@ Allora Labs | Remote

Founding AI Engineer, Agents

@ Occam AI | New York