Python Desktop GUI App with SQLite DB (PyQt/PySide/Qt Designer) | Modern GUI

[@온상온상]

Thanks! 5:05 Start QtDesigner 28:00 Slide menu nav styling 43:08 Add Right input menu 51:36 Add Main pages 1:06:42 Add App theme 1:21:46 Create App functions

[@SpinnTV]

Good 😊

[@selimahmedov8591]

Without any previous experience with QtDesigner I followed the tutorial step by step. The program worked at the end as expected. Feel much more comfortable now designing a simple interface. Thanks for the time and efforts spent for this upload.

[@toshikakhedkar9302]

can u share the code?

[@sillytechy]

Literally the best

[@cyberspace34]

best tutorial I have ever seen😍

[@kidtoucher302]

i'll save that up for later, after doin some sqllite tutorials i'll come back

[@SpinnTV]

great 😃

[@SpinnTV]

Github Link: github.com/KhamisiKibet/QT-PyQt-PySide-Custom-Widgets Download Functions.py and JSON stylesheet File: www.spinncode.com/designs/UodyvxWP Full Source Code Download Link: www.patreon.com/posts/69977644 Subscribe for more awesome videos.

[@TheRealWattsie]

Spinntv link no longer works... This Account has been suspended.

[@SpinnTV]

@@TheRealWattsie will be restored today, check back later

[@agungwahyu9181]

ImportError: cannot import name 'ProjectMaker' from 'Custom_Widgets' (C:\Users\user\AppData\Local\Programs\Python\Python38\lib\site-packages\Custom_Widgets\__init__.py)

[@-0-__-0-]

A word of advice. Try putting an effort in speaking in your videos. If you can't then with all technologies available today, AI can do it for you.

[@SpinnTV]

Thank you

[@fredieeevlogs7077]

I got an error cannot loas library ' liccairo.so2': error 0x7e that error as well for libcairo.2.lib.dylib libcairo-2.dll

[@RQ_BC]

Tried to start the project but I got a traceback when creating it 🥺

[@kidtoucher302]

oh, do more sqlite, qt designer tutorials btw

[@Kitsune_IX]

Other question i got this error OSError: no library called "cairo-2" was found cannot load library....... . How to fix this whole Error (I got the error around doing this here 3:22)

[@MohamedAbdeen-k2c]

Do you know the solution to this problem?

[@CodingCartographer]

I tried to follow this on my Windows but got Cairo library error.

[@Wallker_234]

Very good, I'm learning a lot from you, one more question, can I create this same project for Windows 10 using Qt Designer or not?...

[@SpinnTV]

Yes you can

[@againstthegrain5914]

so can you explain to be when you use SQLite over Postgresql? is there a big difference? Thanks!

[@ОлегЄлечко]

I think because of easyness of SQLite) this video was more focused on GUI than on ``backend``

[@zerocool3002]

How can I modify the size of the table cell? You're the best!!

[@hamzabenabderrazek2542]

i cant install python 3.7 so i couldn't install pyside2 i'm working with python 3.11 now and i get too many errors when applying the instructions from your video with pyside6 is there a solution ?

[@egitimhesabi-t7w]

Great video, can you do a tutorial on how I can make it into an executable file?

[@SpinnTV]

kzbin.info/www/bejne/gHyQc2B5iZhne7c

[@sutibenigarashi]

Why does the guy have two code editors?

[@SpinnTV]

For reference

[@tronghoang4700]

I had this problem : Traceback (most recent call last): File "C:\Users\ADMIN\PycharmProjects\AppMentor\main.py", line 66, in window = MainWindow() File "C:\Users\ADMIN\PycharmProjects\AppMentor\main.py", line 31, in __init__ self.ui.setupUi(self) File "C:\Users\ADMIN\PycharmProjects\AppMentor\ui_interface.py", line 53, in setupUi self.centralwidget = QWidget(MainWindow) TypeError: 'PySide2.QtWidgets.QWidget' called with wrong argument types: PySide2.QtWidgets.QWidget(MainWindow) Supported signatures: PySide2.QtWidgets.QWidget(typing.Optional[PySide2.QtWidgets.QWidget] = None, PySide2.QtCore.Qt.WindowFlags = Default(Qt.WindowFlags)) .Please help me !

