• Joined on 2023-05-24
gg commented on pull request gg/WeatherNews.jl#11 2024-05-18 00:16:12 +00:00
Various fixes and and a new cron job to ensure consistent video data collection.

The new cron job for wndb-viewcount-update.jl is setup as of today.

gg pushed to main at gg/WeatherNews.jl 2024-05-17 14:54:09 +00:00
697cf93df9 Merge pull request 'Various fixes and and a new cron job to ensure consistent video data collection.' (#11) from pta/WeatherNews.jl:main into main
cb105176b2 Add cron job to make final view count update after exactly 10 days
bca7133795 Ensure every WNL row in schedule table gets assigned its video
ebff641a0a Bump youtube streams request up to 30
Compare 4 commits »
gg merged pull request gg/WeatherNews.jl#11 2024-05-17 14:54:08 +00:00
Various fixes and and a new cron job to ensure consistent video data collection.
gg commented on pull request gg/WeatherNews.jl#11 2024-05-17 11:59:31 +00:00
Various fixes and and a new cron job to ensure consistent video data collection.

I didn't notice this until today. Sorry about that.

gg commented on pull request gg/WeatherNews.jl#10 2024-04-29 09:42:31 +00:00
Mention yt-dlp in README and start recording view counts

Less Noisy Views

In an attempt to make the plot of views look less noisy, I tried summarizing the view data by day. I took all the views that happened in a day and summed them into one…

gg pushed to main at gg/WeatherNews.jl 2024-04-29 09:39:36 +00:00
e2754fb4c5 Add PlotlyJS as a dependency
41f8cfd0ae Transform jst into ZonedDateTimes
4fb138e52b Add WeatherNews.Helpers
Compare 3 commits »
gg pushed to main at gg/WeatherNews.jl 2024-04-28 17:53:10 +00:00
6d03c43365 Rename seg.n AS segment instead of title
gg pushed to main at gg/WeatherNews.jl 2024-04-28 17:52:13 +00:00
2fc0a8abf5 Insert au PAY shows for 2024-05
9c34758578 Count appearances grouped by caster, month, and segment
f6945e507a Add view_count to big joined SELECT example
Compare 3 commits »
gg pushed to main at gg/WeatherNews.jl 2024-04-25 08:09:48 +00:00
6428bae369 Add Plots as a dependency
gg commented on pull request gg/WeatherNews.jl#10 2024-04-25 07:33:27 +00:00
Mention yt-dlp in README and start recording view counts

Please bear with me as I am a beginner when it comes to data visualization.

I tried doing 2) using Plots.jl. I had to read documentati…

gg pushed to main at gg/WeatherNews.jl 2024-04-24 01:05:42 +00:00
f3429e0101 Filter out view_count == 0
gg commented on pull request gg/WeatherNews.jl#10 2024-04-24 00:52:35 +00:00
Mention yt-dlp in README and start recording view counts

@pta - Heads up! I just added DataFramesMeta as a new dependency. There isn't any deployed code that uses it yet, but I wanted to have it so that I could explore the data with Julia instead of…

gg pushed to main at gg/WeatherNews.jl 2024-04-24 00:46:10 +00:00
9815bc259d Add DB.load_schedule_joined(db)
2bf95ca33a Add some queries that explore schedule.view_count
172c25be6c Add DataFramesMeta as a dependency
Compare 3 commits »
gg commented on pull request gg/WeatherNews.jl#10 2024-04-23 23:03:59 +00:00
Mention yt-dlp in README and start recording view counts

For some reason it's not finding the functions in WeatherNews.jl.

I didn't export any functions. When you're not inside the defining module:

  • You either have to fully qualify the function…
gg commented on pull request gg/WeatherNews.jl#10 2024-04-23 22:58:40 +00:00
Mention yt-dlp in README and start recording view counts

Here are a few queries you can play with. Maybe you've already written something similar.

-- Average views for casters
SELECT c.n AS name,
       AVG(s.view_count) AS avg_views,
   
gg commented on pull request gg/WeatherNews.jl#10 2024-04-23 22:24:21 +00:00
Mention yt-dlp in README and start recording view counts

I've started running the script on the live database.

gg pushed to main at gg/WeatherNews.jl 2024-04-23 14:55:52 +00:00
2eccd4a454 Align views column to the right
gg commented on issue gg/WeatherNews.jl#6 2024-04-23 13:07:36 +00:00
Should I implement a web site in Julia?

I had to run home-manager init first, but then it worked. Thanks for teaching me.

gg commented on pull request gg/WeatherNews.jl#10 2024-04-23 12:49:02 +00:00
Mention yt-dlp in README and start recording view counts

And it's pointing to the future stream because staff fucked up the stream title again.

Staffさん!!!!!

I have the retroactive views script ready too.

Nice.

The only…

gg commented on pull request gg/WeatherNews.jl#10 2024-04-23 10:42:52 +00:00
Mention yt-dlp in README and start recording view counts

I added a view column to the schedule display, and I think there might be a little bug. Notice uozumi on the 2024-04-23 having 0 views. The link is also going to her future show on the…