The SQL filter clause: selective aggregates
The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 49,267 posts.
The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.
As you probably knows if you follow my blog, I'm using exclusively a GNU/Linux operating system for my workstation. I produce everything I do with it (webcomic, website, book, freelance, videos, etc...) and all of that since more than ten years now. Along the way, I tried so many existing solution for my…
About a year ago, I cancelled my Netflix subscription. One of the few shows listed on the "plus" side when I made my decision was Stranger Things: an entertaining series with an excellent first and good second season. In short, I'm a fan of the show - though my appreciation of it doesn't come near my fanatical passion…
Marko Elez , a 25-year-old employee at Elon Musk’s Department of Government Efficiency (DOGE), has been granted access to sensitive databases at the U.S. Social Security Administration, the Treasury and Justice departments, and the Department of Homeland Security. So it should fill all Americans with a deep sense of…
There is a terminology problem in the Rails community. Everyone promotes Rails as a MVC framework. I did that as well. However, the truth ...
One of the best things about modern cryptography is the beautiful terminology. You could start any number of punk bands (or Tumblrs) named after cryptography terms like ‘hard-core predicate&#…
This morning, I came accross Cameron Sun’s Probabilistic Tic-Tac-Toe on HN . However, the comments were disappointing, with people proposing probabilistic models, linear programming, minimax algorithms, and heuristic evaluations to develop AI approaches for the game, none of which quite correct. In this post, I’ll…
I had originally shared a version of this post with a small, private mailing list, but then I figured there'd be no harm in sharing it with a larger audience so here it is.
An overview of ray tracing denoising, reviewing filtering, spatiotemporal, sampling and AI techniques to improve convergence and temporal coherency in real time ray traced applications.
Programmable NVIDIA GPUs are very inspiring to hardware geeks, proving that processors with an original, incompatible programming model can become widely used.
When learning a new programming language, there is usually a table in the documentation that shows the various operators that can be used with numbers.
A post by August Lilleaas, published April 20, 2018.
Here’s the country I want to be a citizen of: the one that decides to buy comfort and convenience by deploying courage.
Last Sunday, David Miranda was detained while changing planes at London Heathrow Airport by British authorities for nine hours under a controversial British law—the maximum time allowable without making an arrest. There has been much made of the fact that he’s the partner of Glenn Greenwald, the Guardian reporter whom…
I have a shameful confession to make: I have long neglected an open-source library that I maintain, clj-tagsoup .
A perfect hash function is one that is collision-free. By implication, the hash must be at least as many bytes as the key and the function is theoretically reversible, though not always tractably so. In other words, perfect hashing is a special case of encryption. Because the hash is no smaller than the key, the…
GoDaddy has received a lot of bad press for their support of …
If you are trying to trick somebody with your data, never share the raw data; only share the conclusions. Bonus points if you can’t share the data because it is somehow priviledged or a trade secret. The last thing you want is to allow other people to evaluate your analysis and possibly challenge your conclusions.
For a bit more than a year now, I've been interested in Rust , a programming language by Mozilla research that “runs blazingly fast, prevents nearly all segfaults, and guarantees thread safety.” It is as low-level as C or C++, has a nice type system (with generics and traits), a helpful compiler, and a…
© 2025 Peter N. M. Hansteen Long rumored and eagerly anticipated by some, the fourth edition of The Book of PF is now available for ...
There are many patterns for numbers in passwords, which involve surprising yet intuitive logic.
An expert is a man who has made all the mistakes, which can be made, in a very narrow field. (Niels Bohr) If you unexpectedly find a problem solving itself almost effortlessly, and you can’t quite …
Math fonts from six different type systems, courtesy Chalkdust