Why sqlite is not good for live sites?

I have seen that many people say that sqlite should not be used for production sites because it's slow, and that mysql or some "server" should be used.

I don't get it, how are the others different? Don't they store the data in files, just like sqlite?