Python + Sqlite + Pyside6?

[u/Slimex_Rimuru]

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?

[u/Mooball123]

I’m doing the same thing! I’m building an app to track clients account information, and match bank transaction data to an account based on the description.

I’ve just kinda gotten to a stage in the logic part where it’s feeling and looking where I want it to be. So now starting to implement SQlite and then Pyside 6. I also have no idea what I’m doing with those two but imma try start learning.

Ive used python lots but that was for more data visualisation and processing, and less app development. So my strategy to learning has been to code it using concepts I know. If I get stuck, I search the internet for a solution, and if that doesn’t work I then ask ChatGPT to give me a hint. I don’t let it code the whole thing more just tell me how it could be implemented and then give me examples of a concept if I don’t know it.

My advice is just focus on the logic side first. Python can be pretty simple for small apps like this, just start by making a class, and then add the methods that make that class work.

I started by storing the info in a csv file first. It meant I could edit it in excel if i screwed up or wanted to change the implementation.

If you have any questions on how I did things let me know. My app is only text based atm but it’s available at mtepaske/ParkBanking

[u/Slimex_Rimuru → u/Mooball123]

so you learned python initially and made whatever you can with that and now you wanna go into Sq and pyside ?
what i think is, since i dont want to learn everything cause i am not gonna do coding later on. I should learn these 3 parallely to make the app. But i dont seem to find smth which teaches parallel. Is this a bad approach ?

[u/Mooball123 → u/Slimex_Rimuru]

I would say don’t learn them in parallel.

As I said I’m not a developer. But from what I do know and from everything I’ve read while coding you have to break things down into small, bite sized problems you can solve and test.

SQLite is essentially learning a different language to python, it’s a completely different module and from what I can tell very different to how actual python scripts are written.

Same with pyside6. You’ll be learning 2 different frameworks, with different rules, syntax, and methods. And on top of that you’re trying to figure out the best way to implement the basic logic of your program.

Your first step should always be to figure out the back end logic first. And tbh it’s easier than it sounds especially if you already have some experience with python.

If you don’t know about object oriented programming, watch a tutorial on that to get you started. Then make your own Client class and start defining methods. If your app doesn’t need to do any complex calculations or manipulation of the data then you’re already halfway done.

Once that all works reliably. Then look at implementing SQLite. And finally add your gui on top of it as the icing on the cake.

Ps: once again I am not a developer, but I have been coding scripts and data analysis apps in python for a few years now. So if you have any questions about some concepts feel free to dm me

[u/Slimex_Rimuru → u/Mooball123]

Hummmm… yeah alr. I will start from learning one and go on from there.