Does anyone know of resources (books, tutorials, gotchas, blog posts) for switching an application (with no orm) from MySQL to Postgres?
MySQL has a much better GUI based query browser than anything I've seen in the postgres world. Postgres has a very good command line query tool though.
But yeah, no upserts.