Skip to content

[DESIGN] SQL to determine client app in use #30

@mikeybob

Description

@mikeybob

Query to determine client app the user is currently using:

Warning

Needs validation

SELECT user_agent AS client_app,
       MAX(timestamp) AS timestamp,
FROM user_sessions
WHERE user_id LIKE <?>
ORDER BY timestamp
LIMIT 1;

This should determine the client app glyph.

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions