Inspired by Simon Willison's collection of sqlite tools, I created
a library for extracting information from a video, and storing it in an sqlite database. It's
called video-to-sqlite. You can also install it
via pip install video-to-sqlite.
You can use Simon's very nifty tool Datasette to explore the resulting DB …
Today I learned about Powertoys,, a utility application from Microsoft.
Caps lock isn't a very useful key, but it occupies very valuable keyboard real estate, sitting on home row. Some programmers like mapping ctrl to the caps lock key. Some keyboards even have hardware settings to switch them. Personally, I …
In Firefox 109, Mozilla introduced a "unified extensions button". Normally, you can fully customize your toolbar, but this button cannot be moved or removed from the toolbar via the usual "Customize Toolbar" method.
However, it can be removed with an edit to your Firefox config. To remove it, open about …
Taking a cue from Simon Willison, a TIL (today I learned) about the moviepy library.
The library is very useful, but sometimes I have difficulty finding documentation on how to do specific things. For example, recently for NaMoGenMo I wanted to crossfade between 2 clips.
Suppose you have two 10-second …
This November, I worked on a project to create code to generate a movie. I got the idea from NaNoGenMo, which itself is based on NaNoWriMo.
My idea was to create a Memento-ized version of an existing movie. If you haven't seen Memento, it's structured where the order of scenes …
A question came up in a discord for Slay the Spire - what is the win percentage of players in their first time playing the game? I thought that was an interesting question, so I looked into it using the big dataset from Mega Crit, the creators of the game.
Overall …
Summing the values in an array in SQLite
Word clouds generated from runs during the SGDQ 2022 marathon
You may have heard of NaNoWriMo, aka National Novel Writing Month. It's a challenge where every November, participants work to write a novel, defined as 50,000 words of fiction.
You may not have heard of NaNoGenMo, National Novel Generation Month,, where participants write code to generate 50,000 words …
Recently, I was trying to use Apache Solr on my WSL install of Ubuntu 20.04. Following the docs, I could download and start Solr, but visiting 127.0.0.1:8983/solr/ from a browser in Windows gave me an "unable to connect" error. The solr logs showed no …