Hello guys,
i was using the tmdb id as primary key for generating a local film database for my own movies and I used the tmdb id for updating the movie information regulary. But now i recognized that the IDs change over time. I wonder why the IDs are not fix, and if old IDs are assigned to other movies?Then i would have to check every time if the belonging film is correct during updating.
Un film, une émission télévisée ou un artiste est introuvable ? Connectez-vous afin de créer une nouvelle fiche.
Vous souhaitez évaluer ou ajouter cet élément à une liste ?
Pas encore membre ?
Réponse de Travis Bell
le 18 février 2019 à 17h26
Hi there,
ID’s do not change. What you may have seen is a duplicate that was deleted. In these cases, it is TMDb policy to keep the earliest (smallest) ID. Although from time to time, a moderator may have chosen the larger ID to keep.
Réponse de stuhlterror
le 19 février 2019 à 06h04
Thanks for the information. But what about the ID from the deleted duplicated movie? Won't it be reassigned to another new movie in the database?
Réponse de Travis Bell
le 19 février 2019 à 09h10
No problem. No, deleted ID’s are never reused.
Réponse de Matt
le 19 juillet 2024 à 13h40
Sorry for re-opening a long old thread.
I've recently began using this api again after a decent hiatus, and this time around was planning on using the imdb id as the unique identifier for local table storage, but since I discovered this thread, it would be vastly more optimal to use tmdb id instead. In my paranoia though, just want to confirm that this is still the active scenario for ids. That once an id is assigned to a type instance, i.e. this movie id = this movie, that correlation at least for 99% of instances/records will remain linked, and I won't have to worry about the id changing for that movie or that movie changing to a different id....? or.... does this duplicate movie instance occurrence happen often enough (where a new or old id will be deleted in favor of another) that I should remain dedicated to using the imdb id instead for long-term uniqueness in stability.
Thank you
Réponse de Travis Bell
le 19 juillet 2024 à 13h42
Yes, this is still the case. ID's are never reused.
There's not really any way I could say how often duplicate items are created. TMDB is a crowd sourced database, people can create duplicates at any time if they choose to.