Can I create a strapi project with sqlite but deploy with postgresql?

I feel postgres a bit hard to configure locally but is it possible to use strapi with sqlite locally which comes by default and when Im ready to deploy, deploy the database on heroku and use the db credentials from there without having to install postgres locally?

Yes that’s completely possible and Strapi is setup in a great way to deal with this.
See here for more details:

You need to set up your different environment folders and include the database file in each. So for your sqlite you would have
./config/env/development/database.js ( with sqlite details )
and for your production environment
./config/env/production/database.js ( with postgres )

hi the link is 404 could you help us find the resource or elaborate? thank you!