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

21–30 of 62 posts

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

#21

Post by _ea1k »

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

Agreed. I just wish that the vector support were fully supported. It has been experimental for a long time.

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

#22

Post by VHRanger »

lolive wrote: post #20
dav43 wrote: post #13

Earlier quoted context omitted.

possible, seems this is done in other modes. quote - google ai mode: "DuckDB offers robust capabilities for querying data stored partially on S3, particularly when dealing with Parquet files. This is achieved through several optimization techniques: Predicate Pushdown: When you apply a WHERE clause to filter data, DuckDB can "push down" this filter directly into the Parquet file scan. If the Parquet file contains zon…

« How does it handle [multi-source] joins ? » is the obvious next question.

In memory, and if larger than memory it makes .duckdbtmp files to work from

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

#23

Post by nirav72 »

mrs6969 wrote: post #6
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

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

Anyone know if there is a similar selfhosted/run local option?

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

#25

Post by cjonas »

I just leave 'duckdb --ui' running on my computer at all times. While the functionality is great, I'm really not happy that UI itself isn't open source and instead controlled by motherduck. There are many quick and easy improvements that will probably never get made, as motherduck has no real incentive to improve it at this point.

Wonder if this work could be ported as a replacement to duckdb local UI?

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

#26

Post by jasonjmcghee »

mrs6969 wrote: post #6
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

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

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

#28

Post by caioricciuti »

cjonas wrote: post #25

I just leave 'duckdb --ui' running on my computer at all times. While the functionality is great, I'm really not happy that UI itself isn't open source and instead controlled by motherduck. There are many quick and easy improvements that will probably never get made, as motherduck has no real incentive to improve it at this point. Wonder if this work could be ported as a replacement to duckdb local UI?

I would love for this to be the case... I'm also not a fan of mother's duck ui... Also I created this project like 2 weeks before they launch it (that's why it's named duckui...) I would choose another name but well I had bought the domain already hahaha... But SURE, I would like this to be the best UI ever for all of us... Just need some ideas/help to implement all missing parts...

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

#29

Post by fluxkernel »

mritchie712 wrote: post #18
curiousgal wrote: post #9

Earlier quoted context omitted.

I am curious is anyone using DuckDB in prod?

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

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

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

#30

Post by Rhubarrbb »

nirav72 wrote: post #23
mrs6969 wrote: 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

Anyone know if there is a similar selfhosted/run local option?

`duckdb -ui` and you can launch a local server bound to 127.0.0.1
Post reply on HN