It's a start to something great. Keep it up!
The DuckDB Local UI
21–30 of 197 posts
Re: The DuckDB Local UI
#22This looks great! At risk of harping on a tired topic, have you thought about embedding an AI query generator? For ad-hoc queries like I mostly use DuckDB for I’ve found it’s almost always fastest for me to paste the schema to ChatGPT, tell it what I’ll looking for, then paste the response back into the DuckD CLI, but the whole process isn’t very ergonomic. I think I’m sort of after duckbook.ai, but with access to a…
Thanks for sharing. We haven't cracked the code on doing this locally, but we are working on similar features and functionality in MotherDuck, like the prompt () and embedding () functions. More to come; we're definitely thinking about it!
Re: The DuckDB Local UI
#23Really cool. Could you elaborate a but more on what the 'notebook' form factor entails? Should we expect the same as other notebook environments?
Our notebook form factor is unique compared to other notebook environments - we don't serialize the results. We also have some added bonuses for query profiling and data exploration like the Column Explorer. The easiest way to give it a whirl is to type 'duckdb -ui' in the CLI. Let us know if you have any other questions
is it a jupyter or marimo style notebook or some third thing?
Re: The DuckDB Local UI
#24This is such a needed addition! Huge duckdb fan, congrats team!
I'm a bit out of the loop here, but what's the use case for DuckDB?
for the average developer I think the killer feature is allowing you to query over whatever data you want (csv, json, parquet, even gsheets) as equals, directly from their file form - can even join across them
Re: The DuckDB Local UI
#25This 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 would work without an internet connection.
Re: The DuckDB Local UI
#26This is such a needed addition! Huge duckdb fan, congrats team!
I'm a bit out of the loop here, but what's the use case for DuckDB?
Small intro, It's a relational database for analytical data primarily. It's an "in-process" database meaning you can import certain files at runtime and query them. That's how it differs primarily from regular relational systems.
Re: The DuckDB Local UI
#27I 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.
+1
we're using Perspective in crabwalk[0] (it's like dbt specifically built for duckdb and written in rust) and it's amazing paired with duckdb. Near instant loads for hundreds of thousands of rows and you can keep everything in arrow.
Re: The DuckDB Local UI
#28What is the best method for using the UI with a remote server that only has SSH access? The database is too large to rsync locally and seems risky to start opening ports?
> Support for the UI is implemented in a DuckDB extension. The extension embeds a localhost HTTP server, which serves the UI browser application, and also exposes an API for communication with DuckDB. In this way, the UI leverages the native DuckDB instance from which it was started, enabling full access to your local memory, compute, and file system.
Given the above I'm not sure it supports SSH functionality? Since it exposes an API though there is probably a way to access it, but the easiest solution is probably the one you don't want, which is to open the expected port and just hit it up in a browser. You could open it only to your (office/VPN) IP address, that way at least you're only exposing the port to yourself.
Re: The DuckDB Local UI
#29What is the best method for using the UI with a remote server that only has SSH access? The database is too large to rsync locally and seems risky to start opening ports?
SSH port forwarding?
It looks like the port is configurable, so that should make it easier to avoid conflicts but I wonder how the performance would be impacted.
Re: The DuckDB Local UI
#30What is the best method for using the UI with a remote server that only has SSH access? The database is too large to rsync locally and seems risky to start opening ports?
> Support for the UI is implemented in a DuckDB extension. The extension embeds a localhost HTTP server, which serves the UI browser application, and also exposes an API for communication with DuckDB. In this way, the UI leverages the native DuckDB instance from which it was started, enabling full access to your local memory, compute, and file system. Given the above I'm not sure it supports SSH functionality? Since…
My ip is dynamic so it seems I would need to wrap it in a script that would handle opening and closing. I didn’t see any authentication built into the UI. Seems like a great local tool but harder to get right in production.