4 ms·
If you do this in your application code, you can just store it as a 64 bit integer in postgres and optimize your index significantly, instead of using a varchar
by sundbry 6y ago
If you do this in your application code, you can just store it as a 64 bit integer in postgres and optimize your index significantly, instead of using a varchar as the backing data type. These ids pack just right into 64 bits.
- hultner 6y agoCould it be backed by a 64bit integer while still exposing it as a well formatted code without relying on application layer intervention.