Comment by dewey
Especially if you use any of the features that make Postgres nice to work with (For example good jsonb handling) these are immediately different than on sqlite and then won't work for development. Don't think there's a good reason for not running the same DB in both environments.
You dont even need to look into advanced features; sqlite does not support ILIKE.