kpozin

If Tailscale is on, I can't concurrently run a DNS-blocking local VPN, so I see ads in mobile Chrome.

- Authy

- Google Authenticator

Gemini's built-in song generator seems to have better prompt adherence, higher audio quality, and better diction.

Maybe `ArrowLeft`/`ArrowRight` or `j`/`k` to flip through all of card pairs? Or just allow us to scroll through all the pairs. In either case, both old and new should be visible.

This happened to me a couple of times when I tried to sign up on their website: instantly banned before I could even enter the onboarding flow.

I then had more success signing up with the mobile app, despite using the same phone number; I guess they don't trust their website for account creation.

A framework designed to blur the line between code running on the client and code running on the server — forgot the distinction between code running on the client and code running on the server. I don't know what they expected.

(The same confusion comes up regularly whenever you touch Next.js apps.)

If you just want to be able to control the ACs remotely, without remote sensing, you can buy some cheap IoT IR blasters (around $15–30 for Zigbee or WiFi versions). They'll often have control schemes you can download for your specific equipment (cloning the IR remote control that came with the AC).

Another fun limitation is that a transaction cannot span multiple D1 requests, so you can't select from the database, execute application logic, and then write to the database in an atomic way. At most, you can combine multiple statements into a single batch request that is executed atomically.

When I needed to ensure atomicity in such a multi-part "transaction", I ended up making a batch request, where the first statement in the batch checks a precondition and forces a JSON parsing error if the precondition is not met, aborting the rest of the batch statements.

  SELECT
    IIF(<precondition>, 1, json_extract("inconsistent", "$")) AS consistent
  FROM ...

I was lucky here. For anything more complex, one would probably need to create tables to store temporary values, and translate a lot of application logic into SQL statements to achieve atomicity.