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.