Piggybacking on comments regarding the external hosting:
It's just a matter of time until there will be a paywall in front of this. Hook people on something, then demand money.
The DuckDB Local UI
171–180 of 197 posts
Re: The DuckDB Local UI
#172[dead]
Re: The DuckDB Local UI
#173Earlier quoted context omitted.
None of the UI is OSS as far as I am aware. :/
True; at the moment the UI is not open source. We've talked about releasing the Column Explorer as a standalone component, but haven't been able to prioritize it yet. We'd like to!
It would be wonderful for the community - as it is the best tool in the class.
And foremost - thank you for designing this awesome component!
Re: The DuckDB Local UI
#174I do not know much about DuckDB but it sure looks awesome. Something I haven't found yet is a small swiss army knife for time series type of data: system and network monitoring, sensors and market data. I usually put everything in Prometheus but it is awkward. I would really love to find something I can query intuitively with SQL, have very basic plotting capability, read/parse some log files, can be queried without…
Duckdb cannot plot on its own. You would need to bring in matplotlib or some alternative.
Re: The DuckDB Local UI
#175i’m one of the co-founders at MotherDuck. our team is building the UI in collaboration with the team at DuckDB Labs. this is a first release. we know there are going to be tons of feature requests (including @antman’s request for simple charts). feel free to chime in on this thread and we’ll keep an eye on it! meanwhile, hope you enjoy this release! we had lots of fun building it.
After playing around for a while, a few things come to mind:
* Being able to specify a db at startup would be pretty cool. I'm teaching a class on SQL this summer and I'm already envisioning workflows where a gatekeeper proxy spins up duckdb-ui containers on-demand for users as they log in/out, and it would be much better if the UI can be pre-seeded with an existing database.
* This is maybe a big ask, but markdown cells in notebooks would be nice. Again thinking of my classroom use-case, it would be nice to distribute course materials (lessons/exercises/etc) as notebooks, but that's a bit of a non-starter without markdown or some equivalent content-centric cell type.
* Not a feature request, I just have to say I'm a big fan of how well it handles displaying massive datasets with on-demand streaming and all. I was imagining that I'd have to introduce the `LIMIT` clause right off the bat so that people don't swamp themselves with 100k's of rows, but if I end up using this then maybe I can hold off on that and introduce it at a more natural time.
Regardless, this is great and I definitely have uses for it outside the class I mentioned, so thanks!
Re: The DuckDB Local UI
#176i’m one of the co-founders at MotherDuck. our team is building the UI in collaboration with the team at DuckDB Labs. this is a first release. we know there are going to be tons of feature requests (including @antman’s request for simple charts). feel free to chime in on this thread and we’ll keep an eye on it! meanwhile, hope you enjoy this release! we had lots of fun building it.
The form to get the free e-book doesn't seem to work.
Re: The DuckDB Local UI
#177I do not know much about DuckDB but it sure looks awesome. Something I haven't found yet is a small swiss army knife for time series type of data: system and network monitoring, sensors and market data. I usually put everything in Prometheus but it is awkward. I would really love to find something I can query intuitively with SQL, have very basic plotting capability, read/parse some log files, can be queried without…
You might give QuestDB a try, it supports all the above except native graphing, though it does support Grafana and have a nice query UI. It's lightweight and blazing fast in my experience.
Re: The DuckDB Local UI
#178This is really cool. I use Datagrip almost religiously and ended up adding it as a source there and found it really nice to use.
*EDIT*
One useful thing I thought of with this. If you do a lot of development work on iPad Pro and/or in devcontainers, this could be useful as a UI. I have a bookmarks repository that is just a couple of python scripts and collection of json files. This would be useful to spin up a codespace on GitHub and query the files.
Re: The DuckDB Local UI
#179i’m one of the co-founders at MotherDuck. our team is building the UI in collaboration with the team at DuckDB Labs. this is a first release. we know there are going to be tons of feature requests (including @antman’s request for simple charts). feel free to chime in on this thread and we’ll keep an eye on it! meanwhile, hope you enjoy this release! we had lots of fun building it.
The form to get the free e-book doesn't seem to work.
I just tried it. Worked for me.
Re: The DuckDB Local UI
#180The UI looks quite nice. I am heavily using DBeaver with various different analytical DBs. Right now I am not sure though what the built-in UI offers, which is not in DBeaver...
DBeaver is great and you're probably right. If I was only doing DuckDB work it would be helpful but that is rarely the case for me and DBeaver works better for my use cases.