Personal preference. I'm only using sqlite for testing, because I can create an in-memory database with it, which I can't to with postgres, and I only chose that because it's what Heroku uses and I wanted to use the same database in development as I was in production.