4 ms·
I was debating between using ULID vs just using the same sequential bigint sharding strategy that Instagram uses[1][2]. I ended up deciding to use sharded bigi
by fatsdomino001 5y ago
I was debating between using ULID vs just using the same sequential bigint sharding strategy that Instagram uses[1][2].
I ended up deciding to use sharded bigints because it enables better indexing, even though there are drawbacks when first writing the instances; The benefit of faster search was more important for me.
[1]: https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5c?gi=6005eb19ff95 https://instagram-engineering.com/sharding-ids-at-instagram-...
[2]: http://www.livinginthepast.org/2016/02/24/sharding-into-bigints.html# http://www.livinginthepast.org/2016/02/24/sharding-into-bigi...