Here is an in-depth area where I need development/knowledge help, for a feature that would make Masto even better/more reliable in terms of timelines sorting: https://github.com/tootsuite/mastodon/issues/1059 I've been researching it for a while and wrote down all my findings.
@Gargron Can sidekick workers know their PID? that could be a good n to put into snowflake ids
@timotimo I have not found an API in their code that would provide this information. Also, multi-host setups. You'd require the sysadmin to set some env variable to index the various hosts in the cluster as well.
@Gargron i forgot for one short moment that distributed computing is hard :)

@Gargron I'm friends with a lot of people who've worked on social networks at extreme scales. I'm passing this request around to them.

I have my opinion too, I'll offer it there.

@Gargron left a comment. It's an interesting space for sure, yay distributed systems are hard.

One other thing that comes to mind is Google's Spanner, which solved distributed time conflicts by treating time as a range value rather than a simple integer. Their solution was to solve for global linearizability, may be something to learn there?