Transcript #60: Don't dismiss SQLite as just a starter DB

00:00 Hello and welcome to Python Bytes, where we deliver Python news and headlines directly to your earbuds.

00:05 This is episode 60, recorded January 10th, 2018.

00:09 I'm Michael Kennedy.

00:10 And I'm Brian Okken.

00:11 And we've got a bunch of stuff lined up for you, as always.

00:14 Before we get to it, I want to say thank you to Datadog.

00:16 Datadog is sponsoring the show at pythonbytes.fm/datadog.

00:19 More to say about that later.

00:21 Brian, I want to know who's at nine.

00:23 Who's at nine?

00:24 Yes, who is at nine?

00:25 Wouldn't it be awesome if you could actually just utter this question into the air and have it automatically answered for you?

00:32 Yeah, well, that's the promise of Alexa and Google Home and all these home assistants, right?

00:37 That's right.

00:37 This came up, what was it?

00:39 Episode 33 of Python Bytes, actually.

00:42 We talked about you brought up building an Alexa skill.

00:45 And then somebody saw that.

00:47 And we have a link to a Twitter thread.

00:49 Yeah, it was Greg Quinlan who posted that on Twitter.

00:53 That's cool.

00:53 Okay, well, he ran with it.

00:55 And he looked into programming both skills for Alexa and Google Home.

01:00 And he came up with this who's at nine video that we have a link to.

01:05 And it's just, I think it's hilarious.

01:07 It's basically the old who's on first routine, but done with an Alexa and a Google Home together.

01:15 It's funny.

01:17 Yeah, so he's got like a little dot and a Google Home.

01:21 And he activates them both and they talk to each other, right?

01:23 It cracked me up.

01:25 It's good.

01:25 We should have like had a clip for it or something for the show.

01:29 Yeah, we should just play it.

01:30 Yeah, that'd be fun.

01:31 One of the things that strikes me, first of all, nice work, Greg.

01:34 That's awesome.

01:35 Flask Ask is really pretty interesting to work with.

01:38 And the Flask Assistant is the Google Assistant equivalent of Flask Ask.

01:42 It's like just ported to that API.

01:44 But what's really interesting to me is the API here effectively is Flask.

01:49 And I'm noticing this in lots and lots of places.

01:52 Like someone just sent us something that was almost a web API for the command line.

01:56 But I'm noticing Flask being like the de facto API for so many things these days.

02:01 Yeah, it must just be that people are just having it's easier to set up a Flask, a small Flask application for something.

02:10 I guess.

02:11 I mean, pay attention to number four on our picks as well.

02:14 We'll come back to this.

02:15 There's something coming up related to the Who's at Nine that's on Talk Python, right?

02:20 Yeah.

02:20 So I have three guys, a panel discussion, who are all involved in building Echo Assistant type things.

02:29 Some of the people behind Flask Ask and some of the people behind Flask Assistant.

02:32 Those are sometimes the same people on Talk Python this week.

02:38 So it should come out just about the same time this episode comes out, which is pretty awesome.

02:42 So if you really like this and you want to dig into it, check out talkpython.fm/146.

02:47 There should be a whole lot there.

02:48 That's cool.

02:49 Yeah.

02:49 I'll check that out.

02:50 Sounds good.

02:50 Yeah.

02:51 So I came across an article that I think it's pretty interesting because you and I have been

02:58 singing the praises of Python, how it's really, really popular.

03:01 It's becoming quite the important language in so many ways, right?

03:06 We talked about the incredible growth of Python, things like that.

03:09 But I guess this struck a chord with me because I feel like one of the places where Python really

03:15 falls down is this sort of the intersection of packaging for delivering an application to

03:22 non-developers or non-servers or packaging, and especially in that area around UIs, like

03:29 native UIs.

03:30 Yeah, definitely.

03:31 We don't have that really.

03:33 It's not as obvious what to do.

03:35 It's not obvious.

03:36 There's a few like half solutions.

03:38 They sometimes work, except for when they don't.

03:40 And, you know, it's the thing that I ran across that made me sort of bring this up again.

