Differences between sqlite and postgres for self hosted server

In the self-hosting documentation when mentioning that it’s possible to use either sqlite or postgres, there’s no discussion of the advantages and trade offs between options.

I’m assuming that sqlite is perfectly fine for a small number of users and postgres was chosen for atuin cloud hosting given the requirement for a much bigger number of users but would be helpful I think to add that to the documentation.

By the way, thanks for the amazing tool!