yujzgzc

7 ms·

91.
by yujzgzc 2y ago
The main value proposition is that it unnests the code. Constantly moving logic into CTEs is another way to do it but comparatively it feels very clunky after a while. For example to inspect intermediate stages of a raft of CTEs, you end up
92.
by yujzgzc 2y ago
I don't know. Stuff breaks all the time for other more mundane reasons too. I thought you had some inside info about it.
93.
by yujzgzc 2y ago
Is this DOGE's doing?
94.
by yujzgzc 2y ago
This isn't an alternative to it. You can still write ``` SELECT country, COUNT( ) AS num_records FROM t GROUP BY country ``` And then append something like ``` |> EXTEND FLOOR(num_records / 10) 10 AS num_records_bin |> AGG
95.
by yujzgzc 2y ago
> The DeepSeek-R1 model avoids discussing the Tiananmen Square incident due to built-in censorship. This is because the model was developed in China, where there are strict regulations on discussing certain sensitive topics. I believe th
96.
by yujzgzc 2y ago
All I know is that it makes it very hard to solder anything to ground with my cheap underpowered soldering iron
97.
by yujzgzc 2y ago
I guarantee you wouldn't want to use it
98.
by yujzgzc 2y ago
My point is that in most other languages, this kind of functionality can easily be factored into libraries available to the community. SQL doesn't have the composability so every single of these features requires to be added directly i
99.
by yujzgzc 2y ago
There are a lot more composability problems with SQL. As an example, can you write a function that you can invoke on a column in a select statement and will compute the cumulative distribution function of that column? The expression to do t
100.
by yujzgzc 2y ago
I work on a project that does tons of SQL based data transformations (thousands). A lot of it isn't backed by unit tests. Some of our people with more of a C++ background have got the idea that this is crazy, every bit of business logi
101.
by yujzgzc 2y ago
Even in the candidate's own telling, it is obvious that they misread very strong signals from interviewers. I've sometimes been that overly clever programmer and I've had to deal with it too, on the one side it's great t
102.
by yujzgzc 2y ago
It's not that the candidate is underqualified, it's that they demonstrated more hacking skill than programming skill in that interview. I feel like the rules about program length were mistaken for coding golf rules? A small compan