Links

Links to places on the web that I'd like to share.

Recent links

What if I told you that by tuning a few knobs, you can configure SQLite to reach ~8,300 writes / s and ~168,000 read / s concurrently, with 0 errors

Some interesting configurations that are possible with SQLite today making it much more versatile even though it isn't designed to be a client/server SQL database. Discovered via Simon Willison's weblog.

Paul Irish shares how to stablise video using FFmpeg using the defaults of VidStab. The article also provides a filter to compare the stablised and unstablised videos but simply running the stabilisation is enough for me.

xz, a widely used open source compression tool, introduced a backdoor with malicious code. This in turn has affected a number of applications and distributions, the most notable of which are Fedora, Debian (unstable, experimental) and HomeBrew. Evan Boehs has pieced together a timeline of events going as far back as 2021 which tells a story of how JiaT75 using social engineering became a trusted member for the open source project. Pressure (very harshly so) was applied to the Lasse Collin the sole active maintainer at the time to add another maintainer to xz from seemly multiple people. This coordinated attempt lasting two years is honestly quite shocking.

CSS Grids as simple as they are to design can get pretty complicated. Josh W Comeau's interactive guide to CSS contains sections that build on each other with examples and animations to visualise the concept.

Dan Luu writes about using simple architectures to build apps using Wave as an example. The post covers the initial technology choices made to be maintained by a small tem and the tradeoffs in the long run, along with the flexibility it provided to adapt to local markets.

Our architecture is so simple I’m not even going to bother with an architectural diagram. Instead, I’ll discuss a few boring things we do that help us keep things boring.

When requesting actions on AWS accounts or resources, AWS needs to verify if the principal (user, role, application, etc.) making the request is allowed to carry out the action. For single accounts with simple workloads, this can be done easily by setting an identity-based policy on the user. However, as needs grow and additional accounts are added, other factors come into play, such as resource-based policies, cross-account roles, service control policies, and more.

Whenever I encounter potential access-related problems, I refer to this flow chart for troubleshooting. Given the number of times I end up searching for this, I believe it might be helpful to share it.

SVG is an interesting and versatile text-based image format. Now I know it's not the Christmas season, but Hunor Márton Borbély has put together an advent calendar for SVG examples, and I've only now started working through them. It's very interactive and informative. I know I'll definitely be using these examples as references in the future.

Like GeoGuessr but instead of Google Streetview you're given an image which you have to locate on a map along with the year it was taken. It's quite fun trying to take clues from the image in an attempt to date it. The images selected in the game actually make it lightly easier than random locations on Google Streetview with GeoGuessr.

Switzerland is often referenced when discussing good public transit systems, Jokteur does a good job describing of the country uses clock-face scheduling to reliably connected different locations together. A good read with clear examples illustrating the concept along with follow-up reading in case you’re interested in the subject.