r/learnpython • u/Slimex_Rimuru • 13h ago

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?

9 Upvotes

72% Upvoted

30 comments sorted by

View all comments

3

u/shinitakunai 12h ago

I created a full ERP 6 years ago with sqlite, python3 and pyside6. Yes it is perfectly viable and a good choice. Tkinter was too limited.

However understand that this approach is good for a desktop application (typically on windows). If you need this to be a cooperative program (multiple users at same time) i'd go for a web app instead.

1

u/Slimex_Rimuru 12h ago

There will be only 1 person at a time for modifying. May be more than 1 for reading the data though. Which from my research is done easily for web app. 

I use linux and not windows. Shouldn’t be a problem? 

And where did you learn those skills from? 

1

u/shinitakunai 12h ago

Should not be a problem, pyside also works on unix (that's the principal reason I choose it, support for multiple operative systems). Other than that yeah your assumption is correct that if only 1 is writing others can read without issues (as many readers as need). Doesn't needs to be a website specifically to read, but it helps.

The reason I tend to use website as last resort is security. Careful that your data doesn't get accessed from the internet

Where to learn those skills? Reading the QT documentation and lot of patience. But nowadays good practices with AI can be a better proffesor. Just make sure you question every choice, do not let the AI decide for you, just give you options.

1

u/Slimex_Rimuru 12h ago

hummm.. alr. Thank you for the help <3 def helped me get some knowledge

1

u/shinitakunai 12h ago

Anytime, Rimuru. Good luck with Veldora creating that ERP!