MENU

Fun & Interesting

PyQt6 - Database-Driven Desktop Apps! | QtSql module

BugBytes 5,493 7 months ago
Video Not Working? Fix It Now

โ˜•๏ธ ๐—•๐˜‚๐˜† ๐—บ๐—ฒ ๐—ฎ ๐—ฐ๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฒ: 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: https://twitter.com/bugbytesio ๐Ÿ“š ๐—™๐˜‚๐—ฟ๐˜๐—ต๐—ฒ๐—ฟ ๐—ฟ๐—ฒ๐—ฎ๐—ฑ๐—ถ๐—ป๐—ด ๐—ฎ๐—ป๐—ฑ ๐—ถ๐—ป๐—ณ๐—ผ๐—ฟ๐—บ๐—ฎ๐˜๐—ถ๐—ผ๐—ป: QtSql module: https://www.riverbankcomputing.com/static/Docs/PyQt6/api/qtsql/qtsql-module.html#qtsql VSCode SQLite extension: https://marketplace.visualstudio.com/items?itemName=alexcvzz.vscode-sqlite QTableWidget: https://www.riverbankcomputing.com/static/Docs/PyQt6/api/qtwidgets/qtablewidget.html#qtablewidget PyQt6 reference guide: https://www.riverbankcomputing.com/static/Docs/PyQt6/ #python #pyqt #pyqt6

Comment