Metadata

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.