this post was submitted on 29 Nov 2023

1227 points (99.2% liked)

Programmer Humor

19623 readers

2118 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 1 year ago

MODERATORS

Feyter@programming.dev

anzo@programming.dev

BurningTurtle@programming.dev

pylapp@programming.dev

1227

I'll just be a quick 3h (sh.itjust.works)

submitted 11 months ago by CowsLookLikeMaps@sh.itjust.works to c/programmer_humor@programming.dev

70 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] calabast@lemm.ee 19 points 11 months ago* (last edited 11 months ago)

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"