The Movie Database Support
Support → API-support
How does Letterboxd store TMDB movies?
Inlagt av loupqhcSTAFFMOD den 29 oktober 2023 vid 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 !
Svar från superboy97
den 29 oktober 2023 vid 12:34 PM
You will have to ask this to Letterboxd. Only them know what they do.
Svar från loupqhc
den 30 oktober 2023 vid 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 ?
Svar från Travis Bell
den 2 november 2023 vid 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.
Svar från loupqhc
den 21 december 2023 vid 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 !
Svar från superboy97
den 21 december 2023 vid 12:45 PM
When the data about a movie change, its Id doesn't change.
Svar från loupqhc
den 21 december 2023 vid 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
Svar från Travis Bell
den 21 december 2023 vid 4:13 PM
When an item is created, the changes are tracked, so yes, that ID will show up in the change list.
Svar från loupqhc
den 2 januari 2024 vid 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...