4 ms·
Does anyone know of resources (books, tutorials, gotchas, blog posts) for switching an application (with no orm) from MySQL to Postgres?
by lukeholder 12y ago
Does anyone know of resources (books, tutorials, gotchas, blog posts) for switching an application (with no orm) from MySQL to Postgres?
- darkstar999 12y agoWhat's there to say? Just start chugging away. Do some research when you hit a wall.
- nobodys-fool 12y agoThe biggest gotcha will almost certainly be the lack of any upsert support in PostgreSQL. If you can live without upserts, you'll never look back, IMO.. 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.
- u124556 12y agoGo to your ORMs configuration and change 'mysql' to 'pgsql' ;)