## Metadata
* URL: [http://mikehadlow.blogspot.com/2012/04/database-as-queue-anti-pattern.html
* Author: Mike Hadlow
* Publisher: mikehadlow.blogspot.com
* Published Date: [[2022-10-04]]
* Tags: [[nx-data-platform-engine|Nx Data Platform Engine]]
## Highlights
* ‘Database As Queue’ anti-pattern.
* Firstly, there’s the polling.
* very efficient at insertions, or updates, or queries, but rarely all three on the same table.
* how you clear records once the workflow is complete.
* deletes are inefficient on SQL Server.
* Fourthly, sharing a database between applications (or services) is a bad thing. It’s just too tempting to put amorphous shared state in there and before you know it you’ll have a hugely coupled monster.