#100DaysOfCode in Python Transcripts
Chapter: Days 91-93: Database access with SQLAlchemy
Lecture: Demo: Seeing the database

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Before we put the wraps on our game, let's have a quick look inside the database. Julian already talked about DB Browser for SQlite,
0:07 runs on all the platforms this little thing. This is quite cool and if this is what you want to use I totally recommend it. It looks quite nice.
0:14 I'm a fan of PyCharm and PyCharm also already has tools for this. So if you go over to database, and you hit the + and say data source.
0:22 Now if we pick Sqlite serial, you'll have to make sure if it doesn't say driver, there's a little button to say download the driver here.
0:31 So if you don't do that, this is not going to work. But once that is done, I'm going to drag from here to there,
0:36 you can actually see what is in our database. Go to schema, to main, hit our moves players rolls. Roll moves is most interesting, let's look there.
0:43 Here you can see it's all the various pieces. These orange things mean these have indexes. Here's the actual details.
0:50 I can even come over here, jump to the console and say select star from, move to where, and you get all sorts of details.
0:57 Like let's say player id equals one, that's probably me. Then there's all the moves that I made since I entered first into the game.
1:06 Pretty sure my id is one, we can check that. Anyway here's how we query it, and you can see all the different games
1:12 that this has been running in and so on. So this is really nice when caveat this only works in PyCharm professional. If you have PyCharm community
1:19 well you're going to need to use something else right. The database access stuff is not part of that so I'd check out that DB browser for Sqlite.

Talk Python's Mastodon Michael Kennedy's Mastodon