Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

The DuckDB Local UI

duckdb.org

Post reply on HN
Print view View original

151–160 of 197 posts

Re: The DuckDB Local UI

#151

Post by wodenokoto »

The notebook style of exploring data in a database is absolutely great, but I have yet to find a great implementation of it.

Azure Data Studio can connect to a variety of databases and has completions, but tend to forget if you've set a cell to output a plot. It also doesn't have good functionality for carrying over results from one cell to the next.

Jupyter notebooks don't have any kind of autocompletion against a database (at least to my knowledge), but you do get a lot of control of how you want to store things between cells and display things.

This DuckDB UI looks great, and while DuckDB can read a lot of files, I'm not sure if it has enough connectors to be a general database exploration notebook

Re: The DuckDB Local UI

#152

Post by wodenokoto »

miked98 wrote: post #137
fenghorn wrote: post #131

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.

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://git…

Is there a video of your talk?

Re: The DuckDB Local UI

#153

Post by noisy_boy »

RyanHamilton wrote: post #140

Congratulations on the launch. Looks very cool. If anyone is looking for a local non Web based editor please check out qstudio: https://www.timestored.com/qstudio/help/duckdb-sql-editor

I use studio for kdb, didn't know it can be used with duckdb too.

Re: The DuckDB Local UI

#154

Post by miked98 »

wodenokoto wrote: post #152
miked98 wrote: post #137

Earlier quoted context omitted.

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://git…

Is there a video of your talk?

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.

Re: The DuckDB Local UI

#155

Post by westurner »

westurner wrote: post #150
westurner wrote: post #142

Earlier quoted context omitted.

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

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/emscri…

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

Re: The DuckDB Local UI

#156

Post by articsputnik »

ayhanfuat wrote: post #136
fenghorn wrote: post #131

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.

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

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

Re: The DuckDB Local UI

#157

Post by wodenokoto »

miked98 wrote: post #154
wodenokoto wrote: post #152

Earlier quoted context omitted.

Is there a video of your talk?

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.

Thank you for the additional recommendations!

Re: The DuckDB Local UI

#158

Post by cess11 »

The article says nothing about licensing. Can I put this in front of paying customers without bothering with signing contracts and forwarding cash to someone else?

Re: The DuckDB Local UI

#159

Post by RyanHamilton »

wodenokoto wrote: post #151

The notebook style of exploring data in a database is absolutely great, but I have yet to find a great implementation of it. Azure Data Studio can connect to a variety of databases and has completions, but tend to forget if you've set a cell to output a plot. It also doesn't have good functionality for carrying over results from one cell to the next. Jupyter notebooks don't have any kind of autocompletion against a d…

I also didn't like the existing notebook implementations. I wanted it to run locally, be based on markdown, specialized for just SQL and be easy to store in git. So I wrote one myself: https://www.timestored.com/sqlnotebook/ It ships as part of qstudio and can connect to 30+ databases. If you have any feedback please leave it on github, I only released it a few months ago.

Re: The DuckDB Local UI

#160

Post by [deleted] »

xemoka wrote: post #53
vamega wrote: post #25

This looks pretty great. The UI looked fantastic, and the post mentioned that it was open source. However what's open source appears to be the DuckDB extension, which forwards the requests to a remote URL. I've not been able to find the code for the actual UI. Is the actual UI open source, or is that something MotherDuck is allowing to be used by this while remaining proprietary? Right now it doesn't appear like this…

Yeah, this is really concerning. The handwaving around "keeping the ui up to date" by hosting it on ui.duckdb.org instead of embedding it doesn't taste great to me. At least it's hosted on duckdb.org and not mother duck, but I really would expect to see that source somewhere. Disappointing unless I've missed it. Breadcrumbs in the extension src: https://github.com/duckdb/duckdb-ui/blob/963e0e4d4c6f84b2536...

[deleted]
Post reply on HN