03:46 And it's not that I think Python completely sucks because it doesn't have it.

03:50 Obviously, I don't think that.

03:51 But I see it as a major weakness.

03:53 And if we could solve this challenge, I feel like it would just make Python even stronger

03:59 and reach even deeper into like big enterprises that have to have desktop UIs and things like

04:05 that.

04:05 So the article I found is called Retiring Python as a Teaching Language.

04:10 So this is by James Higg.

04:12 And basically he said, for the last 10 years, my advice for someone getting started programming

04:17 is to say, guys, start with Python.

04:19 That's awesome.

04:20 But then he wrote this article to say, actually, that's not my belief anymore.

04:24 That's kind of sad, right?

04:26 It is.

04:27 And it seems, okay, so his big beef really is part of this not being able to do the user

04:33 interfaces like desktop applications easily with it.

04:37 Yeah, absolutely.

04:37 And mobile as well.

04:38 I mean, these kind of are sort of cousins.

04:41 It says, it's all great.

04:42 People work with Python when they're getting started and so on.

04:45 But then one day the student will innocently ask, instead of running a poker simulator on

04:50 the command line, can I just put it on a window with like a button and some cards?

04:53 Yeah.

04:54 Okay.

04:55 So what do you do then, right?

04:56 Yeah.

04:56 Well, there's TK Enter, but I don't know.

04:59 That looks like it's from the early 90s, late 80s.

05:03 It definitely doesn't look fresh and exciting like modern applications do.

05:07 We have Pygame, but that's only if you want a game, right?

05:11 What if I want like an app that I want to...

05:14 So suppose I work at like, say, a stock trading place and I want an app that is like across

05:20 three monitors and it's showing me the status of all my trades running real time, maybe like

05:26 a web socket back to some server as fast as it can be to like completely show the traders

05:31 what's going on.

05:32 Like, what's the answer for Python there?

05:34 Yeah.

05:34 Well, I don't want to diss Pygame too much because I know some people have done some

05:38 non-game things with it, but I don't really have an answer to that either.

05:42 I think that's a big shortcoming.

05:43 And if we had a really good answers for that, like some of the other frameworks, like even

05:47 JavaScript has really good answers for that, which is kind of bizarre, but like Visual Studio

05:53 Code, Atom, those are all Node.js plus JavaScript front-end apps, right?

05:58 That's Electron.js.

05:59 I would like to see a modern sort of thing for Python.

06:03 And I think this is just worth considering.

06:06 You know, actually the Twitter thread that we'll link to the Twitter thread, it's pretty

06:11 interesting.

06:12 If you open up my initial sort of tweet, I don't know if you want to call it a complaint or

06:16 warning to the community, but if you open that, you can scroll down and you can see all the

06:20 conversations.

06:21 And even Guido gets in there a little bit to talk about some of the history, which is pretty

06:25 interesting.

06:25 And thanks for that.

06:26 So I think it's, you know, I just, I don't know that there's a great answer right now,

06:30 but I'm trying to inspire people.

06:32 I want to play devil's advocate here though, a little bit.

06:35 I know that you've said that you have written a lot of desktop applications, but to be honest,

06:40 I have not.

06:40 I've written a couple little tiny things that I've needed for utilities at work.

06:46 There's a whole bunch of programming that is not writing desktop applications.

06:51 Oh, absolutely.

06:52 And a lot of it services, a lot of it's on the web, or it's just command line utilities,

06:57 like you said.

06:57 But here's where I think the actual, this is why I think we're underestimating the importance

07:03 of this.

07:04 If you could open up your editor and it was just, you know, here's a few of the widgets.

07:10 I could just drop them in here and I could just put a .app or a .exe somewhere.

07:18 And my entire company could just pick it up and run it locally.

07:20 How often have you not even can entertain that idea because you're just like, well, that doesn't

07:27 exist.

07:27 So why would I even consider this weird idea?

07:29 Right?

07:30 Like we'd probably also see a lot less.

07:32 I mean, there's a lot of internal projects that are, they're set up as web applications, internal

