SimonXIX’s avatarSimonXIX’s Twitter Archive—№ 46,969

  1. "I want to make a table in this database containing all the ISBNs. How many ISBNs do you reckon there are in the world? A few thousand?" - an ambitious developer in my team.
    1. …in reply to @SimonXIX
      Did you know that the original 9-digit SBN code was created primarily for WHSmith to make it easier for them to sell books?
    2. …in reply to @SimonXIX
      To his credit, he's done it. The SQL extracts the ISBNs from the MarcXML records in the database and puts all our ISBNs in a separate new table so they're easier to work with. We decided to set the upper limit for the sequential control no. at 20,000,000 just to be safe.