I recently dealt with the differences of UUID versions (especially v4 and v7) and wondered whether it is possible to use v7 UUIDs for the auth.users table in order to reduce index fragmentation. Currently the ID seems to be UUID v4.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.