Yeah, MySQL could definitely be improved upon. The table-level write locking is a pain. I was just saying that 100% consistency/data integrity isn't really a major concern for a lot of applications.
I've thought about switching to Postgres, but it doesn't currently appear to be worth the pain in my case.
Yeah, I know, our conversation about read performance at the cost of data integrity being OK was about MyISAM (which doesn't have great concurrent write performance due to the table-level locking).
I've thought about switching to Postgres, but it doesn't currently appear to be worth the pain in my case.