Hacker News new | ask | show | jobs
by davidgerard 3747 days ago
Let me say again how our workplace conversion from Oracle to Postgres has made EVERYTHING SO MUCH BETTER. Not just from never having to talk to Oracle ever again - but the fact that we can give every app its own PG clustered pair without ever having to think the word "license". Nothing has to play nice with anything else.

(We also have some MySQL - from old in-house apps and from third-party things like Drupal, Magento, WordPress and MediaWiki - and some MongoDB, which we're pushing to get converted to Postgres because it does key-value comparably fast and means one less dependency, though that's nothing like as urgent as getting off Oracle was.)
1 comments
chris_wot 3746 days ago
Yeah, until MySQL gets a corrupted LSN that points into the future and you have to dump the table then reimport it... :P
link
davidgerard 3746 days ago
AAAAAAAAAAAAAAAA

Chris is referring to this: http://rationalwiki.blogspot.co.uk/2016/03/mysql-database-pr... which I eventually resolved by carefully hand-exporting the corrupt table to CSV and reimporting it. I think we lost one revision from 2008. I HATE MYSQL SO MUCH.

(unfortunately, MediaWiki is one of those things where MySQL or preferably MariaDB is the only realistic option - other DBs are hypothetically supported, but in practice not well enough unless you want to do the heavy lifting yourself.)

link