Permanently deleting data is now just one command away. Ditto’s new system‑wide deletes instantly remove a record from every device and the cloud, giving users the up‑to‑date view they expect while we quietly handle the housekeeping behind the scenes. This update makes deleting data in Ditto easier than ever, letting your team spend less time managing data and more on building great features.

What’s new and why it matters

• Single command, full lifecycle. Use the new DQL DELETE statement to mark a document as deleted. Ditto syncs that change to every peer and the cloud.
• Automatic eviction. Deleted data disappears from queries immediately. Ditto keeps a document tombstone so the delete can sync through the mesh, then removes the tombstone after the Time‑to‑Live (TTL) you configure. No manual eviction and no ghost data.
• Consistency everywhere. Deletes benefit from the same peer‑to‑peer guarantees that power the rest of Ditto, so every copy of your data set stays in sync.

How it works

DELETE FROM orders WHERE _id = "order_123"

1. Delete flag set. The document is marked as deleted and the change is synced to all connected peers.
2. TTL countdown starts. A deletion timestamp is applied. Default TTLs are 7 days for the Edge SDK and 30 days for the Cloud Server.
3. Auto‑eviction triggers. When the TTL expires, Ditto permanently removes the document.

Availability

Next steps

1. Upgrade your Edge SDKs to version 4.10.1 or later.
2. Review the documentation for additional information, examples, and configuration

System‑wide deletes with auto‑eviction give you a cleaner, faster way to manage data through its entire lifecycle. Upgrade today and enjoy effortless data hygiene with Ditto.

Learn more in the Ditto Docs

• Removing Documents
• DQL DELETE Syntax

‍