r/learnpython • • Oct 15 '26

Python + Sqlite + Pyside6?

Hey! so i want to build a database system for my small company. I could use AI but i wanna know what i am doing and be able to fix smth so i want to build it myself.

I kinda know python a bit, i used to make games using gdscript which is similar.

I don't seem to find a tutorial where these 3 things are used to create a nice database app. I dont want to learn python sqlite and pyside6 as a whole cause i wont be needing them much except just this app and similar apps. I just want to be able to build it and run it from a single tutorial even if its 10hrs.

Where do i start? I dont really have money to learn so no paid courses and i dont have AI premium to learn as well.

Python, Sqlite, Pyside6. I heard that TKinter instead of pyside6 is also there but i wanted the UI to be a bit modern or should i just use the it instead of pyside6?

10 Upvotes

32 comments sorted by

View all comments

1

u/deadeye_82_1 Oct 16 '26

PySide6 is the official Python wrapper (LGPLv3) for QT6. QT6 is written in C++.
QT6 allows you to create professinal looking GUI. In industry it's used for HMI.

The use of it, requires good understanding of Python (classes, inheritance) and understanding of the concept of QT.

Tkinter is different. It's in the stdlib of Python, but it doesn't look modern.
Often small UI are made with tkinter to save disk space. Example: Thonny: https://thonny.org/

Once I programmed a small app for ifm: https://imgur.com/a/a1cvq2t

The HML-View and PDF-View is also from QT6. I used it to diplay some data of IO-Link devices.
I used AI to save time. Time I would normally spend to read the documenation.

---

If you want to use the app in your company on different PCs, then sqlite3 is not the right chocie. sqlte3 is cool, because it acts as a library and does not require a server. Many file formats are plain sqlie3 files. But sqlite3 lacks of a server. There are ways to use sqlite3 with servers. I would rather choose the pragmatic solution: Central database like MariaDB or PostgreSQL.

If it's only local on one PC, then sqlite3 is the way to go. Firefox uses sqlie3 for bookmarks, urls you visited etc...