Python-powered chat apps with Twilio and SendGrid Transcripts
Chapter: Setup and following along
Lecture: Database visualization tools
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.