[@niggolas1807]

i somehow can't do the Layout Alightment for the header to be alight at top. the function is grayed out

[@SpinnTV]

Close and restart qt designer

[@maus371]

Thank you!!! I learned a lot from your tutorial! I am very grateful for it. My problem is that when I go to initialize Project Maker by typing from the prompt (I have version 0.8.5 of Custom Widgets): Custom_Widgets --create-project it gives me error: no library called "cairo" was found no library called "libcairo-2" was found how can i solve the problem?

[@yathinyoyo3893]

hey bro can u please share the source code of ur git please

[@maus371]

@@yathinyoyo3893 I'm sorry bro, but I don't have git. I followed all the steps described in the video, but as mentioned, when I get to initialize Project Maker it gives me the errors written above and then the following are not created: the QSS folder and the two files interface and main described in the video.

[@SpinnTV]

check the channel videos for the solution

[@gh72883]

I Would appriciate it if you could also upload the json file availible to be downloaded ... Thank you so much I have gained so much from your work in these last weeks. 🙏🏼🙏🏼🙏🏼

[@SpinnTV]

Done! check the link

[@hgmdev]

In Delphi, this is done much faster and more conveniently. In this case, the code will be 3 times less, or even 5 times less. Plus, the table will be editable and auto-filled out of the box. No extra code.

[@SpinnTV]

is it free?

[@hgmdev]

@@SpinnTV yes, sure

[@hgmdev]

@@SpinnTV look) kzbin.info/www/bejne/j5O3lXeqn9Kcr8k

[@faressiouane3530]

What ain't it dead yet ?

[@argaivthegreat7927]

I would be very very interested to know more ! I tried to look about it today and it seems sooo complicated !! I also heard that it's a dying (dead?) language? Maybe you can enlighten me please.

[@m.ashfaqullasharif3085]

Can anyone explain? I didn't found job postings related to pyqt or Qt framework, what to do? Some job sites didn't even recognise pyqt as keyword !!

[@SpinnTV]

search for desktop applications, qt etc. Start from Upwork

[@servetbirgul]

superrrrrrr

[@MK323F]

Thank you for the tutorial, the code is running fine with no errors, only i dont see the icons from the json file when the side menu is collapsing/expanding

[@SpinnTV]

Check the cmd output, maybe your icon url is incorrect

[@casagaming15]

1:00:44 mine is not working like yours. I already update the library but still not working whenever I tried to navigate

[@kaiqueteste5005]

👏🏼👏🏼👏🏼👏🏼

[@maslowmbouolangtiotsa8315]

i have the difficulty importing the projetMaker the command line of the 4th minute🙏🙏

[@SpinnTV]

github.com/KhamisiKibet/QT-PyQt-PySide-Custom-Widgets

[@ernisesama1636]

Thank you very much for your work. But tell me how did you get the "View Python Code" option in the menu? Menu/ Form/ View Python Code...

[@SpinnTV]

I have a video solving that issue, please check it out.

[@casagaming15]

​@@SpinnTVwhere is the link?

[@SpinnTV]

@@casagaming15 kzbin.info/www/bejne/l4jIiKaXjbGZaNk

[@Jx2LucTieuLinhDong]

Thank you so much ! Bro

[@tipr8739]

The package has some serious issues. When using qtpy if pyqt5 is installed, it imports the qmainwindow as a qt5 object. Then your library creates a qwidget as a pyside object. So in the main part of the code, it throws an error in setupui() that the self.centralwidget = pyside2.qwidget(pyqt5.qmainwindow) line expects a pyside2 type qmain window. If you go through and manually change QT_API = ‘pyside2’ it crashes the qtpy library. I would say if you are going to inherit from pyside use explicit imports, not from lib import *

[@SpinnTV]

try uninstalling pyqt

[@tipr8739]

@@SpinnTV that defeats the whole point of why you used qtpy in the first place though

[@SpinnTV]

