This is a collection of common application use-cases that can be solved with database features. All problems and solutions have different trade-offs that are worth talking about.

Patterns that are internal to the ORM are not mentioned here. Like the in-memory persistence context. For those there will a separate section.

Written

1. Counting Items in OLTP systems

Future

1. Transactional outbox
2. Queue in DB
3. Full-text search
4. Soft-delete
5. Get or Create
6. Upsert
7. BLOB in DB
8. Optimistic Locking
9. Pessimistic Locking
10. Auditing