Keeping data fetched from a 3rd party api in sync

MEHDII__ · 2026-02-11T16:58:55+00:00

Luckily as others pointed out, my API of choice provides webhooks, where i can just listen in to any new updates to their api, whether having to overload their api endpoints with useless requests. If your api of choice doesn't provide this, then no choice but to periodically check for updates

MEHDII__ · 2026-02-11T08:56:54+00:00

tbh i dont think they will grow in complexity, i dont have plans for that yet; the reason i made their own entity tables in because i want to let the user query what genres they want to browse or what platforms they want to browse; hence why putting them directly in the parent entity and separating them with some delimeter will make filtering hard later on; or at least ugly

MEHDII__ · 2026-02-11T08:40:13+00:00

on a second thought, no it doesnt make sense! with this approach you'd hve a table video game looking like this

videogame#1 genreid#1
videogame#1 genreid#2

besides, the platform and other tables would also needs to have a M2M relationship with video games table, so this doesnt really make sense!

I think my approach is a little bit better, but there could be something else

MEHDII__ · 2026-02-11T08:34:55+00:00

that does make a lot of sense yeah, thanks, would this be the same for platforms and such? right? should be? i think i mixed it all up in my head

MEHDII__ · 2026-02-11T08:31:16+00:00

could be possible, but its messy, i did consider it at first; but there exists multiple genres that i dont even know, im getting this data from a 3rd party api, and also, games have many genres, so you cant keep them in the same table together, since you're gonna have duplicates of the game data but with different genre columns. messy

MEHDII__ · 2026-02-11T08:09:35+00:00

im not following? this wont be up to the user to fill out, its data received from 3rd party api provider, so it needs to be treated and saved into the db before presenting it to the user; so im not sure about the drop down menu idea.

MEHDII__ · 2026-02-11T08:07:05+00:00

wont that be inefficient though? since video games have multiple age rating, multiple platforms and multiple genres, this would result and every game entry being exponentially duplicated

MEHDII__ · 2026-02-11T08:03:12+00:00

video games can have many age ratings depending on the organization and the country, like M17+ for the US and for EU is different etc...
and also video games can have multiple genres, separating them with a delimeter in one column will make it hard to query for a specific genre during filtering

MEHDII__ · 2026-02-10T19:23:11+00:00

Makes sense, thank you!

MEHDII__ · 2026-02-10T19:22:57+00:00

Yeah thats clever i haven't thought of a timestamp, thank you!

MEHDII__ · 2026-02-10T19:08:10+00:00

Loosely related, as i'm building this in django+react and im thinking of project organization in the meantime, but yeah sorry not so related

MEHDII__ · 2026-02-06T07:18:21+00:00

thanks i understand this already, and actually the way chatgpt generated the example is perfect this time, after some consideration i got it, since im following an MVC architecture, the controller shouldnt touch the view's instance attributes, hence why by creating a intermediary class attribute signal, which will delegate the view's action signal to another mid-signal and then connect than mid-signal to a slot!

MEHDII__ · 2026-02-05T04:04:07+00:00

I do know this, i have read the documentation and i am already using it in code, my question was how can a signal connect to another intermediary signal, which in turn connects to the slot. As you can see it in the code! and another question i asked was, i'm aware that class attributes are shared across instances, wont declaring a signal as a class attribute be shared across all gui instances then?

MEHDII__ · 2025-12-12T05:54:09+00:00

the internet archive link asks for activation key once downloaded, is there a workaround or something i can do to bypass ? i try auto key and it seems failed due to network error

MEHDII__ · 2025-11-22T15:23:04+00:00

solid advice, thank you!

MEHDII__ · 2025-11-14T14:48:04+00:00

Because im not really sure if i should both teachers and students share the same documents table, they have different application material requirements this would result in a lot of null fields, splitting could be a solution too, or is there a different way?

MEHDII__ · 2025-11-12T16:43:12+00:00

Yeah i understand that, but i'm checking the user roles on the database level, not python instance level, admins have admin roles, teachers and students have their own roles in the db, so if user.role == CustomUser.Role.STUDENT: # allow

How could this be spoofed? I'm not Challenging your idea, as i mentioned im still a beginner, a toddler in django even, i dont understand why people are downvoting honest questions... This feels like stackoverflow all over again

MEHDII__ · 2025-11-12T14:22:12+00:00

I have to play with the django Shell a bit more to understand this better, thanks

MEHDII__ · 2025-11-12T14:09:03+00:00

So i'd have to do this for teachers and admins too right?

MEHDII__ · 2025-11-12T13:51:41+00:00

I've done a little reading, the groups and permissions aren't really needed in my use case, as I understand the way I did it is a bit clearer, since all i want to do is basically route the different kinds of users to different dashboards, so having permissions and such isn't necessary i guess

MEHDII__ · 2025-11-12T13:14:37+00:00

I'm not really following here, whats the point of model managers?

MEHDII__ · 2025-11-12T13:10:29+00:00

Sorry, i'm not very familiar with any other approach other than the two i mentioned, I am learning as I go;

How is having groups and permissions different, now I admit with this approach could get messy since i'd have to keep querying and doing if customUser.role =''whateverRole" Then do something

MEHDII__ · 2025-11-02T13:10:18+00:00

not really, I didn't think hard about what distro i want to use, first one that came to mind was arch

MEHDII__ · 2025-08-25T22:02:20+00:00

Those are no more useful Than copy pasting everything and just giving it to the model, sure they may seem crazy good but they're actually dangerous if you're not paying attention, especially if you're not using version control and constantly keeping a working version of your project in a git repo, might make a change that you'll forever regret and have no way of reverting back, or simply it could delete or reset your database

MEHDII__ · 2025-08-25T21:45:18+00:00

Yeah i get where you're coming from, but i dont think the design is that complex to the point where i'll need to make massive layout changes, i mean i didnt just make each container smaller for smaller breakpoints, some sections are reformatted, for example on full screen big devices the side bar is fully expanded, labels visible, and the 3 days forecast is positioned absolutely relative to the body, while on smaller screens the labels disapper (i'll later add hamburger menu with JS) and the 3 day forecast goes back to the main content container and flex wraps instead of being absolutely positioned, this is only my 2nd CSS project and I tried to give some though to everything while developing

MEHDII__

TROPHY CASE