Skip to content

2024

  • 1 min read

DuckDB as the New jq

Link: DuckDB as the New jq: "Recently, I’ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats."

A useful tool if you work with large quantities of json. Just letting you know!

  • 1 min read

Pythagora-io/gpt-pilot: The first real AI developer

Link: Pythagora-io/gpt-pilot: The first real AI developer: "The first real AI developer. Contribute to Pythagora-io/gpt-pilot development by creating an account on GitHub."

Interesting. There are more and more of these coming out. For now I doubt they work very well, in practice. However the trend is clear and they will get better and better. Are our jobs at risk? Only if we don’t learn how to use these tools to up our game. A graphic designer or photographer that decided to resist learning Photoshop and opposed its use in their profession is probably out of work now.

  • 1 min read

VSCode + WSL makes Windows awesome for web development

Link: VSCode + WSL makes Windows awesome for web development: "I’m kinda shocked. Windows actually got good for web developers. Between VSCode, WSL, and Intel’s latest desktop chips, I’ve been living with a PC for over a week that runs my programming tests faster than an M3 Max, ships with an excellent window manager out-the-box, and generally feels like a completely viable alternative to macOS fo..."

Me too. I also bought the M3 beats everything story. Still I have gotten programmed to really like the overall look of the macOS universe and be somewhat repelled by the windows look and feel. That’s just taste. But, the so called disadvantage of the macOS “walled garden” to me is a feature. That my contacts, calendar, desktop, email and all seamlessly stay in sync across my laptops, desktop, phone and tablet is a huge advantage that I totally rely on.

  • 1 min read

Asyncio Patterns in Python

Link: Asyncio Patterns in Python: "Recently I needed to run millions of API calls to an internal service. API calls are IO blocking. This means that when my service calls the…"

A great step by step introduction to ASYNCIO in Python for cleaner concurrency and synchronization.

  • 1 min read

Calculated file paths

Link: Calculated file paths: "MP 87: What are they, and why should you use them?

Note: I've been working on the styling of code blocks in technical posts. They should look better than they did previously, and be more aligned with what's discussed in the text. There's still some work to do; if they're"

Nice little article. The biggest thing I learned and was surprised by was this line:

path = Path(__file__).parent / "coffees.txt"

What's the story with that slash?

  • 1 min read

GNSS Positioning - A Reviser

Link: GNSS Positioning - A Reviser: "This article reviews the core principles underpinning the global navigation satellite system (GNSS). It references some of the key terminology, outlines the main potential sources of error, and describes how the application of RTK DGPS techniques can mitigate these errors to a large extent."

A super comprehensive introduction to GPS, with more detail than I have seen elsewhere. Also based on the second paragraph it seems to be quite up to date (2023)

  • 1 min read

How HEAD works in git

Link: How HEAD works in git: "Usually when people say that a topic is confusing when I think it’s not, the reason is that there’s actually some hidden complexity that I wasn’t considering. And after some follow up conversations, it turned out that HEAD actually was a bit more complicated than I’d appreciated!"

Julia Evans continues with her tour the force in depth explainers about how git actually works.