AppsAutessaDB

Files, apps and operations · AutessaDB

Soft delete and restore

Deleting an AutessaDB table is a soft delete. The request returns a short-lived confirmation token, confirming re-checks ADMIN, and the table goes to a trash with a 14-day grace period, where list-deleted shows the time left and restore brings it back.

A database essential, built in
tables list-deleted14-day grace periodSAMPLE
tabledeletedtime left
old_leadsOct 298 daysrestore
scratch_importOct 221 dayrestore
Deletion is two-step: a short-lived confirmation token, then a confirm that re-checks ADMIN.

-- the problem

One wrong click should not end a dataset

Hard deletes are permanent, and the person who clicked rarely meant it. Two-step confirmation and a trash window give every deletion a second chance.

What you get

  • Two-step deletion: a confirmation token, then a confirm that re-checks ADMIN.
  • A 14-day grace period before the table is purged.
  • list-deleted shows your trash with time left for each table.
  • restore brings a table back within the window.
  • Ownership can be transferred to a teammate by the owner.
  • Tables managed by a connector or an app follow their parent and cannot be deleted directly.

-- how it works

How does soft delete and restore work in AutessaDB?

  1. Delete

    Delete from the table menu, or autessa autessadb tables cli-delete.

  2. Change your mind

    Find it in the trash with list-deleted.

  3. Restore

    restore within 14 days and it is back as it was.

-- every option

Lifecycle commands

optionwhat it does
cli-deleteSoft-delete a table in one call.
list-deletedYour trash, with time left before purge.
restoreBring a table back within 14 days.
Transfer ownershipOwner only.

-- example

Delete and restorebash
autessa autessadb tables cli-delete --tableId ayXduiaLeFKh
autessa autessadb tables list-deleted
autessa autessadb tables restore --tableId ayXduiaLeFKh

Full reference in the AutessaDB CLI docs and the API reference.

-- permissions

Who can do what?

accesscan
ADMINDelete and restore.
OwnerTransfer ownership.

-- relations

How it connects

autessadb feature

Access levels

Deletion needs ADMIN.

autessadb feature

Append-only tables

For rows that must never change.

autessa product

Autessa Drive

Files have their own trash and versions.

-- faq

Questions about soft delete and restore

Can I recover a deleted AutessaDB table?

Yes, within 14 days. Deletion is a soft delete; restore brings the table back before it is purged.

Why does deletion need two steps?

The first call returns a short-lived confirmation token and the second re-checks ADMIN, so a stray request cannot delete a table.

How do I remove a table an app created?

Manage the app or connector that owns it. Managed tables follow their parent, so they always stay in step with it.

Also in Files, apps and operations:Drive on AutessaDBBackend for custom apps

$ autessa autessadb tables create

Try soft delete and restore in AutessaDB

Table deletion needs a confirmation token, lands in a trash with 14 days to restore, and ownership can move to a teammate.

Read the AutessaDB guide or install the CLI.

100% customizable, code and all

Make AutessaDB fully your own.

Use it out of the box, then change anything. Ask Autobot, Autessa’s AI builder, for a new field, screen, report, workflow or agent and it builds it into your copy of the app. Or open the code and edit it yourself. Nothing is locked: the app, its data and its code are yours.

Start free and make it yours