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

41–50 of 62 posts

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

#41

Post by hamandcheese »

dkdcio wrote: post #36
ludicrousdispla wrote: post #34

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…

> MotherDuck is a VC-backed DuckDB SaaS company, not to be confused with DuckDB Labs or the DuckDB foundation

Separate entities, but cooperative/comprised of many overlapping people, right?

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

#42

Post by lolive »

VHRanger wrote: post #22
lolive wrote: post #20

Earlier quoted context omitted.

« 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

So when you start doing crazy joins, a NVMe + big amount of RAM will really help DuckDB, in its work. Right?

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

#43

Post by matsonj »

hamandcheese wrote: post #41
dkdcio wrote: post #36

Earlier quoted context omitted.

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…

> MotherDuck is a VC-backed DuckDB SaaS company, not to be confused with DuckDB Labs or the DuckDB foundation Separate entities, but cooperative/comprised of many overlapping people, right?

Afaik no overlapping people

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

#44

Post by geysersam »

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?

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

#45

Post by cjonas »

caioricciuti wrote: post #28
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...

Curious how tricky it would be to connect this to a local instance of duckdb running in UI mode instead of browser WASM. (Or if that even aligns with your vision of this project). From what I can tell looking just looking at it on my phone your UI seems like a great start to replacing motherduck.

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

#46

Post by cjonas »

cjonas wrote: post #45
caioricciuti wrote: post #28

Earlier quoted context omitted.

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...

Curious how tricky it would be to connect this to a local instance of duckdb running in UI mode instead of browser WASM. (Or if that even aligns with your vision of this project). From what I can tell looking just looking at it on my phone your UI seems like a great start to replacing motherduck.

Or it looks like that's basically already supported?! Sorry, I need to spend some time with this, but I'll definitely be testing it out and will provide feedback and/or contributing

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

#48

Post by matsonj »

RyanHamilton wrote: post #31

If you want a desktop version check out qstudio: https://www.timestored.com/qstudio/help/duckdb-sql-editor it integrates duckdb functionality for parquet csv and to pivot data

You’re underselling this. Running it locally also gives you access to all cores and all RAM. Wasm is very limited comparatively - perf is not even close.

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

#50

Post by matsonj »

curiousgal wrote: post #9
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 am curious is anyone using DuckDB in prod?

Sure - https://motherduck.com/blog/15-companies-duckdb-in-prod/
Post reply on HN