Data Science Jumpstart with 10 Projects Transcripts
Chapter: Project 9: SQL / Database Integration
Lecture: Using SqlAlchemy to Connect to a SQLite Database
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Okay, in this section I'm going to show you how to connect to a database
0:04
I'm gonna use SQL alchemy to connect to a database a nice thing about SQL alchemy is it provides as a consistent interface
0:10
Theoretically you could swap out the connection string and connect to other databases now in practice
0:15
Some databases have features that other databases don't support but a lot of times for the 80 90% use case
0:23
This works quite well. Make sure you install SQL alchemy. I'm gonna make a connection here to a SQL lite
0:30
Databases is saying I want to make a in file connection with SQL alchemy
0:35
I'm gonna say create an engine and so I'm gonna create an engine that says I can connect to SQL lite and This is going to be a file based connection
0:44
if I was using Postgres I would need to specify like a URL and a username and a password and possibly a database name similar for other databases like
0:53
Oracle or SQL server