5 ms·
Strings have their own issues. One place I worked had a bug where users could take over accounts because of missing/inconsistent unicode canonicalization. Case
by dehrmann 6y ago
Strings have their own issues. One place I worked had a bug where users could take over accounts because of missing/inconsistent unicode canonicalization. Case can be a problem, as can special characters.
There's something to be said for strings, though. Prefixed IDs that mark the type can be nice to work with when it's an otherwise opaque ID, but they're a pain to handle internally.
If you're storing third-party IDs, you probably want strings...unless their clever JSON API returns 1.3E6 as a number. Or the string "null;" that's always an adventure.
- fiddlerwoaroof 6y agoIDs should really be their own type: string operations don’t really make sense on them. If you use strings, there should probably be a constraint on the acceptable characters and lengths: e.g. only digits, exactly 10 or something like that. I personally like the idea of using urls using a domain you control + a path that reflects the type of data it’s an ID for.
- naniwaduni 6y agoTo be fair, string operations don't usually make much sense in general.
- katbyte 6y agoazure does this for resource IDs and its one of the few things i really enjoy about the platform.
- ivanb 6y agoIf the main benefit of prefixed IDs is debugging then a dev tool can be created that would just look up the ID in all tables and report what object it corresponds to.