Mastering PyCharm Transcripts
Chapter: Databases
Lecture: Your turn: Databases
Login or
purchase this course
to watch this video and the rest of the course contents.
0:01
Databases are really front and center in PyCharm.
0:05
We saw we can add existing databases to our database explorer
0:09
and use all sorts of cool tools against it
0:12
and even have those schemas work with the editor itself.
0:16
So it's your turn to play with databases in PyCharm.
0:20
Over here on github under 5-databases
0:24
you'll see there's some steps to go through here.
0:27
First thing I am going to do is open an existing project
0:29
which is database project, same folder right there
0:32
and then open this up and it will come with a folder and a SQLite file
0:36
so we're going to start by opening this SQLite database in PyCharm
0:41
so we can explore it, and one of the important things that's going to happen here
0:46
is you may configure the drivers to actually understand SQLite for later projects,
0:50
once and for all on your machine, so that's cool.
0:53
We're going to open up this existing project and explore it
0:56
we're going to write some queries against it,
0:58
to find some interesting tracks,
1:00
this is like an album store with artist, album, tracks, users and so on
1:05
and we're going to also use the diagram tools
1:08
to understand how things like track and album,
1:11
what they look like and how they are related to each other.
1:14
And finally, you're going to see the really amazing feature
1:17
of when you have SQL embedded within strings in Python files
1:20
how you get both SQL language and database schema autocompletion
1:25
which is just amazing.
1:28
Alright, so get out there and play with this example
1:30
and enjoy the database stuff.