The Movie Database Support

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.

5 erantzun (1(e)tik 1. orrian)

Jump to last post

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.

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?

No problem. No, deleted ID’s are never reused.

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

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.

Can't find a movie or TV show? Login to create it.

Global

s focus the search bar
p open profile menu
esc close an open window
? open keyboard shortcut window

On media pages

b go back (or to parent when applicable)
e go to edit page

On TV season pages

(right arrow) go to next season
(left arrow) go to previous season

On TV episode pages

(right arrow) go to next episode
(left arrow) go to previous episode

On all image pages

a open add image window

On all edit pages

t open translation selector
ctrl+ s submit form

On discussion pages

n create new discussion
w toggle watching status
p toggle public/private
c toggle close/open
a open activity
r reply to discussion
l go to last reply
ctrl+ enter submit your message
(right arrow) next page
(left arrow) previous page

Ezarpenak

Elementu hau kalifikatu edo zerrenda batera gehitzea nahi al duzu?

Saioa hasi