Effective PyCharm 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 a degree I agree with them.
0:07 It is challenging and you have to be very precise making changes you know sometimes trying to make a change will conflict with existing data and so on.
0:17 I also think that there's another thing at work here. I think a lot of people are working with either broken or sub optimal database tools
0:25 If you don't have some kind of nice visualization way to work with your database you're kind of doing it wrong.
0:33 If you don't have something that will allow you to write queries against your database that
0:37 understands the schema and gives you auto complete and checking for the SQL queries. You right might not be doing it right.
0:45 I'm really excited to show you this stuff here around PyCharm because it's going to
0:50 fix a lot of these sub optimal or broken tool problems that and well migrations and
0:57 the object relational impedance mismatch. So those things are just inherent to relational databases and
1:02 that's how it goes. But this broken tool problem, we're going to fix that in this chapter. Remember this pyramid of how PyCharm is built.
1:11 There's this data grip section right here and almost all the features that we're going to talk about in this chapter come from DataGrip.
1:18 So this is not just PyCharm, having some understanding of working with relational databases but it's basically encapsulating an entire.
1:26 IDE specifically built for working with relational databases. Let's dive in.

Talk Python's Mastodon Michael Kennedy's Mastodon