Seeking advice on Heroku db parity

[Jay Martin]

According to this Heroku article, subtle differences between Postgres and Sqlite may cause hard to troubleshoot problems when using Sqlite locally and Postgres in production.

Web2py includes a script "heroku.py" that uses a Sqlite db for local development. 

I'm curious if anyone has tried using Postgres for local development and whether it created more problems than it intends to prevent. Is there anything about web2py in particular that would caution me against following Heroku's recommended best practice?

Thank you for any experience or advice!

My best,

Jay