I think the simplest thing to do would be to have a cron job generate plot pngs with every database update:
- a single plot on the main page with all rows' views.
- a plot on the caster page…
*pyplot
I meant gnuplot, which lots of languages have bindings to, I think.
Great. I've been wanting to collect enough data to start doing some fun statistics. What I really want to do is get graphs on the site to make it easy for the guys to see this analysis. I'm not…
I didn't test this new version. For some reason it's not finding the functions in WeatherNews.jl. Even if I move the script to bin/ with the others
using SQLite, JSON3
using WeatherNews
db = SQLite.DB("/tmp/wn.db")
rows = DBInterface.execute(db,
"""
SELECT id, video_id…I should have cached the yt-dlp json responses for testing my updated script without spamming youtube's servers again. Would run way faster too, of course.
I should make the script more elaborate by making it check that the video title passes my iswnl function and it's date and segment in the title matches what's stored in the database, and just…
https://www.youtube.com/watch?v=SwVz3Oni58M
"live_status": "not_live",
This is the problem. That URL points to the second calendar-making video!, not Yui's Moon that day, so it was…
the @debug under catch didn't output anything, so I guess the UPDATE "succeeded"
1088 11 4 2023-11-26T14:00:00+09:00 iUHVlwj7Ivo 42068
1089 3 5 2023-11-26T17:00:00+09:00 hWp6FPfTT9A 43370
1090 8 6 2023-11-26T…finally finished
progress: 1980
real 94m36.556s
user 60m30.666s
sys 5m34.231s
so far so good
sqlite3 /tmp/wn.db 'select * from schedule WHERE segment_id != 8 AND video_id IS NOT NULL AND view_count IS NOT NULL;'
it's actually taking max 2 seconds per update so far