3 ms·
I remember, waaaaay back in the early days of PostgeSQL, I was using it for project and it crashed in a way that corrupted our data. There was no hardware probl
by garyrob 2y ago
I remember, waaaaay back in the early days of PostgeSQL, I was using it for project and it crashed in a way that corrupted our data. There was no hardware problem; it was just a database crash. (This was quite some time ago. I don't recall what year it was but I'm 68 now and have been a programmer since my senior year in college.) I switched to MySQL for that project. I assume PostgreSQL is not remotely prone to anything like that anymore!
- zie 2y agoIt can still happen sometimes, but it's very rare that it crashes and even more rare that it corrupts as well. The good news, the chances of it corrupting your data silently was basically zero, then and now. However back then MySQL seemed like it went out of it's way to corrupt your data. The only "bonus" is, it did it all silently, so nobody ever noticed until they went looking. With MariaDB(the successor) it's pretty rare that it silently corrupts your data these days.
- garyrob 2y agoCould be; but it never happened to me with MySQL! Maybe it depends on on how far back in the day you go...? :)
- djbusby 2y agoI'm using PostgreSQL since 2002. Never lost anything.
- int_19h 2y agoAround early 00s, it was already common wisdom among the web devs that, when it comes to free RDBMS, if you want speed, you use MySQL; and if you want consistency and reliability, then Postgres is where it's at. (Most people wanted speed.)
- zie 2y agoDid you ever go looking for corruption? :) Most people don't.
- garyrob 2y agoThe database couldn't be used anymore! Pretty severe corruption.
- jjeaff 2y agoI believe a lot of that can be tied back to the default switching from myisam to innodb. crashes frequently resulted in corrupt tables with myisam. innodb is very good at recovering.
- osigurdson 2y agoIt is rock solid now.