HN Explorer

31 comments

[ 3.6 ms ] story [ 80.7 ms ] thread
gberger
Why do I have to complete a captcha to access this website?
netsharc
Same here, today I figured out I'm not human...
dspillett
I've seen some sites suggest they CAPTCHAs will go away if I disable my ad blocker[†], so if not everyone is getting it this could be a factor. Before I bother even clicking to see if I get the CAPTCHA, is the content worth the effort?

[†] I can see how this replaces ad revenue at all, so I assume it is an attempt to make running an ad blocker seem like an inconvenience rather than a benefit.

jontro
I still got the captcha even though I'm running no adblocker
panda17
Sorry, firewall thing -- dependent on recent (geo-ip) threats. Nothing to do with ads -- no ads.
orf
Turn it off.
crtasm
What threat to you are bots viewing your website?
afandian
You don't. Just close the site! I was curious but not that curious...

(edit: it's archived: http://archive.is/H9EYE )

t0mas88
They even dare to tell you to turn off ad blocking to get through the Cloudflare captcha. So much for "making the internet faster"...
[deleted]
(comment deleted)
yamrzou
In addition, I find the new hCaptcha used by Cloudflare much worse than reCAPTCHA. It's slower, with ambiguous inputs demanding more mental effort, and sometimes it just refuses my correct answers.
flotzam
Google probably has a good enough handle on you to serve the easy captchas. But keep in mind that for users they can't fingerprint (e.g. with Tor Browser), reCAPTCHA is usually insanely hard or even blocked ("Your computer or network may be sending automated queries"). hCaptcha has been heavenly compared to that.
bigbubba
'Hard' is not quite the right word for it. reCAPTCHA frequently rejects objectively correct responses when they fail to fingerprint you.
Footkerchief
A Postgres feature I took way too long to discover: exclusion constraints, which is essentially "unique by some function of a column value" instead of "unique by a column value": https://www.postgresql.org/docs/13/ddl-constraints.html#DDL-...
darksaints
You, probably like myself, took way too long to discover them because they have a fairly niche usage and are probably Postgres' least appropriately documented feature. It makes it hard to imagine the ways that it can be used. We should probably do something about that.
ramraj07
I read the second description in the manual and amazed it exists. I can totally see use cases where you want "almost unique" constraints (same name, date of birth too close??)
SPBS
I find the notation compact but confusing. Are Thing and Category essentially tables? What does `thing {T, C}` mean, if T already means Thing?
panda17
A thing is uniquely identified by T, category by C.

May read it as: CREATE TABLE thing (T_ID integer, C_ID integer)

mulmen
Is there further discussion of the "Alternate Key" somewhere? This is a new term to me. Is it like a candidate key?
panda17
In general there can be more than one candidate key for a given relation (table). Only one candidate key is "primary", all others are "alternate".
mulmen
Thanks that makes sense.

Is this an industry term or are you just using it here to emphasize the difference?

dspillett
I've seen alternate used in other places to refer to candidate keys that are not currently the primary key, though I'm fairly sure it isn't a defined standard term.
panda17
Regarding the "industry term", search:

   site:oracle.com "alternate key"

   site:microsoft.com "alternate key"

   site:ibm.com "alternate key"
dspillett
"defined standard" !== "industry term", though I accept your point that it appears to be more common than I was thinking.

IIRC it wasn't introduced to me when learning databases academically which I was assuming to be a standards compliant environment, but that was quite some years ago so I may or may not R C...

marcos100
Industry term. But it is usually unknown to people who tend to use id as primary key for every table.
mulmen
Do you mean synthetic keys rather than natural keys?
kthejoker2
Yes, it is exactly a candidate key as they describe it - simply another field which uniquely identifies rows in the entity.

EDIT: Agree with panda17, they're using it as "candidate keys which were not chosen as primary key."

mongol
What is AK? I know PK and FK but AK has escaped me... at least the acronym...
marcos100
Basically, every time you use UNIQUE in a column or set of columns that is not a PK, it is an AK (Alternate Key).