Mastering PyCharm Transcripts
Lecture: Introduction to database tools
0:01 We've come to our database section
0:03 and almost all major applications use databases and they generate tons of data
0:07 and working with it is really, really important.
0:11 It can be the difference between that
0:13 super slow laggy type of experience or super fast and crisp,
0:17 so we're going to see what PyCharm has to offer in the realm of databases.
0:21 It's quite a bit.
0:23 First let's ask the question— why is working with relational data hard?
0:27 Well, there's a couple of reasons,
0:29 but one of the primary reasons is actually broken or suboptimal tools.
0:34 We don't often have great, especially visual tools
0:38 to help us explore and interact and modify even the schema of our databases,
0:46 so yes, sometimes there are tools for this,
0:49 but typically it's some specialized database tool if it even exists
0:54 that we need to use, it's not built right into our editor
0:58 and you'll see some really amazing stuff that can happen
1:00 because the data tools are integrated with our editing tools.
1:05 Well, I'd say it's also hard because migrations
1:08 you know, changing the schema after you put data in the database in production,
1:12 yeah that's hard,
1:15 and object/relational mismatches,
1:16 so yeah, working with relational data can be harder than maybe it should be
1:21 but those last two, those are just the nature of relational databases
1:24 so we're going to focus on the tools that PyCharm has
1:28 that can really level up your experience of working with data.
1:32 Remember this Pyramid here,
1:34 we've got IntelliJ, WebStorm, DataGrip and PyCharm
1:36 and PyCharm is sort of the Python tools plus all these other things.
1:41 In this chapter what we're going to focus on really lives right here,
1:45 everything is going to come from DataGrip
1:48 except for the final little feature that we're going to talk about,
1:52 which is pretty awesome, it has to do with Python plus DataGrip
1:55 but pretty much everything else is kind of a DataGrip type feature.