07:38 web applications that could definitely be desktop applications with a shared database backend

07:44 that we don't do it that way because it's not easy to do that.

07:48 Exactly.

07:49 It's super hard.

07:49 But it would be really nice to have some sort of ability to take advantage of the local

07:56 application, a local OS.

07:57 And maybe you talk to a web service for shared data.

08:00 Maybe you just use SQLite locally.

08:02 That might be interesting.

08:04 But I don't think we do this because it's just like, it's so not working that it's just

08:11 like, even if you got the UI working, it's like, okay, well now what do we do for packaging?

08:15 Right?

08:15 I know there are answers, but they're always kind of tricky.

08:17 Right?

08:17 So if that was like entirely obvious, the tooling was just like, yeah, of course you do this.

08:23 Like how many stores in the, how many apps in the Mac app store would be Python apps?

08:28 Right now I bet it's like 0%, you know, like basically, right?

08:32 Once you round it, then round it down to the significant digits, right?

08:35 They don't exist.

08:36 And these things could just open up, right?

08:39 If we could somehow as a community get like a really nice cross-platform UI set up.

08:44 I agree.

08:45 I think some of the stumbling blocks on that are that little thing that you throw in that's

08:50 cross-platform.

08:50 I know that that's cool, but I don't know if it's necessarily a requirement.

08:55 That's true.

08:56 Actually, I would say if you had a killer way to build macOS apps, stop.

09:03 That would be a huge benefit for Python.

09:05 If you had a killer way to build Windows apps, there's still like the majority of, you know,

09:10 business people sit down and log in on a Windows machine.

09:13 Like if you could do that, that would be an amazing advancement for Python.

09:17 So you're right.

09:18 It doesn't necessarily have to be.

09:19 I mean, one model is what the people at Xamarin are doing.

09:23 They basically have cross-platform stuff, but every platform has its own UI bit, but they

09:28 have these kind of designer things that help with that.

09:30 So I don't know.

09:30 I just wanted to put that out there and let people know about this conversation and think

09:34 about it.

09:35 I think we're having an open session at PyCon on it.

09:38 Oh, that would be good.

09:39 Yeah.

09:40 I think I'm glad we're bringing it up because we do need to hammer on this until it's fixed.

09:45 If I look across all of Python, this is like really the place where there's still a weakness

09:49 and it would be nice to just like fortify that wall and make it like a perfect place to be.

09:53 Definitely.

09:54 And like I said, SQLite as a little database, you don't even need a server.

09:57 That might be a good choice, right?

09:59 Yeah, definitely.

10:01 So I came across, well, this is an older interview, but somebody recommended to us that we go back

10:07 and listen to episode 201 of the Change Log.

10:11 It's another podcast, but there's an interview with the, now I should have looked all these

10:17 names up, but the dude that wrote?

10:18 Richard Hipp.

10:19 Yeah.

10:19 Okay.

10:20 You're awesome for looking that up.

10:21 He started at, he calls it SQLite, which I've never heard it pronounced that way.

10:27 SQLite, as in like a meteorite or something.

10:31 Yeah.

10:32 Or is that mineral?

10:32 Yes.

10:33 A very interesting way of pronunciation.

10:34 None of which I would have guessed.

10:35 Right.

10:36 So the rest of us know this is SQLite, I think.

10:38 That's how I know it.

10:39 That's what I'm calling it.

10:40 I didn't quite realize that.

10:41 So this, this is the database.

10:43 If you just say what SQLite three import in Python, you, you get a little single file database.

10:49 This is beautiful because it's built into Python.

10:52 Every instance, every buddy who has Python has this, so you can just count on it being there

10:57 and it runs in process.

10:58 So there's no configuration, right?

11:00 Yeah, definitely.

11:01 And I didn't realize how dang cool the thing is until I listened to this episode that this change log episode.

11:08 One of the comments from the interviewers were, was they just assumed it was a starter database that you always eventually have to move over to something else.

11:18 And that's not true.

11:19 There's as long as your application is not like a web application with extreme client server concurrency, you probably can get away with like a lot of desktop applications are small or the like, if you have a client side part of your application, that could just be a SQLite database and it'll be fine.

