Application vs Integration databases: https://martinfowler.com/bliki/Integration... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		dylanz on Nov 8, 2019 \| parent \| context \| favorite \| on: We do not use foreign keys (2016) Application vs Integration databases: https://martinfowler.com/bliki/IntegrationDatabase.html. If you're going to have one application writing to your database, having your constraints live in your application is definitely a viable option.

tiglionabbit on Nov 8, 2019 | [–]

Not if you have multiple processes accessing the database simultaneously without some additional coordination layer.

randomidiot123 on Nov 8, 2019 | [–]

It's definitely asking for trouble. Murphy's Law.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact