< ^ txt
Wed Apr 30 06:00:01 UTC 2025
========================================
Slept from ten to six.
Woke briefly around one-thirty.
Much cooler.
Partly cloudy.
Areas of frost after midnight.
Lows in the mid 30s.
Northwest winds 5 to 20 mph with gusts up to 30 mph, becoming north 5 to 10 mph after midnight.
# Work
* [x] go into office to meet Corey Keidel and Dane Wortley in person
* 10:00 AM - 11:00 AM CTO and FIT touchpoint
* 03:15 PM - 03:30 PM VIPR deadlines and risks follow up
Went out to lunch with Dane, Corey, Cindy Ryle, and Scott W. from D&D came along too.
# Home
* [ ] schedule optometrist appointment (Costco?)
* [ ] apply for passport
* [ ] build Pi-hole for home network
* [ ] exercise for ten minutes
Read more of Children of Ruin.
https://jvns.ca/blog/2024/09/27/some-go-web-dev-notes/
>Someone on Mastodon linked me to this post called Optimizing sqlite for servers. My projects are small and I’m not so concerned about performance, but my main takeaways were:
>
> * have a dedicated object for writing to the database, and run db.SetMaxOpenConns(1) on it. I learned the hard way that if I don’t do this then I’ll get SQLITE_BUSY errors from two threads trying to write to the db at the same time.
> * if I want to make reads faster, I could have 2 separate db objects, one for writing and one for reading
>
> There are a more tips in that post that seem useful (like “COUNT queries are slow” and “Use STRICT tables”), but I haven’t done those yet.
Dinner and drinks with Matt Russell, Corey, and Dane after work at Griffin Claw.
They tried to rope me into going camping with them, but I declined.
Matt texted Tah a photo us all raising a glass.
Fun, but a long day.
Servings: grains 2/6, fruit 0/4, vegetables 3/4, dairy 2/2, meat 4/3, nuts 0/0.5
Breakfast: coffee, eggs, tomato, pepper
Lunch: turkey sandwich, coleslaw
Dinner: steak bites, beer
< ^ txt