Use snowflakes

[spotlightishere]

It's been discussed to use snowflakes.
Observe the following:

If we used a snowflake, we could strike mail_id and timestamp out with one INT(18).

[spotlightishere]

https://github.com/bwmarrin/snowflake seems like an extremely good candidate.

[spotlightishere]

This would still be nice to have. We potentially could eradicate meaningful message IDs. A migration plan should be made.

[Artuto]

[Artuto]

Thats not even what it was suggested for

[KcrPL]

What kind of sorcery is this?

[larsenv]

What a great way to revive an issue that was made 2 years ago. 🙄

[larsenv]

By the way, snowflakes suck. Although we don't use it, each piece of mail has 2 UUIDs to associate the mail with, so we don't really need snowflakes.

[spotlightishere]

Primarily, snowflakes (if used) would coincide best with #5 and #6, in which the mail system formulates mail to be delivered, stripping most user-provided content that could be abused (i.e. various headers). Obviously this was never implemented, but it may be worth keeping it open or mentioning within #5 as a design hint in case such ever happens.