How To Use SQLite Database In Python For Beginners

preview_player
Показать описание
SQLite is a lightweight, file-based SQL database, and it comes with your Python installation already. Despite SQLite being a lightweight database, it can perform database operations really well. If you are looking into working with a database in Python, SQLite is a great choice. Many web and mobile applications today use SQLite database to store and manage data workflow.

In this tutorial we are going to learn how to work with SQLite database in Python.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

00:00 - Intro
01:51 - Import SQLite Python module
01:59 - Create/Connect a SQLite database
04:31 - Create a table
08:31 - Insert records
09:40 - Query records
13:43 - Using WITH statement

#sqlite #python #pythontutorial
Рекомендации по теме
Комментарии
Автор

You're the best.
I was planing to use it for video game development.

SkyFly
Автор

sqlite3 library it too "low-leveled", it's much better to use peewee or sqlalchemy

georgiyveter