Avatar

alvi

Joined May 29, 2024
Public vals
8
alvi avatar
ownedGamesToSqlite
@alvi
Cron
Forked from alvi/SteamPlaytimeHistory_playHistoryToSqlite
alvi avatar
exportOwnedGamesToEmail
@alvi
Cron
Forked from alvi/SteamPlaytimeHistory_exportDbToEmail
alvi avatar
ownedGamesSchema
@alvi
Script
Forked from alvi/SteamPlaytimeHistory_playHistorySchema
alvi avatar
createOwnedGamesTable
@alvi
Script
Forked from alvi/SteamPlaytimeHistory_createPlayHistoryTable
alvi avatar
SteamPlaytimeHistory_exportDbToEmail
@alvi
Cron
This val is part of the SteamPlaytimeHistory project This val exports the entire play_history table into a csv and emails it to you once a week for backup
alvi avatar
SteamPlaytimeHistory_createPlayHistoryTable
@alvi
Script
This val is part of the SteamPlaytimeHistory project This val allows you to create the play_history table to run the project
alvi avatar
SteamPlaytimeHistory_playHistorySchema
@alvi
Script
This val is part of the SteamPlaytimeHistory project This val exports the drizzle table scheme so you can use it to interact with your play_history table across your differents vals
alvi avatar
SteamPlaytimeHistory_playHistoryToSqlite
@alvi
Cron
This val is part of the SteamPlaytimeHistory project which consists of logging your recently played games on steam everyday through valve's API. I wanted to log this data so I can analyse which days do I game the most ? which periods do I log the most hours in my confort game (Dead By Daylight) ? And so on. I think the data viz possibilities are super interesting, just like when Valve releases the "Steam in review" at the end of the year This val fetches your recent playtime history from valve's API and stores it in a database every day ! The project uses multiple vals to work: First you need to create the table to store the data: https://www.val.town/v/alvi/SteamPlaytimeHistory_createPlayHistoryTable You can then interact with the table using this drizzle schema: https://www.val.town/v/alvi/SteamPlaytimeHistory_playHistorySchema Optionnaly, you can backup your data with a csv file in your email every month: https://www.val.town/v/alvi/SteamPlaytimeHistory_exportDbToEmail Finally, you can run this val every day (or more) to log the data to the sqlite table To run this project, you'll need: A steam web api key: https://steamcommunity.com/login/home/?goto=%2Fdev%2Fapikey SteamID of the user (profile needs to be public) Discord websocket url (for error messages)
Next