This is a good time to start your own tradition, or continue one that you find worthwhile.

I had to reason with my brain before it would accept it as a triangle. It has 3 sides and 3 corners so...

It's one of those things where it's technically correct but the headline is misleading. When you say "a triangle" without any qualification as the headline does, people are going to interpret that as a good old fashioned triangle. Using the term without clarification that you mean spherical geometry is kind of underhanded writing, imo.

The title attribute of the article is <title>A hyperbolic triangle with three cusps</title>

It's a mild form of clickbait.

I think it's just a normal ages-old pattern for writing headlines that pique people's curiosity. It's super common in popular math in particular, because math is always about generalizing. There's a fine line between that and actual clickbait meant to actively mislead.

"Instead you should:

query WHERE name = ‘abc’

create an indexed UPPER(name) column"

Should there be an "or" between these 2 points, or am I missing something? Why create an UPPER index column and not use it?

[and a third] OR use a case-insensitive collation for the name column.

I think they reversed the 2 expressions. You should use “WHERE UPPER(name) = ‘ABC’” if you want to use the index.