@@tipr8739 go to qtpy documentation, see how you can configure it to prioritize pyside or pyqt. Qtpy serves a very important role in this module

[@MegaMetalrulez]

hi, how can i convert this project to exe file ? I tried pyinstaller and cxfreeze but they dont work. Pyinstaller gives me an error due to the presence of both pyqt5 and pyside and cxfreeze gives me an error about cairosvg library (fixed on script version of the program by installing gtk3 as you show in your fix tutorial)

[@SpinnTV]

This will help you kzbin.info/www/bejne/gHyQc2B5iZhne7c

[@nrbnlullu9327]

Why not QML? using Qt Widgets for creating non-native applications can get messy real quick.

[@ismailhassan3455]

>>> from Custom_Widgets import ProjectMaker Traceback (most recent call last): File "", line 1, in File "C:\Python\Python37\lib\site-packages\Custom_Widgets\ProjectMaker.py", line 29, in raise Exception("PySide2 or PySide6 is required, please install it!") Exception: PySide2 or PySide6 is required, please install it! Please help me Although it was installed PySide2 and PySide6

[@SpinnTV]

you have multiple pythons installed?

[@inouguys8136]

​@@SpinnTV I am facing the same problem and also i have only one python3.9 installed on the system please help

[@Mecreap]

Having also the same Problem. Have tried some python version. But i guess the new version should have work? And tried on other devices nothing worked. Could you please help me there? i want also try it.

[@francescocatalanotti7506]

@@SpinnTV same problem here, pls help. I've only one python and PySide2 installed too.

[@francescocatalanotti7506]

Did you manage to find any solution for this problem? I'm really stucked...

[@ЕвгенийКофанов-э5д]

Good work! Thank you!

[@angeloniforatos5006]

Hello, this is kind of a nitpick. When I open QTDesigner it doesnt load the styles like it does for you in the video. Plz help!

[@SpinnTV]

Hi, can you provide the video timestamp?

[@angeloniforatos5006]

@@SpinnTV Thanks for the fast reply, 4:50

[@SpinnTV]

@@angeloniforatos5006 if you used project creator, your ui file should have that style by default

[@zeppeli43]

I don't have "view python code" in "form", what to do?

[@SpinnTV]

Tutorial available, check channel videos

[@richardmwangi2050]

OSError: no library called "cairo-2" was found how can I solve this error

[@SpinnTV]

Hello, please check my GitHub page, custom widgets, under issues

[@shreyaslabhsetwar6083]

How to add edit and delete functionality for each row?

[@SpinnTV]

cant explain that here, but you need to create a separate function for that

[@walilei9297]

Excellent project thanks a lot

[@MrChuyvs]

Hi, I have an error and I can not find the solution. In displayUsers function, if database is clear everything it's ok but if I have one entry recorded the message is: self.ui.tableWidget.setVerticalHeaderItem(rowPosition, qtablewidgetitem) TypeError: setVerticalHeaderItem(self, row: int, item: QTableWidgetItem): argument 2 has unexpected type 'PySide2.QtWidgets.QTableWidgetItem' You make an instance of the QtableWidgetItem in qtablewidgetitem for this but it doesn't work for me... I'm lost xD (Sorry for my english)

[@MrChuyvs]

It's working... I maybe compiler and saving things... Thanks for all bro... you are amazing... I'll subscribe to your patreon at first chance. Have a nice day 👍

[@SpinnTV]

might be syntax error, check your code

[@berkdan]

Good job thanks. Unfortunately spinntv link does not work.

[@Tooxcade]

Amazing ❤️❤️❤️❤️❤️

[@MrAvelino2010]

Awesome can you make a small project with login and crud using django rest framework for backend

[@PiMpMyCoMpUtEr]

yes please, make it bro

[@PANDURANG99]

filter for table?

[@SpinnTV]

I think I did that here kzbin.info/www/bejne/q3_Qe6OmmJKaiJo

[@PANDURANG99]

Qt is free or we have to pay for commercial use

[@wolfliegaming7848]

