Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Store statistics for a specific user in our postgres database. #2

Open
vinhocent opened this issue Dec 18, 2023 · 0 comments
Open

Store statistics for a specific user in our postgres database. #2

vinhocent opened this issue Dec 18, 2023 · 0 comments

Comments

@vinhocent
Copy link
Owner

We would like to get stats for a user's connections scores over a week.

First - we need to define what does that look like. What kind of stats do we care about?

Some easy ones are - this user clutched up and did their connections in 7 guesses. We can add this to some # of Clutches metric. Another easy one is adding # of Perfect Scores

Second- after getting these stats, we want to be able to store these stats for a given week in our postgres database.

Some notes on this is we want to try minimize number of tables we have. Currently, we have one table just for all connections messages. I think flushing this out every week is probably the right move. We will also need a global table, to store metadata, like "What is Today's Connection Number". We then probably want to store a user's all time scores + weekly score together.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant