Python-powered chat apps with Twilio and SendGrid Transcripts
Chapter: Setup and following along
Lecture: Database visualization tools
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
We're going to be working with a relational database to soar all the interactions that we
0:04
have from twilio back over to our flask application, in order to make the most of
0:10
that, understand what's happening. We really need a decent database visualization tool.
0:15
If you have PyCharm and it's the Pro edition,
0:17
it comes with some really fantastic data exploration,
0:20
query and visualization tools, like we have right here, so you can go and open your
0:24
database, go to the table.
0:26
See the columns, were either even pull up these diagrams.
0:30
I give you the option to not use PyCharm Pro,
0:32
which is paid not super expensive.
0:34
You can pay like $8 a month.
0:35
And if your student if you work at university,
0:38
if you have an open source project,
0:40
they'll give you a free copy and sort of follow the pricing page for that.
0:44
Nonetheless, if you don't have PyCharm pro,
0:46
you won't have this view. So what do you do?
0:48
We're going to be using a different tool in that situation.
0:51
We're going to be using Beekeeper Studio,
0:53
so if you don't have the PyCharms tools built in,
0:56
just go and get Beekeeper Studio at beekeeperstudio.io.
1:00
It's a really nice database exploration tool, lets you see the tables,
1:04
see their column definitions, go into queries and edits and whatnot.
1:08
So this is really nice option for working with the databases that we're going to be
1:11
creating during this course. If you don't have PyCharm pro,
1:14
if you already got that, you can just use that as well.