• 0 Posts
  • 197 Comments
Joined 2 years ago
cake
Cake day: June 16th, 2023

help-circle


  • It seems that you need to get better. There are plenty of valid complaints against SQL, but your problems seem to be all due to lack of familiarity.

    No variables, no functions; Oh but you can do a CTE

    Yeah, CTEs are more expressive than variables. And as somebody pointed, every database out there supports functions, you may want to look how they work.

    UNION ALL, UNION ALL, UNION ALL… “There’s got to be a better way, surely…”

    What do you mean by a “better way”? Union all is a perfectly valid operation.

    And then you try put a MAX in a where and it won’t let you because you gotta pull all the maxes out in their own query, make a table, join them in, and use them like a filter…

    Window functions exist.










  • marcos@lemmy.worldtolinuxmemes@lemmy.worldmeme
    link
    fedilink
    arrow-up
    2
    arrow-down
    1
    ·
    8 days ago

    Tried Suse and Red Hat before Fedora existed… Also a lot of stuff that isn’t on this graph, and made a system from scratch two times because of strict requirements.

    No plans of moving from Debian. Why TF can one argue that those two are more productive? The only reason to use Fedora in particular is if you are stuck with it due to some hardware or contractual requirement.


  • for example, simply optimize it away

    Yeah, that example makes it reasonable. But the optimizer can do ridiculous stuff when it proves the loop never terminates and also assume it terminates.

    The most famous example of UB bullshit is when some compilers run code that is impossible to reach just because there’s an infinite loop on the file (not even in the same function).