Show HN: Query Wikidata with DuckDB Instead of Sparql

I wanted to use DuckDB using SQL to query Wikidata locally on my laptop. So I converted Wikidata's N-Triples dump (~8 billion rows) into Parquet files.

The dataset includes the full truth triplets (~60GB) and some pre-extracted datasets for YouTube channels, Letterboxd films, GitHub users and more.

There's also a small website to explore random entities using DuckDB WASM: https://piebro.github.io/wikidata-extraction/random.html

2 points piebro 10 months ago 0 comments

No comments yet

Be the first to share your thoughts.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton