Show last used time/grant time for browser integration keys

[rugk]

Summary

It would be nice to have the "last used" date/time column in the browser integration panel.

Desired Behavior

In the DB settings -> browser integration, where the keys for the integrations are listed, there should be a column for when that connection has last been used.

Maybe also, when it was added?

Possible Solution

So maybe two columns.

Context

The problem is when looking at the list the identifiers (which I mainly name after browser/profile) may not be enough to really know when I have granted that thing, and whether I can revoke it.
To "cleanup" old entries it may just be useful to revoke all entries that were used long ago. 🤔

[varjolintu]

"Created" is quite easy to implement. "Last Used" must be implemented in a way that it's only updated when connecting to the database (or when requesting credentials). Updating the timestamp on every action causes a lot of updates to the database, as the custom data would be constantly updated on every request.

EDIT: At this point we are only implementing "Created". Let's discuss the possible "Last Used" later.

[rugk]

So #4392 was just about the created column. May we then reopen this issue or so for the "Last Used" later?

[varjolintu]

@rugk I'm ok with reopening this with a modified title. However, "Last Used" is something that must be discussed: how to implement it, or implement at all. I'm worried about the constant changes to the database, so the connection process itself must be modified or we have to figure out how to save the "Last Used" state without rewriting to the custom data all the time.

[rugk]

Maybe once a day is enough? I guess we don't need a time, so having the date there is enough.

[droidmonkey]

I have no interest in adding additional meta data to the connection id.