A Hybrid Playwright and Google Analytics 4 API Pipeline for Weekly Analytics Reporting

~ Yin

Weekly reporting often begins as a small manual task:

  1. Open several analytics reports.
  2. Change each report to the same weekly date range.
  3. Wait for charts to load.
  4. download each report as PDF.
  5. Rename the files.
  6. export supporting CSV data.
  7. place everything in the correct folders.
  8. verify that no report is missing or incomplete.

None of these steps is particularly difficult. The problem is repetition, inconsistency, and silent failure. This article describes the architecture and engineering decisions behind a macOS automation workflow that generates several Looker Studio PDFs and GA4 CSV files from one shared reporting period.

Continue reading →

Sharing Port 8080 Between qBittorrent and V2Ray with Nginx (One Public Port, Two Applications) A case study on reverse proxying, WebSocket routing, firewall debugging, and safe staged deployment on an Oracle Ubuntu VPS

~ Yin

Introduction

I recently faced a network configuration problem that initially looked simple:

How can I install V2Ray on a VPS when the only usable general-purpose public port is already occupied by qBittorrent?

The server was an Oracle Cloud Ubuntu VPS running qbittorrent-nox. Its WebUI was publicly accessible on TCP port 8080, while BitTorrent peer traffic used TCP and UDP port 47374.

Other candidate ports, including 80, 443, and 56894, were locally unused. However, external testing showed that they were not reachable through the Oracle Cloud network configuration. I did not want to modify the Oracle Virtual Cloud Network rules again, interrupt qBittorrent whenever I needed V2Ray, or expose unnecessary additional ports.

Continue reading →

冬夜在嘎嘎家， 3DMark 06 和罗马

~ Yin

今天在海弗利一家中餐馆吃饭时，突然想起了一幕场景。那是我高中时，大概是2009年或2010年左右，一个冬夜。那应该是寒假期间，我在外婆家——也就是我妈妈的妈妈家，我们用湖北方言叫她嘎嘎。

我当时正在用我爸爸在我奶奶的劝说下买的电脑玩（更准确地说，是“使用/运行”而非“玩”） 3DMark 06 演示版。

Continue reading →

From 3DMark 06 to Rome: A Winter Night at Gaga’s House

~ Yin

Today, while dining at a Chinese restaurant in Heverlee, a scene suddenly came to mind. It was me in high school, probably around 2009 or 2010, on what I think might have been a winter night. It must have been a night during winter break at my grandma’s house, my mother’s mother, whom we call Gaga （嘎嘎） in the Hubei dialect.

I was on a computer that my dad had bought at the urging of my grandma, playing the 3DMark 06 demo.

Continue reading →

候麦电影中的爱、愧疚与解脱：《女友的男友》（1987）观后感

~ Yin

（口述转录）

总之，今天我终于看完了候麦——法国导演埃里克·候麦——的一部电影。这部电影的名字大概是《女孩的男朋友》或者《我女友的男朋友》之类的。

总的来说，我挺喜欢这部电影的。它非常有名，据说是他一系列道德寓言故事中的一部。我之前多次听过它的名字，但从未认真看过。过去几天，我一直在等待英国签证申请的结果。我昨天提交了申请，现在正在等待，所以自然有点紧张。因此，我断断续续地看了这部电影，通常每天吃饭的时候看几分钟，最后分几次看完了。

Continue reading →

Love, Guilt, and Relief in Rohmer: Some Thoughts After Watching “L’Ami de mon amie” (1987)

~ Yin

(Oral transcription)

Anyway, today I finally finished watching a film by Rohmer—the French director Éric Rohmer. The film is called something like The Girl’s Boyfriend, or My Girlfriend’s Boyfriend—something along those lines.

Overall, I quite liked it. The film is very famous and is supposedly one of his series of moral tales. I had heard its title many times before, but I had never watched it carefully. Over the past few days, I have also been waiting for the result of my UK visa application. I submitted it yesterday, and now I am waiting, so naturally I have been feeling a little nervous. I therefore watched the film intermittently, usually for a few minutes while eating each day, and eventually finished it over several sittings.

Continue reading →