• 0 Posts
  • 10 Comments
Joined 1 year ago
cake
Cake day: July 10th, 2023

help-circle



  • A view is a saved query that pretends it’s a table. It doesn’t actually store any data. So if you need to query 10 different tables, joining them together and filtering the results specific ways, a view would just be that saved query, so instead of “SELECT * FROM (a big mess of tables)” you can do “SELECT * FROM HandyView”



  • Wasn’t there a study that found if you tell people you’re working on something, you get the same brain reward chemicals as if you actually did it and told everyone? So if you tell people before you’re done, you might just go “meh, I’m good, the rest sounds hard”. Or something like that.




  • calabast@lemm.eetoProgramming@programming.devSQL JOINs
    link
    fedilink
    arrow-up
    8
    ·
    edit-2
    11 months ago

    The author does a good job explaining how join diagrams are more accurate than venn diagrams, but by saying that venn diagrams are bad and wrong, I feel like they completely miss the point. The venn diagrams can be understood almost instantly, whereas the join diagrams take time and thought to take in.

    If someone was brand new to sql joins, sure maybe I would say a join diagram is better for them, so they can really understand what is happening. But for someone who just wants a refresher on join types they rarely use, I think the venn diagrams win. I guess ultimately I don’t like the claim that one type of diagram is simply “better”.