Podpora The Movie Database
Podpora → Podpora API
How does Letterboxd store TMDB movies?
posted by loupqhcSTAFFMOD on oktober 29, 2023 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 je odgovoril
dne oktober 29, 2023 ob 12:34 PM
You will have to ask this to Letterboxd. Only them know what they do.
loupqhc je odgovoril
dne oktober 30, 2023 ob 11:56 AM
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 je odgovoril
dne november 2, 2023 ob 1:14 PM
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 je odgovoril
dne december 21, 2023 ob 12:32 PM
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 je odgovoril
dne december 21, 2023 ob 12:45 PM
When the data about a movie change, its Id doesn't change.
loupqhc je odgovoril
dne december 21, 2023 ob 2:15 PM
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 je odgovoril
dne december 21, 2023 ob 4:13 PM
When an item is created, the changes are tracked, so yes, that ID will show up in the change list.
loupqhc je odgovoril
dne januar 2, 2024 ob 10:16 AM
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...