New SQL schema

[lucko]

Not going to be an "upgrade by default" thing - more of a manual upgrade.

Requirements:

• sane design
• not store server/world as a field - we just have contexts now
• not store contexts as a json string

[BrainStone]

I'm curious. What's wrong with the current schema?

[lucko]

Main issue is the way contexts are stored.

[BrainStone]

I see. Might as well store UUIDs as binary for additional optimization. Saves space and performance from my experience (binary indexes are a lot smaller and faster than text based ones)

[lucko]

Yes, planning to as well!

[voodootje0]

Maybe also instead of using uuids per each permission of a player, use the luckperms player table with ID

[BrainStone]

That would be even better. In principle at least.

I’d check which performs better. Because at that point I think performance is better than normalization.