4.6 β’ 604 Ratings
ποΈ 16 October 2023
β±οΈ 72 minutes
ποΈ Recording | iTunes | RSS
π§ΎοΈ Download transcript
- pganalyze: https://pganalyze.com/
- Weekly series "5mins of Postgres": https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw
- How Postgres chooses which index to use: https://pganalyze.com/blog/how-postgres-chooses-index
- CMU databases courses: https://db.cs.cmu.edu/courses/
- Postgres community: https://www.postgresql.org/community/
As well as social links:
- Mastodon: https://hachyderm.io/@lukas
- Twitter/X: @pganalyze, @LukasFittl
- GitHub: @pganalyze, @lfittl
- LinkedIn: https://www.linkedin.com/in/lfittl/ , https://www.linkedin.com/company/pganalyze/
β Support this podcast on Patreon βClick on a timestamp to play from that location
0:00.0 | Programming Throwdown, Episode 166, Speedy Database Queries with Lucas Fiddle. |
0:22.7 | Take it away, Patrick. |
0:24.5 | Hey, everyone. Welcome to another episode. |
0:27.1 | Pretty excited about this one. |
0:28.6 | Well, I think I say that every time. |
0:29.9 | It's because it's true every time. |
0:31.5 | Try to bring you guys good content. |
0:33.3 | Today, talking a little bit about some part of databases we haven't talked about. We've had a fair amount of people on to talk about various aspects of database and learned a lot. Today, Lucas is here and he's going to help us understand some a little bit lower level stuff, some some optimization and queries. We had a bunch of good thoughts, even in the pre-recording. I took notes. I don't know how many of we're going to get to. |
0:56.1 | But I'm excited to have Lucas here. |
0:52.5 | Lucas is the founder at PG-Analyze. Welcome to the show, Lucas. Thank you. Thanks for having me. All right. So we normally start off by talking a little bit about how people got into tech. So the question we normally tee up at the beginning is, |
0:56.0 | what was your first sort of like computer programming experience? |
0:56.5 | Like, do you have like a formative moment where you're like, the question we normally tee up at the beginning is what was your first sort of like computer |
1:10.9 | programming experience like do you have like a formative moment where you're like ah yeah that's |
1:15.9 | that's it that's magical yeah good question so how did they get into tech was probably i think it was |
1:22.9 | my dad's laptop which was probably running, Windows 95 or whatever was before that |
1:28.0 | at that point. So I'm in my 30s now for context. And I remember what fascinated me back then. |
1:34.5 | There was this game where you had these apes throwing bananas at each other, and you could program |
1:39.1 | it because it was just written in, I think, a version of Visual Basic or something, or like Basic, |
1:42.8 | I think just at a time. And so I think how I I got into programming, you could argue, is going in and modifying that game, |
1:48.8 | so, you know, the ape would throw a banana a bit stronger, essentially. And so that kind of stuff |
1:54.6 | was, like, fascinating for me early on. And how I think I got actually into serious programming |
2:00.1 | was probably, you know, |
... |
Please login to see the full transcript.
Disclaimer: The podcast and artwork embedded on this page are from Patrick Wheeler and Jason Gauci, and are the property of its owner and not affiliated with or endorsed by Tapesearch.
Generated transcripts are the property of Patrick Wheeler and Jason Gauci and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.
Copyright Β© Tapesearch 2025.