The DuckDB Local UI • Hacker News Board

Re: The DuckDB Local UI

#191

Post by dcreater » Sat, Mar 15, 2025, 12:20 AM UTC

xemoka wrote: post #82

xemoka wrote: post #53

Earlier quoted context omitted.

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...

Yes. So confirmation from Jeff Raymakers, a software engineer at MotherDuck, the UI is not open source. > Jeff Raymakers — Today at 9:25 AM > The language in the blog post is misleading, and we're going to correct it. > The UI extension is open source, but the UI itself is not.

I was so excited. I knew it was too good to be true.

Something like this will basically destroy legacy platforms like tableau, sas etc

Re: The DuckDB Local UI

#192

Post by thekevinwang » Sat, Mar 15, 2025, 6:23 PM UTC

This looks very similar to https://hex.tech/. Is there a UI library that is used by the two?

Re: The DuckDB Local UI

#193

Post by enema_bag_jones » Sun, Mar 16, 2025, 12:42 PM UTC

With the UI being loaded from the web, how do we know our sensitive data is not being leaked? looks great, but there's a concern for those of us with confidential data if this now not totally local.

Re: The DuckDB Local UI

#194

Post by enema_bag_jones » Sun, Mar 16, 2025, 5:35 PM UTC

szarnyasg wrote: post #165

msvana wrote: post #164

Hopefully you'll forgive my ignorance, but this is the first time I hear about DuckDB. What space does it occupy in the DBMS landscape? What are its use cases? How does it compare to other DBMS solutions?

Hi, DuckDB devrel here. DuckDB is an analytical SQL database in the form factor of SQLite (i.e., in-process). This quadrant summarizes its space in the landscape: https://blobs.duckdb.org/slides/goto-amsterdam-2024-duckdb-g... It works as a replacement / complementary component to dataframe libraries due to it's speed and (vertical) scalability. It's lightweight and dependency-free, so it also works as part of data p…

Hello, I'd love to use this but I work with highly confidential data. How can we be sure our data isn't leaking with this new UI? What assurances are there on this, and can you comment on the scope of the MotherDuck server interactions?

Re: The DuckDB Local UI

#195

Post by loa_observer » Mon, Mar 17, 2025, 11:07 AM UTC

westurner wrote: post #142

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…

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

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

Re: The DuckDB Local UI

#196

Post by loa_observer » Mon, Mar 17, 2025, 11:12 AM UTC

For further visual EDA, pygwalker provides advanced features for interactive data visualization, which is also built based on duckdb.

src: https://kanaries.net/pygwalker

github: https://github.com/Kanaries/pygwalker

Re: The DuckDB Local UI

#197

Post by labso » Mon, Mar 17, 2025, 6:50 PM UTC

frankc wrote: post #147

memset wrote: post #64

Earlier quoted context omitted.

The actual UI is not open source. (Someone could write an actually open source UI extension for duckdb, but that would require a lot of investment that so far only motherduck has been able to provide.)

I find the SqlLab in apache superset to be very good, and I have duckdb as a data source (anything that supports SqlAlchemy works). It works very well. To be honest, when I first saw the screenshot, I thought it was SqlLab. I haven't actually tried the duckdb ui, though.

That is really interesting. I am thinking of toying with same combination for my small project. Can you share a bit on your use case? Would love to know more.