How does SN host wallets for every user? Is it just a DB tracking users holdings or do you actually host a wallet for every single user? If the latter one is true, could you elaborate on how this works?

Not sure if this is something you want to keep secret or discuss openly but as SN is OSS I guess it's not a secret really? I tried to look at the source code for an answer but I still don't understand how it works.

If anyone else have any tips on tools/solutions for hosting LN wallets for others on the same LN node I'd appreciate a link or a name I can search for.