11:39 Yeah, that'd be awesome.

11:40 Yeah.

11:40 So if you had like some sort of client side thing that you periodically wanted to sync with a real database, you could store it all in, in SQLite locally and just synchronize that data across some kind of service with your real data.

11:52 And that would be a real nice way to take the load off the server, to have a local offline version, all sorts of stuff.

11:57 Some things I didn't know about SQLite before I listened to this was that it started its life as a TCL application.

12:05 Yeah.

12:06 Which is bizarre.

12:07 It's very bizarre, but that's what happened.

12:09 Well, I guess that's where like TK started, right?

12:11 In the TCL world.

12:13 But the, also that one of the things that you got to watch out for is that it's not as type safe, it's type flexible.

12:20 Yeah, that's what he called it.

12:22 When you are changing over to another database and your other database might be a little pickier than SQLite.

12:27 So be careful of that.

12:28 So an example, you might have a column, which is in the DDL designated as an integer.

12:34 And if you passed, if you tried to assign quote seven to it, it would just convert that to seven.

12:40 Things like that.

12:41 So it's very funky in that regard.

12:43 It's kind of scripty like that.

12:44 He comes from a background of interpreted languages.

12:47 So it makes, and, and weekly typed.

12:51 So that makes sense.

12:52 It's kind of cool.

12:53 Yeah.

12:53 I thought that, that interview was really interesting.

12:55 Definitely a lot of respect for what he's doing.

12:58 He's got some very different opinions and perspectives on open source, on say version control and editors.

13:07 I mean, I'm not sure I agree with all of them, but they're certainly interesting to think about.

13:11 A couple more things.

13:12 The SQL, how there's a page of how SQLite is tested.

13:16 And I think it's really cool that they put that out there of like what their checklist is for testing it.

13:21 The amount of tests are huge, right?

13:23 Yeah.

13:24 And then also that the, I didn't realize it was in everything.

13:28 Like every Android phone has a, is using it and things like that.

13:32 I think iOS as well.

13:34 Yeah.

13:34 Yeah.

13:34 So it's quite ubiquitous.

13:36 It's definitely ubiquitous and it's very cool.

13:38 And I, I think it's definitely a good place to start.

13:41 And a lot of, a lot of times you might not need more than, than that, which is one fewer server to configure one fewer things to patch one fewer thing to make sure the firewalls are all right.

13:52 It's really nice to just have that simple thing.

13:54 Nice.

13:54 So speaking of servers, let's talk about data dog real quick.

13:57 So data dog is a monitoring solution that provides deep visibility inside of not just your app, but the infrastructure.

14:06 Your app works with.

14:07 So within a couple of minutes, you could investigate like say a bottleneck in your code by checking out some flame graphs and dashboards.

14:14 You can visualize your Python performance.

14:17 And if you go and do their free trial, you'll get a free data dog t-shirt, which has got a cool little dog on it.

14:23 So check it out for yourself at pythonbytes.fm/data dog and let them know.

14:28 Thanks for sponsoring the show.

14:29 Yeah.

14:29 Thank you.

14:30 So I told you about Flask being this sort of like API that is standing in for all these other, other places.

14:37 So the next thing I wanted to cover is serverless programming.

14:40 So there was this joke, which I actually don't agree with.

14:44 I kind of slightly disagree with it philosophically, but the sort of making fun of cloud computing saying, well, that's just another person's computer.

14:51 There is no cloud.

14:53 It's just another person's computer, right?

14:54 That you're borrowing.

14:55 Isn't that true?

14:56 It's technically true, but my disagreement is like the cloud computing stuff really has to do with a hardware that you can basically create and control through programming.

15:10 So if there's an API that you can say instantly, I want a machine.

15:13 I want to scale my machine.

15:15 I want to replicate my machine.

15:16 That's not the same as just like co-location or like a rented server.

15:21 Because you can't just go and like rent a server and then hit an API and have like another server.

15:24 So anyway, that's my disagreement a little bit.

