News for hackers. Stuff that matters.
Re:MySQL - Do Not Pass This Way Again by jeffdavis on Sunday January 27, 2013 @01:33PM (#5125074)
"PostgreSQL is pedantic with data insertion, almost to a fault."

The PostgreSQL philosophy isn't about being "pedantic", but it is very different from MySQL. I assume that you have much more experience with MySQL; maybe you are trying too hard to use postgres in the mysql way rather than the postgres way?

Personally, I don't think it's a good idea to migrate usually for this reason. The entire project development always has lots of built-in assumptions about how the DB will be used, so the new system is almost never quite the right fit. It can only work in trivial cases, or when you have the right expectations.

Re:MySQL - Do Not Pass This Way Again by pippy on Sunday January 27, 2013 @08:55PM (#5126657)
Yes I've been using MySQL in the PostgeSQL way. I learned to use databases using oracle databases, which is similar to MySQL.
Re:MySQL - Do Not Pass This Way Again by jacques_chester on Sunday January 27, 2013 @09:18PM (#5126726)
> oracle databases, which is similar to MySQL.

How did you reach that conclusion?