Using Postgres with Rails


#1

Hi - i was using sqLite as standard development tool but found that when pushing to production (PG on Heroku) I would find issues in migrations as sqlite was more forgiving than PG and also complex SQL queries specifically collections required different clauses etc

so firstly is there a way to make SQLite to respond as PG would

OR

what would be the procudeure for using PG as my development database as well ?

I tried just altering my gem file and looked in my ENV but cant see where its specified


#2

Found this…

resolved