Change Google made that may have consequences

hello -

i had an Auth0 node application suddenly start crashing. it turns out that i am trying to “store” the login information like email, name stuff, etc.

i also save the picture value. previously my MariaDB table was a varchar(256) null setting. i had just naively assumed that 256 was far larger than anything that google would ever return.

WRONG!

the following is what was returned below, and i am NOT making this up. it appears that when its just a logo, its like the logo is somehow “encrypted” right in the URL.

or is this something that everybody else learned in grammar school and i was asleep that day? (rhetorical question…)

https://lh3.googleusercontent.com/a-/AOh14GjWzWQjsQLpCMkmFoPsNAxpj8YG_mPfnd-zJKByVXhB-zZfX8ySrW6Oa-a11QJZjwCaPxyl15jCWxZ5NHYaoP6RLLAtjIf2zCf-5R92ADe2yzS_UsX0nNeXMK4Yx1aEjhXmwgukFkw8PRsc0FCBZ0iN9NUju-jsgOroFx7jpAN26yp1N9Axyc0eTYpq03HKi09iMZKgKjtEQO2KNe2858A55FplypWsyjfLTcJm0Sc8gjlclbErKn2jaYe4_vPMjXD2xLG0Yumq1-i-Zsnbn3S6Mrj4K3Z_cUW70eInzG8JZmXAoz8ZgEEBHzF-PsdvabRJG2lNCffzd3e7BkqPSIbCU0Isy3-HJ_lNXrfrsufoPsCBpPlfR7N4El-nG1Hk7Y9TGq0tuILwnDwZV2bPTixJ6TrStuuajDulvewWvIptliif3RmEDCvndKvrjMRDEQGV085dOw4KspGBeyFJUhFWjm84fdbPL5BPonCZ1WoWbhqQAH9F_texxGTZcl-9j6TLE24_wvoWLgSd9ia0aGnwGDWdYSKjh-XB6_-RNJDWoFPtQ_fdk9XKxK3tleE19nGZbydWLswxS3uGg8XnwJBHYtYEdGDT5pI6GE9op-9I-90_Amcawtwwom6dJMEyzh2fTeHsIxDsoZh3d7WdIRDz1FglAmGczU8HGT9uEauXelHc44MvWYW1YUbGvLwyyZW9EVykMkUXhGedS9u-oHKoBjpdG4BNKOQg47Wh1qVAny3ZyIhjWhROa9vXTcnHWBHHIQ=s96-c

Sometimes we assume too many things, right?

If you want to store URLs, I would say limiting the length to less than 2048 chars is way too risky. At least this way you would be supporting the majority of URLs out there.

Ale - i don’t mind storing it, but please don’t ever ask me to type it out.