• MercuryGenisus@lemmy.world
    link
    fedilink
    arrow-up
    2
    ·
    edit-2
    1 year ago

    I would reject this pull request. Why is the indenting all over the place? Why is your keyword capitalisation all over the place? WHY YELLOW?!

    Edit: the more I look at this the more it pisses me off. Wtf is going on with your kerning? Just random number and placement of spaces. Also, why is the table name in caps? Who does that? Select * is lazy. Do you really need every field about a girl? Really? Worst of all, not a limited request. I sware this is just the kind of thing that would return 30 million rows and brick the database for twenty seconds.

        • lennivelkant@discuss.tchncs.de
          link
          fedilink
          arrow-up
          1
          ·
          1 year ago

          That’s (part of) why it should be a separate table to map the relation “Relationship”. People can have more than one (polyamory, infidelity), and you could track fields like the start, end, status (e.g. flirting, dating, committed, engaged, married, ended) in there.

    • Black616Angel@discuss.tchncs.de
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      You forgot some: Why is there no space after SELECT?

      Why are boyfriend and smallwaist not questions like is_cute and is_crazy? Either all boils are with a verb or none.

      Also why is smallwaist not in snake case? It should be small_waist (or better yet has_small_waist or even better waist = “small”)

      Also also boyfriend should be null not false, this would solve multiple issues.

      And finally the only positive thing is the * itself, because selecting only body would be even worse. 🤣

    • jqubed@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      I feel confident in assuming the guy who would wear this shirt seeking “girls” between the ages of 18 and 26 is himself no younger than 45.

  • barsquid@lemmy.world
    link
    fedilink
    arrow-up
    1
    ·
    1 year ago

    One of the reasons women will find this repugnant is because they didn’t normalize their tables. Should be boyfriend_id is null.

      • lennivelkant@discuss.tchncs.de
        link
        fedilink
        arrow-up
        1
        ·
        1 year ago

        Good point.

        Should be age > (@my_age / 2) +7

        FTFOP - now my age is some value defined outside the immediate query.

        More likely, the GIRLS would be a view of some table persons and you could query my_age from that table too.

        • fibojoly@sh.itjust.works
          link
          fedilink
          arrow-up
          1
          ·
          edit-2
          1 year ago

          Thank you. I assumed the reader would be educated enough to guess I meant a variable. But yeah, should used @my_age

          • lennivelkant@discuss.tchncs.de
            link
            fedilink
            arrow-up
            1
            ·
            1 year ago

            Pretty sure “People who know enough about SQL to know about variables” is a subset of “People who know enough about SQL to be pedantic about it” :p