filmov
tv
Python & SQLite: Create DB & Tables.

Показать описание
Welcome to a new tutorial series, this video is going to be about creating a database in Python using SQLite.
Let's first look at what a database is,
So inside a database you can have tables and inside those tables you can store data and access it whenever you need to. Basically a database can be defined as a collection of data organized in tables.
Now let's talk about SQLite databases:
As the name suggests it is a lite version of SQL database, you don't need any server to use a SQLite database. It is also really easy to set up. It just creates a .db file on your local system and that file contains all the tables.
But a full version of SQL like MySQL can be a bit hard to set up. Feel free to look up the differences between SQLite and MySQL
(Affiliate Link, Helps the Channel)
Let's first look at what a database is,
So inside a database you can have tables and inside those tables you can store data and access it whenever you need to. Basically a database can be defined as a collection of data organized in tables.
Now let's talk about SQLite databases:
As the name suggests it is a lite version of SQL database, you don't need any server to use a SQLite database. It is also really easy to set up. It just creates a .db file on your local system and that file contains all the tables.
But a full version of SQL like MySQL can be a bit hard to set up. Feel free to look up the differences between SQLite and MySQL
(Affiliate Link, Helps the Channel)