15:27 But to some degree, that's true, right?

15:29 Well, we've moved beyond that joke to a farther world of potential ridiculousness where we have server-based programs that have no servers, right?

15:39 This whole AWS Lambda, Azure Functions, serverless programming.

15:43 It's kind of funny, right?

15:44 Yes.

15:45 Yes.

15:46 So basically, the idea with this serverless programming, whether it's AWS Lambda or Azure Functions, is you write a single function, preferably in Python, but often they support JavaScript, C#, things like that.

16:00 And that single function is the entry point into some piece of functionality.

16:06 And you're going to host that function on the cloud.

16:11 And it's up to the infrastructure to figure out like what Docker container to create, run that on, make that happen, scale it, etc.

16:18 You just say, here's literally a Python function and its dependencies run that.

16:22 So that's pretty interesting.

16:24 And the main reason here that people go for this, one, is there's no server at all to maintain, not even a virtual one.

16:29 And the scalability is basically infinite.

16:32 And the price is like insanely cheap.

16:34 Because you only pay while your function's literally executing.

16:38 Okay.

16:39 But I mean, there's still servers.

16:40 You just don't have to set it up.

16:42 Yeah.

16:42 And your code is not stuck to one of them, right?

16:44 Like every function call basically, I think, is a new Docker container.

16:47 I'm not entirely sure about the internals.

16:49 But basically, every call is like an isolated execution.

16:53 And then it goes away.

16:54 That's part of the appeal also is that you don't really have to care about that.

16:57 Yeah, it's totally the appeal.

16:58 The infrastructure just deals with it.

17:00 Yeah, you do pay for a small latency on every request because it's got to like spin up this bit.

17:04 But that's still for a lot of things that are not super performance critical, at least in the latency, it totally would be fine.

17:12 So what I wanted to talk about this week is this thing called Chalice, a Python serverless micro framework for AWS.

17:18 So basically, this is a Flask API.

17:22 Another Flask API.

17:24 Another Flask API.

17:26 So you implement these functions in Chalice.

17:30 And you decorate them with this Flask API.

17:33 But instead of running a Flask app, you create a Chalice app.

17:36 And then you can even say like Chalice deploy and run it.

17:40 And then you just go and basically request your thing.

17:45 So what you effectively create is something that looks like a Flask app with all the different pieces that are related and so on.

17:51 But then they're hosted as individual function calls on the serverless infrastructure.

17:58 So it's pretty cool, right?

17:59 Wow.

17:59 Okay, that's cool.

18:00 Yeah.

18:00 So I think this is really interesting.

18:02 So this is just like we're going to take Flask and put it onto AWS Lambda, which is pretty cool.

18:08 Maybe the other counterpart that I know pretty well is Zappa.

18:12 So Zappa is, I believe, its own framework.

18:15 I don't think it has a Flask variation.

18:17 I could be wrong.

18:18 I haven't done that much with it.

18:19 But Zappa also lets you basically create this API against this website equivalent scaled out across these different functions.

18:28 Yeah.

18:29 So pretty cool things to be playing with.

18:30 Like you don't even need cloud anymore.

18:32 Now you don't even need servers.

18:33 It's all serverless.

18:34 Yeah.

18:35 So you still, I mean, of course, you still have to set up like an AWS account and get your token or whatever to hook into this, I assume.

18:43 Yeah, exactly.

18:44 You've got to get your own token and all those things.

18:46 And yeah, you probably are talking to like some sort of hosted database or S3 or some combination thereof to actually do your work, right?

18:55 Right.

18:55 And actually, so I've never worked with AWS, but these sorts of things make me kind of want to try because it doesn't look scary at all.

19:02 Absolutely.

19:02 So let's wrap it back to item one.

19:04 When you create your Flask skill, your Ask Flask stuff, and when you work with Alexa, one of the main ways to work with Alexa is to actually tie, see?

19:18 See, she's speaking to me now.

19:20 To have her, you could tie those two Lambda functions, these serverless functions.

19:25 So actually, you could put it all together like that.

19:27 Neat.

19:28 Yeah, cool.

