Function soft_delete 

pub fn soft_delete(
    conn: &Connection,
    namespace: &str,
    name: &str,
) -> Result<bool, AppError>

Soft-deletes a memory by setting deleted_at = unixepoch().

Versions and chunks are preserved so restore can undo the operation until a subsequent purge reclaims the storage permanently.

Returns

Ok(true) when a live memory was soft-deleted, Ok(false) when no matching live row existed.

Errors

Returns Err(AppError::Database) on any rusqlite failure.