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

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

demo.duckui.com

Post reply on HN
Print view View original

51–60 of 62 posts

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

#51

Post by benrutter »

geysersam wrote: post #44
mritchie712 wrote: post #8

Really excited about the future of DuckDB: 1. DuckLake is the best datalake spec and their team is improving on the extension rapidly. 2. With DuckDB WASM, you can make apps that would normally have 2 to 3 second latency for network calls work in We use it as our built-in datalake at Definite and couldn't be happier with it. 0 - https://ducklake.select/ 1 - https://www.definite.app/blog/ducklake

I love duckdb but I don't understand your second point. How does duckdb wasm decrease the latency of network calls in your app?

Not OP, but depending on your use case, client side operations could be a big deal.

Something like a dashboard app for instance, might have callbacks where it needs to run a new SQL query based on input, but be small enough to make loading all data onto menory and querying locally a mich faster option.

Obviously ymmv and if you have a dashboard with a heavy data set under the hood, your gonna make a lot of users unhappy fast by doing that.

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

#52

Post by jeffbee »

This is not really a problem introduced by the thing in the article, but the "UI" for duckdb just kinda sucks. When I want to interactively explore some data, I want to easily add conditions and aggregates, but there's nothing in the Duck UI that actually does this. It will make a little table of the top 20 values of irritating_column_name but there's not a 1-click way to add `where irritating_column_name = 'incredibly inconvenient value'` to the query and re-run, which is an absolutely basic data exploration feature.

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

#54

Post by adsharma »

mritchie712 wrote: post #8

Really excited about the future of DuckDB: 1. DuckLake is the best datalake spec and their team is improving on the extension rapidly. 2. With DuckDB WASM, you can make apps that would normally have 2 to 3 second latency for network calls work in We use it as our built-in datalake at Definite and couldn't be happier with it. 0 - https://ducklake.select/ 1 - https://www.definite.app/blog/ducklake

Love the DuckLake spec. Now there is something similar for Graphs.

https://adsharma.github.io/graph-archiving/ https://adsharma.github.io/beating-the-CAP-theorem-for-graph...

The catalog is based on the now archived kuzu graph db project. Development continuing here: https://github.com/LadybugDB/ladybug

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

#55

Post by curtisblaine »

CSDude wrote: post #4

There is an embedded one in DuckDB for a while now and it's great. I get the apeal of yours but this one is much easier to use for same cases: https://duckdb.org/2025/03/12/duckdb-ui

Doesn't do charts though (meaning: it does statistic histograms on your columns but no custom chart like OP's software does).

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

#57

Post by mrtimo »

jeffbee wrote: post #52

This is not really a problem introduced by the thing in the article, but the "UI" for duckdb just kinda sucks. When I want to interactively explore some data, I want to easily add conditions and aggregates, but there's nothing in the Duck UI that actually does this. It will make a little table of the top 20 values of irritating_column_name but there's not a 1-click way to add `where irritating_column_name = 'incredib…

Based on this comment, you might enjoy the Malloy data language. It compiles to SQL and also have an open source explorer to make filters like what you are saying easy.

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

#59

Post by jeffbee »

mrtimo wrote: post #57
jeffbee wrote: post #52

This is not really a problem introduced by the thing in the article, but the "UI" for duckdb just kinda sucks. When I want to interactively explore some data, I want to easily add conditions and aggregates, but there's nothing in the Duck UI that actually does this. It will make a little table of the top 20 values of irritating_column_name but there's not a 1-click way to add `where irritating_column_name = 'incredib…

Based on this comment, you might enjoy the Malloy data language. It compiles to SQL and also have an open source explorer to make filters like what you are saying easy.

Thanks for the tip. I am checking it out right now.

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

#60

Post by mritchie712 »

geysersam wrote: post #44
mritchie712 wrote: post #8

Really excited about the future of DuckDB: 1. DuckLake is the best datalake spec and their team is improving on the extension rapidly. 2. With DuckDB WASM, you can make apps that would normally have 2 to 3 second latency for network calls work in We use it as our built-in datalake at Definite and couldn't be happier with it. 0 - https://ducklake.select/ 1 - https://www.definite.app/blog/ducklake

I love duckdb but I don't understand your second point. How does duckdb wasm decrease the latency of network calls in your app?

for many uses cases, you can cache a dataset client side that can be re-queried to avoid network calls
Post reply on HN