SQLite operates in the same process as the app. No network overhead, no socket overhead, etc.

The tradeoff is all your eggs in one basket, so to speak.