Live data from Hacker News

Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

demo.duckui.com

31–40 of 62 posts

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#32

I'd love to make it work with flightsql or HTTP endpoints returning arrow IPC [0]! Did you consider using perspective for last-mile charting [1]? Building your own seems like a huge chunk of work. Well done! [0] https://duckdb.org/docs/stable/clients/wasm/data_ingestion#a... [1] https://github.com/finos/perspective

Perspective is also getting direct support for DuckDB soon! https://github.com/finos/perspective/pull/3062

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#33
Is the DuckDB Wasm that you are providing the same thing as the DuckDB Wasm provided by DuckDB?

I ask because I am under the impression that the 'DuckDB Wasm' client provided by DuckDB doesn't yet support all of the DuckDB functions.

So I am interested to know if this has implemented more, fewer, or the same set of functions.

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#34
post #6

Earlier quoted context omitted.

This is not a self hosted one though. You can not use default ui offline, you can not guarantee data safety

It's very weird they don't offer it by default, but there are workarounds. (You can use it offline) https://github.com/duckdb/duckdb-ui/issues/62

some of the comments on that thread are surprising. Are people not aware that software can be bundled in such a way as to run on machines not having internet access?

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#36

Earlier quoted context omitted.

It's very weird they don't offer it by default, but there are workarounds. (You can use it offline) https://github.com/duckdb/duckdb-ui/issues/62

some of the comments on that thread are surprising. Are people not aware that software can be bundled in such a way as to run on machines not having internet access?

the background is this UI is the MotherDuck UI for their cloud SaaS app. MotherDuck is a VC-backed DuckDB SaaS company, not to be confused with DuckDB Labs or the DuckDB foundation

MotherDuck decided to take their web app UI and make it a locally usable extension via DuckDB. however as noted in that thread, the architecture is a bit odd as the actual page loads once the extension is running from MotherDuck’s servers (hence the online requirement)

I don’t think it’s intentionally malicious or bad design or anything, just how this extension came about (and sounds like they’re fixing it)

disclaimer: I do know and actively work with the MotherDuck folks, I’ve also worked w/ DuckDB Labs in the past

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#37
post #36

Earlier quoted context omitted.

some of the comments on that thread are surprising. Are people not aware that software can be bundled in such a way as to run on machines not having internet access?

the background is this UI is the MotherDuck UI for their cloud SaaS app. MotherDuck is a VC-backed DuckDB SaaS company, not to be confused with DuckDB Labs or the DuckDB foundation MotherDuck decided to take their web app UI and make it a locally usable extension via DuckDB. however as noted in that thread, the architecture is a bit odd as the actual page loads once the extension is running from MotherDuck’s servers…

Thanks, any recommendations on where to find the best information reference/resource for DuckDB-Wasm?

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#38

Earlier quoted context omitted.

Yes, we run DuckDB + DuckLake in prod for https://www.definite.app/

Is DuckLake compatible with Iceberg? I remember they create a new catalog.

Yes, you can use

INSTALL iceberg;

to start working with iceberg https://duckdb.org/docs/stable/core_extensions/iceberg/overv...

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#39
Here's some quick issues and suggestions I found after about 5 minutes of playing around with it. All test were done using Firefox FYI.

1. One of my favorite features from the built in DuckDB UI is the panel that automatically generates graphs for each column, both for the whole dataset itself and for the specific query you're running. I often find myself not even writing any queries because all I needed was something really simple already available in that panel. This would be my #1 reason for not using this GUI instead of the built in one.

2. I could not find any panel to show the currently selected value in the grid view. Ideally I would like this to also be able to auto-detect common formats like JSON and format them, etc.

3. The grid view can show a maximum of 200 rows. Finding a way to virtually render the rows in an infinite list would be much better IMO. I've found myself selecting up to 10k+ rows in the built in GUI and to copy all IDs, etc, several times (saves sometime compared to exporting a CSV and copying from there).

4. The column filter dropdown in the grid view has a search bar which is nice, but it is automatically deselected on each character entry, making it very annoying to use...

5. Additionally the dropdown filter menus are not automatically closed when you click outside or open another dropdown, which is a minor annoyance.

6. The right click menu in the grid viewer will close on "mouse out", however it does not close on "click outside" and the cursor does not start inside of the menu itself. This means the menu becomes permanently stuck until hover over it if you immediately move the mouse to the top-right on open.

7. The grid view resizer is behaving buggy sometimes after changing the number of page rows to display.

8. The transparent tooltip background in the chart viewer makes the light-gray text impossible to read in dark-mode when there is yellow behind it (from other the chart bars).

9. The explorer side panel seems to be sized based on a percentage of the window size. this is quite minor but it would behave nicer if it had a fixed size so changing the window size does not also resize the side panel. It is also overly large when you first load the site.

Re: Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

#40
post #39

Here's some quick issues and suggestions I found after about 5 minutes of playing around with it. All test were done using Firefox FYI. 1. One of my favorite features from the built in DuckDB UI is the panel that automatically generates graphs for each column, both for the whole dataset itself and for the specific query you're running. I often find myself not even writing any queries because all I needed was somethin…

THAT'S AMAZING! ALL NOTED, thank you very much for the time and for the feedback! You are awesome! I'll review all!
Post reply on HN