it would be awesome if these worked:
duckdb -ui data.parquet
duckdb -ui data.sqliteThe DuckDB Local UI
81–90 of 197 posts
Re: The DuckDB Local UI
#82This 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...
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.
Re: The DuckDB Local UI
#83The UI looks quite nice. I am heavily using DBeaver with various different analytical DBs. Right now I am not sure though what the built-in UI offers, which is not in DBeaver...
Re: The DuckDB Local UI
#84Earlier quoted context omitted.
Reminiscent of what Deno are doing with their Deno K/V feature, which works in the open source project using SQLite but gets a big upgrade if you use it with Deno Deploy: https://til.simonwillison.net/deno/deno-kv I'm OK with this. Commercial open source projects need a business model. I get why this can be controversial, but the ecosystem needs to find ways to fund future development and I'm willing to compromise on…
https://github.com/denoland/denokv You can self host Deno KV since over a year.
Right, that's mentioned in my article: https://til.simonwillison.net/deno/deno-kv#user-content-upda...
Re: The DuckDB Local UI
#85I really like the columns explorer, https://motherduck.com/blog/introducing-column-explorer/ . Just a few days ago I have been looking for existing column explorers that look like from Kaggle Dataset, but I was not able to find anything. And this one by DuckDB is better!
I have seen a ton of DB GUI clients/ cloud based data tools for analytics purposes and the fact that MotherDuck's column explorer/ column data distribution is hands down the best I know is puzzling me. It seems nobody else besides them cares. Seeing data distribution, unique values, min/ max/ percentiles is so easy and powerful. Really commend whoever came up with that. It's a bit of a shame this metadata cannot be q…
A similar open source column explorer is :
See it's demo:
https://manzt.github.io/quak/?source=https://pub-2fc10ef6724...
Re: The DuckDB Local UI
#86I really like the columns explorer, https://motherduck.com/blog/introducing-column-explorer/ . Just a few days ago I have been looking for existing column explorers that look like from Kaggle Dataset, but I was not able to find anything. And this one by DuckDB is better!
Seems heavily inspired by the column summary of ObservableHQ, but that's nice!
(I designed and built the Column Explorer feature)
Observable's column summary feature is very nice! But I do think there's a very common lineage around these kinds of diagnostics which motivated both Observables and ours. See Jeff Heer's profiler paper[1] for more.
I'm very passionate about this area because I think "first mile problems" are underserved by most tools, but they take the longest to work out.
We had to do some gnarly things[2] to make this feature work well; and there's a lot of room to make it scale nicely and cover all DuckDB data types.
[1] http://vis.stanford.edu/papers/profiler [2] https://motherduck.com/blog/introducing-column-explorer/
Re: The DuckDB Local UI
#87i’m one of the co-founders at MotherDuck. our team is building the UI in collaboration with the team at DuckDB Labs. this is a first release. we know there are going to be tons of feature requests (including @antman’s request for simple charts). feel free to chime in on this thread and we’ll keep an eye on it! meanwhile, hope you enjoy this release! we had lots of fun building it.
Is this feature open source?
Maybe you've already seen, but it appears the answer is no, based on xemoka's comment here quoting someone at duckdb
Re: The DuckDB Local UI
#88i’m one of the co-founders at MotherDuck. our team is building the UI in collaboration with the team at DuckDB Labs. this is a first release. we know there are going to be tons of feature requests (including @antman’s request for simple charts). feel free to chime in on this thread and we’ll keep an eye on it! meanwhile, hope you enjoy this release! we had lots of fun building it.
Y'all at MotherDuck are doing such a great job that I encourage you to not try and muddle the open/closed source divide, at least not this early in the startup lifecycle. Having a local MotherDuck interface is awesome, and doesn't gain much by being 'open source'. Wait to cash out on the community good will when the rewards are higher.
Re: The DuckDB Local UI
#89Earlier quoted context omitted.
Do you know if there is any open source TypeScript component that can be used in a project?
None of the UI is OSS as far as I am aware. :/
True; at the moment the UI is not open source. We've talked about releasing the Column Explorer as a standalone component, but haven't been able to prioritize it yet. We'd like to!
Re: The DuckDB Local UI
#90I suggest https://perspective.finos.org/ for data viz to be built in. We use DuckDB paired with Perspective for client-side BI use case, and it's been great.
The online demo looks great and promising, too bad it's unusable for me. I've tried installing it with conda from conda-forge and no luck. I've tried installing it with pip, the same. I've also cloned the repository from github, tried to build it and failed, but I don't remember the details. Why is some software so difficult to install beats me.
Have you ever reported an issue? I use perspective heavily on a variety of platforms both conda and pypi without any problems.