SQL X-to-Y

#1

Post by panda17 » Sun, Nov 01, 2020, 5:34 PM UTC

SQL X-to-Y
damirsystems.com

Re: SQL X-to-Y

#2

Post by gberger » Sun, Nov 01, 2020, 6:22 PM UTC

Why do I have to complete a captcha to access this website?

Re: SQL X-to-Y

#3

Post by netsharc » Sun, Nov 01, 2020, 6:24 PM UTC

gberger wrote: post #2

Why do I have to complete a captcha to access this website?

Same here, today I figured out I'm not human...

Re: SQL X-to-Y

#4

Post by taffer » Sun, Nov 01, 2020, 6:40 PM UTC

SQL Assertions are incidentally the most requested feature for the Oracle database: https://community.oracle.com/tech/apps-infra/discussion/4390...

Re: SQL X-to-Y

#5

Post by dspillett » Sun, Nov 01, 2020, 6:48 PM UTC

gberger wrote: post #2

Why do I have to complete a captcha to access this website?

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.

Re: SQL X-to-Y

#6

Post by panda17 » Sun, Nov 01, 2020, 6:55 PM UTC

gberger wrote: post #2

Why do I have to complete a captcha to access this website?

Sorry, firewall thing -- dependent on recent (geo-ip) threats. Nothing to do with ads -- no ads.

Re: SQL X-to-Y

#7

Post by jontro » Sun, Nov 01, 2020, 6:55 PM UTC

dspillett wrote: post #5

gberger wrote: post #2

Why do I have to complete a captcha to access this website?

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.

I still got the captcha even though I'm running no adblocker

Re: SQL X-to-Y

#8

Post by afandian » Sun, Nov 01, 2020, 7:16 PM UTC

gberger wrote: post #2

Why do I have to complete a captcha to access this website?

You don't. Just close the site! I was curious but not that curious...

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

Re: SQL X-to-Y

#9

Post by orf » Sun, Nov 01, 2020, 7:17 PM UTC

panda17 wrote: post #6

gberger wrote: post #2

Why do I have to complete a captcha to access this website?

Sorry, firewall thing -- dependent on recent (geo-ip) threats. Nothing to do with ads -- no ads.

Turn it off.

Re: SQL X-to-Y

#10

Post by Footkerchief » Sun, Nov 01, 2020, 7:18 PM UTC

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-...