no matter how many times i rerun it, it wont give me the _rc qss resources Traceback (most recent call last): File "C:\Users\dylan\OneDrive\Desktop\projection\ui_interface.py", line 15, in import QSS_Resources_rc File "C:\Users\dylan\AppData\Local\Programs\Python\Python310\Lib\site-packages\shiboken2\files.dir\shibokensupport\__feature__.py", line 142, in _import return original_import(name, *args, **kwargs) ModuleNotFoundError: No module named 'QSS_Resources_rc'

[@SpinnTV]

convert qrc to py

[@Alexander-ww1vv]

Can you do a tutorial of QMessageBox?

[@Kitsune_IX]

at 28:07 what progam did you use?

[@morfotuzbir]

Sublime Text

[@Kitsune_IX]

@@morfotuzbir ty

[@pet.me102]

>>> Custom_Widgets --create-project Traceback (most recent call last): File "", line 1, in NameError: name 'Custom_Widgets' is not defined I don't know how to fix lol.

[@pet.me102]

Already failing from step 1 lol. I'm a failure XD I have got no cairo error, I think I fixed it (like your solution video) but I still got ''Custom_Widgets' is not defined. This is so weird, 'pip install QT-PyQt-PySide-Custom-Widgets' but when check with 'pip list', it's not there XD Your library is the only one that counters this issue, other library works fine. I don't understand why and how to fix.

[@SpinnTV]

pip install --upgrade ... Also from your error, you're doing it the wrong way. read the documentation on GitHub

[@ATIPIKEDIT]

where did you get the class "style.py"?

[@SpinnTV]

provide the timestamp

[@ATIPIKEDIT]

I am using QT Creator, in my project folder the style.py file was not created, I did not understand very well where it came from@@SpinnTV

[@SpinnTV]

@@ATIPIKEDIT copy the timstamp from the video so that I can see the exact file youre talking about.

[@ATIPIKEDIT]

@@SpinnTV 28:10, that file.

[@SpinnTV]

@@ATIPIKEDIT Thats style.json. you can create it or use Custom Widgets project maker to create a new project, that will include essential files as shown here kzbin.info9cZeoe1RG6Q?feature=share

[@jiklik6955]

Hi bro , your work os really nice But please i have questions .Is it possible to make Android apps with qt python?

[@SpinnTV]

You can use QT's language QML, am working on making the tutorials

[@jiklik6955]

@@SpinnTV.When will that be?😍

[@SpinnTV]

soon hopefully

[@jiklik6955]

@@SpinnTV .Another question please, what do I need before the course, and will it be during this month?

[@jiklik6955]

@@SpinnTV .Sorry for the many questions 😥

[@derismekentz1]

pyqt is bad... use maybe flutter or electron... trust me i had a project with it in my company... it's horrible

[@rodrigoracr]

what is the song ?

[@CarlosRodriguez-xk9ot]

do i get the code if i join to premium?

[@SpinnTV]

Yes, on Patreon

[@ismailhassan3455]

Please is it free I tried to download from your link Full Source Code Download Link: But I can't find any download link for the file Thank you

[@SpinnTV]

not free, use the other link to get some files

[@ИванПетров-р8ъ5э]

We don't need such teachers. Broke all design patterns MVC

[@WiperElite]

real HD xD

[@fabioorduz3311]

tengo win 11 instalado

[@累得像條狗]

4(80p)K

[@무무무무무-j3s]

26:22

[@saurjayanbhattacharjee9742]

getting an error like this now File "C:\Users\AppData\Local\Programs\Python\Python310\lib\site-packages\Custom_Widgets\Qss\SvgToPngIcons.py", line 194, in generateAllIcons THEME = settings.value("THEME") RuntimeError: wrapped C/C++ object of type QSettings has been deleted Can you help me resolve this?

[@SpinnTV]

that's a system error, not code error. Your system might have deleted QSettings , try it on a different os or pc

[@Greygasm]

Can I install PyQT5/PySide/Qt Designer in a virtual environment with other py files? Thanks.

[@SpinnTV]

Yes you can

[@fredieeevlogs7077]

I got an error cannot loas library ' liccairo.so2': error 0x7e that error as well for libcairo.2.lib.dylib libcairo-2.dll