Re:Listen to your to PostgreSQL database in realtime via Web...
by skyde on Thursday May 06, 2021 @12:41AM
(#27059224)
you can have "id" Generatable at application level without using GUID.
This is what twitter is doing "snowflake".
It generate tens of thousands of ids per second.
Those id fit in 64 bits.
And those id are sortable, meaning that if tweets A and B are posted around the same time, they should have ids in close proximity to one another.
It generate tens of thousands of ids per second. Those id fit in 64 bits. And those id are sortable, meaning that if tweets A and B are posted around the same time, they should have ids in close proximity to one another.
See: https://blog.twitter.com/engineering/en_us/a/2010/announcing...