Hacker News new | ask | show | jobs
by teej 2720 days ago
There’s validated data types and unvalidated data types.

“Our logs are stored as newline-delimited JSON objects.” No, it’s improperly escaped so it’s actually a JSON-like string of unknown character encoding.

“This is a postal code field.” Nope, it’s a user-generated string that occasionally converges on something approximating a postal code.

“This is the user’s IP address.” Well I clearly see localhost in here so unless folks are browsing the site from our servers, this is “sometimes” the user’s IP address.