On: Just use Postgres for everything

[glutamate]

I wouldn't even worry about coding to interfaces. When you need to replace Postgres because you have more than 1M users, you will probably have the revenue to refactor your code to swap out Postgres dependencies. Because you have good integration and E2E tests, right?

[marcosdumay → glutamate]

At such time you will also have plenty of interesting new problems that require changing most of your code anyway.

I agree that hedging against having to move from a FOSS database is pure waste.

[thomaslangston → glutamate]

Good tests are a lot easier to write with good interfaces.

[isbvhodnvemrwvn → thomaslangston]

Database abstraction layers are leaky, if you don't test things like isolation levels or other tricky behaviors, those tests will have limited value.

[jimbokun → isbvhodnvemrwvn]

Limited value is better than no value.