Thread of 3 posts
jump to replies
ugh, the pg&e "green button" csv exports are in localtime, so i have to write code to do the dst conversions and handle the skipped/repeated hours
fuck, this library doesn't let me add "1 day" (distinct from "24 hours") to a Timestamp object, does it
figured that out, got it working for the gas usage csv
completely forgot that the gas usage csv is basically useless (day-per-row, and the value has low enough resolution that there's basically 3 values a given day might be rounded to)
now to implement the slightly trickier bit: the electricity usage csvs (which are hour-per-row, and thus need more dst handling)
3 replies
back to top
@nyanotech cursed brainthought: rewrite it in postgres, which does
@jackie ironically i'm writing a thing that generates a postgres table, which then goes into the grafana source postgres
@nyanotech lmao
...I mean, it wouldn't be that bad to dump it directly in and do the time math with views, would it? 🤔