The Movie Database qoldaýy
Qoldaý → API qoldaýy
How does Letterboxd store TMDB movies?
posted by loupqhcSTAFFMOD on 2023 Qazan 29 at 11:56 AM
Adding new ones and removing old ones through Daily ID Export is straightforward. But updating movies if TMDB changes? That's over 900k requests to compare with their database. Also, they show actor pages, etc. Does this mean they store over 3 million TMDB people too? How's it possible to update ALL info every 30 hours?
Thx for your help !
superboy97 jaýaby
2023 Qazan 29 kúni 12:34 PM ýaqytynda
You will have to ask this to Letterboxd. Only them know what they do.
loupqhc jaýaby
2023 Qazan 30 kúni 11:56 AM ýaqytynda
Hello, thx for ur response. In fact they probably store all movie and person. I wanna make something similar but I was wondering if we can access to the TMDB database schema to see how organize my database to be fully compatible with the TMDB one ?
Travis Bell jaýaby
2023 Qarasha 2 kúni 1:14 PM ýaqytynda
They don't update all of the info every 30 hours. I believe they are staying in sync with the change system. You can read about that here.
loupqhc jaýaby
2023 Jeltoqsan 21 kúni 12:32 PM ýaqytynda
Sry for late, didnt received notification. Well the change system seems to be very usefull. In the list of movie changed, there is the new id ? And sry to re-ask, but there is a way to find the TMDB database schema ? Because I wanna have the same schema as TMDB to be sure everything is consistent. I also dont how how TMDB manage the i18n of the query (i wanna have english and french support language in my app).
Thx again !
superboy97 jaýaby
2023 Jeltoqsan 21 kúni 12:45 PM ýaqytynda
When the data about a movie change, its Id doesn't change.
loupqhc jaýaby
2023 Jeltoqsan 21 kúni 2:15 PM ýaqytynda
No I mean is a new entry in database (like a movie, or a person, ...) is considered as a change ? Just to see if we also have to check the Daily Export IDs
Travis Bell jaýaby
2023 Jeltoqsan 21 kúni 4:13 PM ýaqytynda
When an item is created, the changes are tracked, so yes, that ID will show up in the change list.
loupqhc jaýaby
2024 Qańtar 2 kúni 10:16 AM ýaqytynda
Okay so Ive setup m y schema in my database to store all TMDB data. But now the problem is how get the entire TMDB database. For the "person" table, there is around 3 millions of entries, with a python script its gonna take around 400 hours, 20 days non stop for getting only person table. Is just not possible. But how can I get all entries without doing this ? Its could be so cool to download directly from TMDB. If anyone got a solution...