What they mean by that comment is that it doesn't have users in the sense that mysql, SQL Server, etc have.
https://www.sqlite.org/whentouse.html
The documentations says that it works well for websites. For client server, you just need to make an API that handles the interactions with the database.