youtube-notes
https://youtu.be/UkCRM1bTPu0
00:22
all thought gods existed
01:03
every city had own gods, but all believed in the same pantheon
02:02
people tended to dream about gods (like how people in early 20th cent dreamed in B/W)
02:43
some elites thought gods were past kings, or bad stories to convey to children
04:31
many believed that gods were actually demons from the past
05:41
most myths were not taken literally even in ancient greece
https://youtu.be/5RwlFfTF3T0
01:20
what questions are you trying to solve?
02:02
the problems of philosophy by bertrand russell is for non philosophers
03:18
think by simon blackburn - existence of god, self, free will etc
04:05
primary text is important -- hard books to come back to
05:29
complete works of plato - a text that can last your entire life
08:23
confessions by st. augustine - time, God, religion, why we sin. western philosophy and theology did not seperate until recently
09:46
meditations - rene decartes is skepticism and epistemology
i think, therefore i am
11:53
on liberty - john stuart mill -- political philosophy
https://youtu.be/Fv4FU2cI6YA
00:58
chigiri and isagi crushing it around these monsters
02:010
isagi is always the worst on his team lmao
03:25
rin is still number 1 at blue lock!
04:21
absolutely mad animation for these kicks, so violently powerful
06:34
bachira type pass
07:27
didnt this epiphany happen vs team v like episode 11 lol
https://youtu.be/nJ-ehbVQYxI
00:32
now this is pod racing
01:41
i love the dedication to the bit, buy space to fulfill obsession
04:31
d&d actually had the stranger things satan/cult leader vibe. stranger things seems to be pretty accurate!
06:42
multiple generations of story arcs and characters, 1000s of sub plots
08:11
if your character dies, you lose the game permanently
09:15
don't invite your boyfriends to the game because the game lasts longer
such a inspiration for people like me interested in building decades long spanning worlds of thought and ideas -- massive systems that can be cared for and built an entire lifespan!
https://www.youtube.com/watch?v=Td-cmLfQ7uU&ab_channel=TinaHuang
01:40
building a potential and reasonable schema
02:28
--
is a comment in SQL
03:06
FROM
-> JOIN
-> ON
… AND
04:21
line 13: build a function by using SELECT
04:34
COUNT (DISTINCT …)
- joining all iOS and web users by ID
- func
DATE_TRUNC
num_users
= distinct count by 'day'- group the result into
num_users
andday
CREATE TABLE
INSERT INTO
VALUES
(now()), INTERVAL (time)
https://www.youtube.com/watch?v=d2920ysu2hQ&ab_channel=JayFeng
01:37
peepoThink (1)
- we could use
GROUP BY
to see how many posting share the sameuid
- we could then
SELECT WHERE
count == 1
(2) - use
DATE_TRUNC
to group by year or - use WHERE to split each into 180 day intervals from
now()
02:13
visualize the output and work backwards, make an output table, split into intermediate tables to process
05:55
WITH user_job AS (
SELECT u_id, j_id, COUNT(DISTINCT date_posted) AS num_posted
FROM jobs
GROUP BY u_id, j_id
)
08:06
SELECT
SUM(CASE WHEN avg_posted > 1 THEN 1 END) AS posted_multiple
, SUM(CASE WHEN avg_posted = 1 THEN 1 END) AS posted_once
FROM (
SELECT
user_id, AVG(num_posted) AS avg_posted
FROM user_job
GROUP BY user_id
) AS t
10:41
HAVING
won't work because it will filter values
Post Mortem
WITH
- named functionCOUNT(DISTINCT field_name)
- get count of distinct values in fieldGROUP_BY
creates sub tables on different keysCASE WHEN
- ifEND
- end the ifELSE
- elseAVG()
- get average of field
Use intermediate tables to get to the final table
<https://www.youtube.com/watch?v=f1vuGPuug9s&ab_channel=DatabaseStar>
03:02
use the FROM
clause to understand tables in the query
04:60
LEFT JOIN
(only join items into the union from the left table) uses a subquery where we can SELECT
inside and the JOIN
it on a field to the computed table
08:50
any filters? HAVING
is filtering where sum values != 0
14:34
Run the main query in parts
Post Mortem
Notes on "My YouTube Addiction"
YouTube is the perfect evolution of the Peekaboo World Neil Postman warned us about, as it gives the illusion of learning but is often not as effective as reading.
https://youtu.be/p2sQ49Lr8H8
02:45
I empathize. Using YT as a default becomes a toxic, infinite rabbit hole.
03:43
Also empathize. The less projects actively involved in, the easier it is for YouTube to slip in to fill the gaps. YouTube is to mindless consumption as vaping is to tobacco. It feels like learning is happening (albeit less than reading provides 202301130109), but at the end of the day, you'd be hard pressed to explain what information you consumed.
YouTube is the 2023 perfect evolution of the Peekaboo World Neil Postman warned us about.
In a peculiar way, the photograph was the perfect complement to the flood of telegraphic news-from-nowhere that threatened to submerge readers in a sea of facts from unknown places about strangers with unknown faces. For the photograph gave a concrete reality to the strange-sounding datelines, and attached faces to the unknown names. Thus it provided the illusion, at least, that “the news” had a connection to something within one’s sensory experience. It created an apparent context for the “news of the day.” And the “news of the day” created a context for the photograph. But the sense of context created by the partnership of photograph and headline was, of course, entirely illusory. You may get a better sense of what I mean here if you imagine a stranger’s informing you that the illyx is a subspecies of vermiform plant with articulated leaves that flowers biannually on the island of Aldononjes. And if you wonder aloud, “Yes, but what has that to do with anything?” imagine that your informant replies, “But here is a photograph I want you to see,” and hands you a picture labeled Illyx on Aldononjes. “Ah, yes,” you might murmur, “now I see.” (Location 1328)
^af4669
One of my all time favorite quotes, along with 202212291409
AI Generated Read Next
Similar: The Everlasting Grind of Content Creation - 202301240130
Clever: Should I Write a Book? - 202301190216
Chaotic: Feng Shui for WFH - 202301110111