1. Consistent reactive UI - better UX and better DevX

2. Transactional by default - avoids concurrency bugs in production

3. End-to-end type safety, best-in-class TypeScript support for React and the backend

4. Explicit indexing for predictable backend performance in production (no unexpected deopts)

5. Super fast DevX: Save and have your code deployed. Flexible (optional) schema. Powerful reactive dashboard.

6. Feature-full: File storage, scheduling, text search, vector search all built in.

On the cons side: Auth story isn’t as streamlined as for Firebase or Supabase if you don’t want to use Clerk or Auth0. But we’re working on it!

Since it’s really application specific (what rows should be soft deleted, is recovery possible…), you probably want to model these like any other state. With Convex you can do things like schedule a deletion mutation 30 days from now, or run a cron job that cleans up data out of retention.

Is this what you had in mind?