3 ms·
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
by rrgok 1mo ago
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.
- onnimonni 1mo agoThis! 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.
- hans_castorp 1mo agoThe Postgres devs rejected it, because it wasn't part of the standard back then, and apparently work was going on, to include it into the standard. Now that it's included in the standard, there is work to implement it: https://hackorum.dev/topics/51960#message-1125429 https://hackorum.dev/topics/51960#message-1125429
- rrgok 1mo agoOr the fact I can join between Excel, MySQL and Postgres. That absolutely a killer feature.