19:28 Definitely.

19:29 So I think you can probably help some people with job interviews coming up here.

19:32 First, how do I reverse a string?

19:35 Second, what's the fastest way to uniqueify a list in Python?

19:39 Reverse a string?

19:41 Yes.

19:41 This is a short little thing, but there's a blog article called The Fastest Way to Uniquify a List in Python greater than or equal 3.6.

19:51 So basically, 3.6, unless you're running 3.7 already.

19:56 I just appreciated the, instead of having just an article that says, okay, here's the answer.

20:01 There is a discussion of the different ways you might do it and the code for how he timed it.

20:06 So you can reproduce all of, if you don't believe it, you can reproduce all the code and get your results on your machine.

20:13 It's probably similar.

20:14 The short answer is, if you want to keep the order in place, you simply do a list of a dict from keys of your sequence.

20:23 And we'll have this in the show notes, of course, and a link to the article.

20:27 And if you don't care about the order, then just convert it to a set and then a list.

20:33 So that's it.

20:35 And I've used the list set before.

20:38 And I was actually, I mean, it makes sense that from keys works.

20:42 I've never really used that before.

20:44 So that.

20:45 Yeah.

20:45 And it's going to get interesting with the promises of dictionaries being ordered.

20:49 You could actually get some of these to be a little quicker, right?

20:53 But still preserving the order.

20:54 Well, isn't that the way it is now?

20:56 Not all.

20:57 Like some of them, there's like two graphs that says not order preserving functions and then order preserving functions.

21:03 And right now they have list of set of list.

21:07 Not order preserving.

21:09 Right.

21:10 Because set isn't an order preserving thing.

21:12 So, yeah.

21:13 But it's pretty cool, though.

21:13 Pretty cool.

21:14 Definitely worth thinking about all the different ways and seeing the tradeoffs and so on.

21:18 Okay.

21:19 All right.

21:19 So I want to wrap up this episode with leaving some people with homework.

21:22 They've got some research and some chilling on the couch watching some Python videos.

21:28 Okay.

21:28 So there's two sets of conference videos that came out.

21:33 And I'm sure there's some that I've missed.

21:34 But these are the two that stood out to me recently.

21:36 Pi Texas and PiCon Australia both have their videos up.

21:42 And I linked to the playlist on YouTube for both of them, which is pretty cool.

21:46 There's, you know, like always like 40 or more videos.

21:49 There's tons of really interesting stuff.

21:51 But I kind of wanted to touch on some that I, these are not necessarily endorsements.

21:57 These are just like, these look really interesting to me.

21:59 And I'd like to go watch them.

22:00 I haven't spent all this time watching all these videos just right now.

22:03 But from Pi Texas, there's a talk on MicroPython.

22:07 Which MicroPython is really, really cool.

22:10 Right?

22:10 You can run your Python on like a $5 microchip and hook your Lambda functions, your Python ones, up to like hardware interrupts.

22:18 Like that's just the coolest.

22:19 And then there's so much talk about machine learning and AI and all that stuff.

22:24 So there was a talk given there called, What is Machine Learning Anyway?

22:28 Or something like that.

22:29 So like a foundational background on machine learning, which is cool.

22:33 And another one is C for yourself with the letter C, not S-E-E.

22:37 So like trying to explore the internals of CPython.

22:40 And then there's one on Python and .NET for this thing called Python.NET, which is not the Iron Python that's been around for a long time.

22:46 But like this newer way to try to integrate those things.

22:49 So all the people that work on the big enterprise apps in C#, they can now plug in some sweet Python or vice versa.

22:54 Yeah.

22:55 Okay.

22:55 Those all look good to me too, especially the MicroPython.

22:59 Yeah.

22:59 The MicroPython is great.

23:00 So that's in Texas.

23:01 And then Australia.

23:02 I don't know.

23:03 Those guys were killing it with names down there.

23:04 They just really did a good job.

23:06 And there's so many.

23:06 I have more I pulled out.

23:08 So I'll go a little quicker.

23:09 Gradual typing.

23:10 Right?

