Shift to Postgres from Airtable

[manishapriya94]

Purpose: Shifting from Airtable to Postgres for scalability and best security practices.

DATABASE_URL = API Variable

• 1. Provisioning Postgres on Heroku
• Connect Postgres to Heroku
• Migrating data from Airtable to Postgres
• Populate a postgreSQL database on Heroku

[manishapriya94]

Should I look into actions @BeeXiong to automate the upload?

[BeeXiong]

Having an issue importing from a .csv into a local postgres DB. The file path is correct I believe but the SQL command can't seem to find it. Any Ideas??? @manishapriya94 @teakopp

I was also able to get a Local DB to push into the Heroku environment but it still looks like there could be issues with credentials. Can't tell for sure but looks like Heroku could be overriding the users on the DB.