Viewing profile — pophenat

If you can’t code, you’ll be like a mathematician or statistician who can’t do basic math because they have tools that can do it for them. We don’t tell kids they don’t need to kno…

To me placing the join predicates immediately after the tables is more readable as I don’t have to switch between looking at the from and where clauses to figure out the columns on…

If drone armies are vastly more powerful than human armies, the latter become insignificant much like unarmed civilians are irrelevant in a war today. If Ukraine loses its army, it…

I find intriguing their explanation about how to use their FTP service and why it’s not possible to access it with a modern browser. http://www.bom.gov.au/catalogue/anon-ftp-hints.…

The parent comment is about the current operation in the Red Sea, which the Saudi do not participate in. The relevant link is: https://en.m.wikipedia.org/wiki/Houthi_involvement_in…

My understanding is that the Saudi do not participate also because they do not want to be seen as Israel supporters.

"There are a ton of puzzle peaces slowly falling in place left and right." Yet, we do not seem to have a very good understanding of how many pieces there are in the puzzle.

Why obviously? It might as well be a passing fad, and all those uses oof ChatGPT might turn out to be a temporary amusement rather than real and lasting improvement of people's wor…

Microsoft SQL Server now also has IS [NOT] DISTINCT FROM. https://learn.microsoft.com/en-us/sql/t-sql/queries/is-disti...

Well, if you have multiple queries, you'd still have to write the cte multiple times. You could also use views for the same thing, and those are much more reusable.

A small bit of advice from me: consider the weight of the binoculars when buying them. They can be too heavy to hold for more than a minute - especially large ones made for astrono…

While working for one of the largest consultancies, I had to interview an offshore candidate for an onshore position in my team. It was a database development job and I asked the t…

There was this case of a foreign student who submitted a perfectly written paper, obviously copy/pasted from some websites. At the interview, he could not answer any questions prop…

While at university, we had one professor who would assess student assignment papers after conducting an interview. It would take him 5-10 minutes per person and cheaters really di…

Well, actually, people quite often mention pay as a reason to quit on forums like reddit. It isn’t the trigger, but low pay and difficulties coping financially, even with multiple …

It's mostly correct in my experience, but maybe it's because I've learned what it can/can't do. And when it does what it is supposed to do, it can be very useful.