Effective PyCharm (2021 edition) Transcripts
Chapter: Databases
Lecture: Why is relational data hard

Login or purchase this course to watch this video and the rest of the course contents.
0:00 I hear a lot of people say that working with relational databases is hard and to
0:04 a degree I agree with them.
0:06 It is challenging and you have to be very precise making changes you know sometimes trying
0:12 to make a change will conflict with existing data and so on.
0:16 I also think that there's another thing at work here.
0:19 I think a lot of people are working with either broken or sub optimal database tools
0:24 If you don't have some kind of nice visualization way to work with your database
0:29 you're kind of doing it wrong.
0:32 If you don't have something that will allow you to write queries against your database that
0:36 understands the schema and gives you auto complete and checking for the SQL queries.
0:41 You right might not be doing it right.
0:44 I'm really excited to show you this stuff here around PyCharm because it's going to
0:49 fix a lot of these sub optimal or broken tool problems that and well migrations and
0:56 the object relational impedance mismatch. So those things are just inherent to relational databases and
1:01 that's how it goes. But this broken tool problem,
1:04 we're going to fix that in this chapter.
1:06 Remember this pyramid of how PyCharm is built.
1:10 There's this data grip section right here and almost all the features that we're going to
1:14 talk about in this chapter come from DataGrip.
1:17 So this is not just PyCharm,
1:18 having some understanding of working with relational databases but it's basically encapsulating an entire.
1:25 IDE specifically built for working with relational databases. Let's dive in.