How to implement the last time online function?

Question

PostgreSQL

Hello, I am making a site on nodeJs and postgresql, I use sessions for authorization and Redis cache storage. How can I implement the function when the user was last online?

Answer 1

With each action / authorization / something else of the user, write down in the database that he was online. You can then use this information wherever you need it.

Answer 2

Create a last_seen column and add a timestamp there when requesting session initialization.

Answer 3

Make a websocket in which the online label is reset on the first connection, and when the connection is lost and there are no other active ones, the last activity label is put