I'm kinda curious why none of the third party app developers considered selling Reddit requests as in-app purchases – just charge the rate Reddit charges.
Paying a monthly subscription to only have access to half of Reddit (NSFW will not be available through third-party apps) sounds like a bad deal to me.
I think so? PostgreSQL is very well written software AFACT.
I've run into version incompatibilities before, but it was my fault – they were expertly documented in the release notes and I just hadn't read them (or sufficiently tested the upgrade before the live performance of it).
I wouldn't think using "standalone" versus whatever would make much of a difference.
If you're using a hosted DB service, you're (probably) stuck in needing/wanting to rehearse using the hosted service (which is what the blog post describes).
If they were running the DB on 'regular server' cloud instances, it seems just as good to me to rehearse with other cloud server instances versus "standalone" servers.
I'd think using built-in replication (e.g. PostgreSQL 'logical replication') for 'dual writing' should mostly avoid inconsistencies between the two versions of the DB, no?