141–144 of 144 posts
The last year of DuckDB enhancements feel like the shift from in-process execution engine (which it is phenomenal at) to an engine that can serve as the foundation of a cloud data warehouse. I know the founders were reticent about not wanting to build that, but I have a feeling it is in the works.
I've been using MotherDuck as a data warehouse for some time now. No regrets.
Earlier quoted context omitted.
Definitely encroaching. Our last product (SaaS observability) uses Clickhouse. Our next product (self-hosted observability) uses DuckDB.
I was building an OpenTelemetry observability platform in a single executable file (in Golang) and was using ClickHouse as the database, and replaced it with an embedded DuckDB, so now it's truly a single executable file platform. https://github.com/adhamsalama/nabatshy
Sometimes I prefer DuckDB query language to MySQL or Postgres. It is not even about performance, it just feels right. I just connect to my DBS from DuckDB just to use its query language. And besides it gives you a single language frontend.
This! For example I tried to ask PosgreSQL to Add support for QUALIFY keyword since it makes window queries much more simpler to use. Postgres didnt want it. DuckDB maintainers are always thinking about the DX and all nice syntactic sugar.