1

As today (17-Nov-2018) There are fewer than 7-and-a-half thousand IMDB numbers left, right now we seem to be up to number nm9993694.

Further, they're disappearing fast:

Last Sat (10-Nov-2018) https://www.imdb.com/name/nm9991465/
This Sat (17-Nov-2018) https://www.imdb.com/name/nm9993694/

A quick calc gives us a few weeks at the most before it ticks over above 10-million.

There seems to be a fixed number in their db because the following exist:

https://www.imdb.com/name/nm0000001/
https://www.imdb.com/name/nm0000002/

I was wondering if anyone has any insight in to what happens to their numbering schema in a few weeks?

I'm going to guess it will go to: https://www.imdb.com/name/nm10000001/ but I'm curious if anyone actually knows.

closed as off-topic by Paulie_D, A J Nov 17 '18 at 1:52

  • This question does not appear to be about movies or tv within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

  • What indication is there that they only can support 10 million pages? – DeeV Nov 16 '18 at 22:34
  • 2
    I'm voting to close this question as off-topic because it's about the functioning of a 3rd party website and not about Movies & TV appreciation. – Paulie_D Nov 16 '18 at 23:15
  • Paulie_D, no worries. Thanks for the explanation. I thought it was interesting and thought others might appreciate this Movie Database milestone. Sorry for posting this incorrectly here, I'm just unsure as to who else would be interested in this minutiae. In a short time the question will be redundant anyway. Not the best introduction to this SE site, but that's the way it is I guess. Cheers. – Williams Nov 16 '18 at 23:41
  • 1
    @DeeV: The fact that "/nm0000001/" is a valid reference but "/nm000001/" and "/nm00000001/" are not. – Williams Nov 16 '18 at 23:44
1

I do not work or develop for IMDB nor do i know how their database is structured

i think the number will just increase. you see given that these seems like unique numbers it is most likely just using an INT on the database.

if we use this UTF-8 byte calculator we see that any number between 0000001 and 9999999 is 7 bytes, however as this SO Answer indicates

It depends what is the character and what encoding it is in:

...

  • A Unicode character in UTF-8 encoding is between 8 bits (1 byte) and 32 bits (4 bytes).

and this if of cause assuming that the number is being stored as a UTF-8 string.

on the other hand, assuming that IMDB uses Microsoft SQL (T-SQL) there are 4 choices of INT Datatypes, tinyint, smallint, int and bigint. since best practice is to use the smallest size possible for your expected data and the numbers are 7 digits, if we make the assuming that the numbers in the URL are an INT then we can see that IMDB is probably using

int |   -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) |    4 Bytes

this mean their max ID would not be 9,999,999 but 2,147,483,647. and this would be smaller as the string 2147483647 which is 10 bytes using our calculator above

but then why would it start at 0000001 as opposed to 0000000001? i don't know. the site does 404 if you try https://www.imdb.com/name/nm1/ but if we add 0's to the start like

they all work. but as soon as you drop bellow 7 digits it will start to 404. i also don't know if https://www.imdb.com/name/nm0000001/ will stop working all of a sudden but a good web admin would set up a 301 Redirect for those who might have the page bookmarked or cited as a reference

  • Ah yes, redirects might come in to place. Thank you! – Williams Nov 16 '18 at 23:45

Not the answer you're looking for? Browse other questions tagged .