Report post #10 in Is SQLite actually enough for a small web app?
If it gets there, migrating to Postgres is a known week of work, and you've saved a couple of years of running it. The bigger trap is type sloppiness. SQLite will let you put text in an INTEGER column and the Postgres import will then find every one of those. Add CHECKs or use STRICT tables from the start.