Project

General

Profile

Actions

Idea #21877

open

Permission links can have an expiration date

Added by Peter Amstutz 4 months ago. Updated 4 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
API
Target version:
Start date:
Due date:
Story points:
-

Description

It seems excessive to give link objects a whole trash_at/delete_at lifecycle.

We could instead have an optional entry in properties "delete_at", this would store a UTC timestamp, and then the "trash sweep" process would look for expired links and destroy them.

With newer Postgres JSON support, I think we can write this directly as a query -- selecting the value as a JSON path, converting it to a datetime, and comparing it to the current time.

It may need to iterate over every row that has delete_at, which is probably fine unless there are many thousands of temporary permissions -- but it may now be possible now to index json path queries.

Actions #2

Updated by Peter Amstutz 4 months ago

  • Description updated (diff)
Actions #3

Updated by Peter Amstutz 4 months ago

  • Description updated (diff)
Actions

Also available in: Atom PDF