☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
https://ko-fi.com/bugbytes
⭐Top resource to learn Python - https://datacamp.pxf.io/kOjKkV ⭐
In this video, we'll dive further into PyQt6 and look at how to integrate our desktop apps with a local relational/SQL database. We'll see how to create a Form that allows new entries to be added to the database, and how to create a Table that displays existing database entries.
📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:30 QtSql module in PyQt6
01:38 Creating SQLite database
03:13 Create connection to database with PyQt6
08:36 Creating MainWindow in the PyQt6 application
11:48 Create Todo Form widget in PyQt6
18:47 Adding QTableWidget of existing Todo items
21:58 Adding to database when form is submitted
27:19 Updating QTableWidget on submit
34:30 Populate QTableWidget with database items on load
𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: https://bugbytes.io/posts/
👾 Github: https://github.com/bugbytes-io/
🐦 Twitter: / bugbytesio
📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
QtSql module: https://www.riverbankcomputing.com/st...
VSCode SQLite extension: https://marketplace.visualstudio.com/...
QTableWidget: https://www.riverbankcomputing.com/st...
PyQt6 reference guide: https://www.riverbankcomputing.com/st...
#python #pyqt #pyqt6