I see that all the ids used in the engine are stored in db tables as varchar. Is there any specific reason for it. Is it not a performance issue as these ids are numbers and could have stored as BigInt in the database. Can you clarify ?
The reason is because we've got flexible id generators, for example one that supports UUIDs. In the past years, having a string as id has never been a cause for performance problems.
