David Beroff (d4b) wrote,
David Beroff

Woof! ... INSERT (human characteristics) ... WHERE NOT EXISTS

As usual, I'm learning from my outsourcing effort, and I came to the realization that we need to replace the INSERT ... ON DUPLICATE KEY UPDATE code with the more appropriate INSERT ... WHERE NOT EXISTS code instead.

Also, I realized today that, in an effort to streamline the process of joining and then using AboutTh.is, Members don't necessarily have to set their primary and additional languages in advance. I wrote some triggers which make the reasonable assumption that the first language the Member uses to express an Opinion is their primary language, and if they use additional Opinion languages after that, those are added to the Member's Fluency set. The Member will be able to configure these later, as well, but the point is that they won't have to.

Of course, even reporting a language at all won't ever be a requirement, (and thus stored internally as und as per ISO 639-3), but it'll sure be rather helpful. :-)

In a related tangent, is the ISO 639-3 generic code zxx (for non-language sounds such as those made by animals) an example of speciesism, i.e., prejudice against non-humans? :-)
Tags: advertising, mtat, outsourcing, webdev

  • (no subject)

    [I was recently asked to introduce my skills to a small, private mastermind. Here's what I wrote.] I see my specialty as being a bridge between…

  • Recent videos...

    A collaborative effort with Adam Fulford for one of his local retail business clients: The Magic Members Quick Setup Guide, currently on their…

  • Even Nigerian Princes Demand the BEST Ghost Writers!

    We all know about the Nigerian Prince scam, but did you know THEY use ghost-writing services, too? Read the whole story here! #ad (A 3-way…

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.