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.