4 ms·

I can't understand why anyone would start a project with Mysql instead of Postgress.

by lazyant 16y ago

Roboprog 16y ago
I can: my cheapie hosting service only provides MySql. But beyond that, no. I certainly prefer PostgreSQL at home, and would use it for other projects when I could. MySQL was simply too late to the "ACID party", and it's hard to believe they took data integrity seriously. E.g. - transactions, isolation, referential integrity and other feature were too long coming. They did provide a free portable DB that ran on Windows early on and parsed SELECT statements, though :-)
- jasonlotito 16y ago
  > transactions, isolation, referential integrity and other feature were too long coming. They had that years ago using InnoDB. I remember using it in 2003. MySQL's big thing over Postgres was replication.
  - lazyant 16y ago
    My perception is also that replication was lately the only advantage Mysql had over Postgres in general. My main problem with mysql is that I have seen too many data corruptions and I can't find anyone who has worked with both systems and doesn't recommend in general pg over mysql.
    - moe 16y ago
      FWIW, Dead-simple replication is in the current postgres beta and due to enter stable soon. Here are the docs: http://developer.postgresql.org/pgdocs/postgres/hot-standby.html http://developer.postgresql.org/pgdocs/postgres/hot-standby.... Oh, and unlike the MySQL replication this implementation can not silently lose or corrupt data. In fact the above document could also be considered "The missing Manual for MySQL replication". It tells you all the things that MySQL doesn't take care of.
- lazyant 16y ago
  I can't understand why somebody wouldn't use a VPS ;-)
  - stesch 16y ago
    I have a VPS and I can understand that some people don't have a clue how to admin a server. Maybe that's the reason? I don't think I'm an uber admin. I just try to use so few services as possible and update my shit. Hopefully this is enough.

I can't understand why anyone would start a project with Mysql instead of Postgress.

by lazyant 16y ago

I can't understand why anyone would start a project with Mysql instead of Postgress.

I can: my cheapie hosting service only provides MySql. But beyond that, no. I certainly prefer PostgreSQL at home, and would use it for other projects when I could. MySQL was simply too late to the "ACID party", and it's hard to believe they took data integrity seriously. E.g. - transactions, isolation, referential integrity and other feature were too long coming. They did provide a free portable DB that ran on Windows early on and parsed SELECT statements, though :-)

jasonlotito 16y ago
> transactions, isolation, referential integrity and other feature were too long coming. They had that years ago using InnoDB. I remember using it in 2003. MySQL's big thing over Postgres was replication.
- lazyant 16y ago
  My perception is also that replication was lately the only advantage Mysql had over Postgres in general. My main problem with mysql is that I have seen too many data corruptions and I can't find anyone who has worked with both systems and doesn't recommend in general pg over mysql.
  - moe 16y ago
    FWIW, Dead-simple replication is in the current postgres beta and due to enter stable soon. Here are the docs: http://developer.postgresql.org/pgdocs/postgres/hot-standby.html http://developer.postgresql.org/pgdocs/postgres/hot-standby.... Oh, and unlike the MySQL replication this implementation can not silently lose or corrupt data. In fact the above document could also be considered "The missing Manual for MySQL replication". It tells you all the things that MySQL doesn't take care of.
lazyant 16y ago
I can't understand why somebody wouldn't use a VPS ;-)
- stesch 16y ago
  I have a VPS and I can understand that some people don't have a clue how to admin a server. Maybe that's the reason? I don't think I'm an uber admin. I just try to use so few services as possible and update my shit. Hopefully this is enough.