The DuckDB Local UI

Re:The DuckDB Local UI by fenghorn on Wednesday March 12, 2025 @05:27PM (#43347834)

The UI aesthetics look similar to the excellent Rill, also powered by DuckDB: https://www.rilldata.com/

Rill has better built in visualizations and pivot tables and overall a polished product with open-source code in Go/Svelte. But the DuckDB UI has very nice Jupyter notebook-style "cells" for editing SQL queries.

[ Parent | on HN ]

Re:The DuckDB Local UI by miked98 on Wednesday March 12, 2025 @06:28PM (#43348331)

Rill founder here, I have no comment on the UI similarity :) but I would emphasize our vision is building DuckDB-powered metrics layers and exploratory dashboards -- which we presented at DuckCon #6 last month, PDF below [1] -- and less on notebook style UIs like Hex and Jupyter.

Rill is fully open-source under the Apache license. [2]

[1] https://blobs.duckdb.org/events/duckcon6/mike-driscoll-rill-...

[2] https://github.com/rilldata/rill

[ Parent | on HN ]

Re:The DuckDB Local UI by westurner on Wednesday March 12, 2025 @07:58PM (#43348985)

WhatTheDuck does SQL with duckdb-wasm

Pygwalker does open-source descriptive statistics and charts from pandas dataframes: https://github.com/Kanaries/pygwalker

ydata-profiling does open-source Exploratory Data Analysis (EDA) with Pandas and Spark DataFrames and integrates with various apps: https://github.com/ydataai/ydata-profiling #integrations, #use-cases

[ Parent | on HN ]

Re:The DuckDB Local UI by westurner on Thursday March 13, 2025 @12:49AM (#43350490)

xeus-sqlite is a xeus kernel for jupyter and jupyterlite which has Vega visualizations for sql queries: https://github.com/jupyter-xeus/xeus-sqlite

jupyterlite-xeus installs packages specified in an environment.yml from emscripten-forge: https://jupyterlite-xeus.readthedocs.io/en/latest/environmen...

emscripten-forge has xeus-sqlite and pandas and numpy and so on; but not yet duckdb-wasm: https://repo.mamba.pm/emscripten-forge

[ Parent | on HN ]

Re:The DuckDB Local UI by westurner on Thursday March 13, 2025 @01:42AM (#43350663)

duckdb-wasm "Feature Request: emscripten-forge package" https://github.com/duckdb/duckdb-wasm/discussions/1978

[ Parent | on HN ]

Re:The DuckDB Local UI by loa_observer on Monday March 17, 2025 @07:07AM (#43387196)

pygwalker also have a kernel compuataion mode which allows you to use duckdb to handle all queries from pygwalker UI.

[ Parent | on HN ]

Re:The DuckDB Local UI by archon810 on Wednesday March 12, 2025 @11:22PM (#43350109)

I love HN. Random comments about some service out there and replies are like "I am the founder" or "I wrote that".

[ Parent | on HN ]

Re:The DuckDB Local UI by wodenokoto on Thursday March 13, 2025 @12:56AM (#43350517)

Is there a video of your talk?

[ Parent | on HN ]

Re:The DuckDB Local UI by miked98 on Thursday March 13, 2025 @01:36AM (#43350637)

Yes thanks to DuckCon team it’s here:

https://youtu.be/_IqvrFWY7ZM?si=1ux9SGUsh4kDs-ff

Alongside several great talks including Rusty Conover presenting Airport - Arrow + DuckDB — and Christophe Blefari (Bl3f) introducing a new, lightweight orchestrator called yato.

[ Parent | on HN ]

Re:The DuckDB Local UI by wodenokoto on Thursday March 13, 2025 @03:56AM (#43351120)

Thank you for the additional recommendations!

[ Parent | on HN ]

Re:The DuckDB Local UI by ayhanfuat on Wednesday March 12, 2025 @06:21PM (#43348274)

Hamilton Ulmer was involved in both. Back when Twitter was a thing it was really cool to follow his process.

[ Parent | on HN ]

Re:The DuckDB Local UI by articsputnik on Thursday March 13, 2025 @02:58AM (#43350905)

You still can on Bluesky https://bsky.app/profile/hamilton.bsky.social/post/3lk6yxzan...

[ Parent | on HN ]

Re:The DuckDB Local UI by hamilton on Thursday March 13, 2025 @08:17AM (#43352507)

ftr I'm still on X & posting! https://x.com/hamiltonulmer

[ Parent | on HN ]