23:11 We've talked about that, the typings and adding them and stuff.

23:13 And I think this is probably a really interesting survey that.

23:16 Hot reloading Python web servers at scale.

23:19 Ooh, that sounds nice.

23:21 Yeah.

23:21 That sounds like a lot of cool internals.

23:23 Prototyping Python microservices in production.

23:25 And secrets of a WSGI master, like understanding the base HTTP protocol.

23:31 And then another one.

23:33 Python 3 for people who have not been paying attention.

23:35 So that's not anybody that's listening to this.

23:40 Exactly.

23:40 They know about legacy Python.

23:42 Come on.

23:42 Then identity 2.0.

23:44 What, what, why, and how of social and federated logins.

23:48 So if you've got to do anything with like identity across providers, that's so painful.

23:51 This would be cool.

23:53 And then here's a sort of a Tesla reference.

23:56 I'm guessing Python ludicrous mode with Django.

23:59 So ludicrous mode in the Teslas is like, you know, like the insane amount of power.

24:04 Like, you know, give you a neck ache if you hit the gas yard sort of thing.

24:07 So something to that effect.

24:09 And then finally, scaling down.

24:12 We often talk about scale up and all this complexity you got to deal with.

24:16 You even talked about how you're not Google.

24:18 You're not Facebook or any of these things a while back, which was cool.

24:21 But this is, if you do have one of these large sites that's got a complicated architecture,

24:26 let's say a Redis back-end message queue type thing and a database and a whole bunch of other

24:32 stuff, maybe some of those are hosted in the cloud.

24:34 Like, how do you actually develop that locally also?

24:37 That's cool.

24:38 That's definitely a need for everyone, I think.

24:41 I'm sure there's a lot of good lessons in there.

24:42 So the links to both of those playlists are up on the show notes.

24:47 So that should be fun.

24:47 All right, cool.

24:48 All right.

24:49 Well, how about you?

24:49 Any other news?

24:51 We're out.

24:52 So that was six.

24:54 Cool.

24:54 Cool.

24:55 You've actually been crushing it lately.

24:57 I've been so busy.

24:59 It's been so fun, though.

25:00 Yeah.

25:01 So last week, I released my Everything Bundle where people can get all the courses, right?

25:05 And so I shipped my first course for that Everything Bundle called Mastering PyCharm,

25:10 which, yes, it covers PyCharm, but it's also basically like a little mini course on like 16

25:16 different parts of software development.

25:19 So there's like a little tiny 20 minute thing on refactoring and a 15 minute thing on unit

25:23 testing and pytest.

25:24 Okay.

25:25 30 minute thing on Git and stuff.

25:27 So it's like sort of all those little pieces put together, but through the lens of working

25:31 with PyCharm.

25:31 So I'll link to that.

25:33 And yeah, people can check that out if they want.

25:37 And I'm also doing a webcast with the JetBrains people, but on MongoDB.

25:40 So if they want to, people want to drop in on that on January 30th, I'm doing a live event

25:45 with JetBrains and the link for that registration will be there.

25:48 It's free.

25:48 You can come check it out.

25:49 Cool.

25:50 I'll come watch.

25:51 All right.

25:51 Awesome.

25:51 Well, yeah, that's all I've been doing this week.

25:54 Nice.

25:56 Great.

25:56 All right.

25:57 Well, thank you, Brian.

25:57 Thank you.

25:58 A lot of good stuff this week.

25:59 Yeah.

25:59 And looking forward to more next.

26:01 Talk to you next week.

26:02 All right.

26:03 Bye.

26:04 Thank you for listening to Python Bytes.

26:05 Follow the show on Twitter via at Python Bytes.

26:08 That's Python Bytes as in B-Y-T-E-S.

26:11 And get the full show notes at pythonbytes.fm.

26:14 If you have a news item you want featured, just visit pythonbytes.fm and send it our way.

26:19 We're always on the lookout for sharing something cool.

26:21 On behalf of myself and Brian Okken, this is Michael Kennedy.

26:25 Thank you for listening and sharing this podcast with your friends and colleagues.