2025-06-11 08:00:00
I just learned a cool trick that I want to share. Let's review the diff of a file using git diff. I redacted most of it, but you probably found yourself in the situation of extremely long changes before:
`
diff --git a/lib/ui/screens/detail/components/body/eventbody.dart b/lib/ui/screens/detail/components/body/eventbody.dart
index d19d70a..1a61380 100644
--- a/lib/ui/screens/detail/components/body/eventbody.dart
+++ b/lib/ui/screens/detail/components/body/eventbody.dart
@@ -3,6 +3,7 @@
class EventBody extends StatelessWidget {
final EventDetails details;
@@ -18,35 +19,43 @@ class EventBody extends StatelessWidget {
@override
Widget build(BuildContext context) => Column(
- crossAxisAlignment: CrossAxisAlignment.stretch,
- children: [
- EventInfoView(
- location: details.location,
- start: details.start,
- end: details.end,
- certified: details.certified,
- paid: details.paid,
- points: null, // Already shown in app bar
+ crossAxisAlignment: CrossAxisAlignment.stretch,
+ children: [
+ EventInfoView(
+ location: details.location,
+ start: details.start,
+ end: details.end,
+ certified: details.certified,
+ paid: details.paid,
+ points: null, // Already shown in app bar
+ ),
+ const SizedBox(height: 24),
+ Html(
+ data: details.description,
+ style: {
+ 'body': Style(
+ margin: Margins.zero,
...
}
`
But do you spot what has ACTUALLY been changed? In a real world scenario, it probably took you a while before you realised that it's the result of formatting the entire file. Nobody cares about whitespace when reviewing code. Or rather, your brain should not take the burden of having to care about that. That's what linters are for!
Let's look at the same diff with the --ignore-all-space (shorthand -w) flag activated:
diff --git a/lib/ui/screens/detail/components/body/event_body.dart b/lib/ui/screens/detail/components/body/event_body.dart
index d19d70a..1a61380 100644
--- a/lib/ui/screens/detail/components/body/event_body.dart
+++ b/lib/ui/screens/detail/components/body/event_body.dart
@@ -3,6 +3,7 @@
class EventBody extends StatelessWidget {
final EventDetails details;
@@ -29,6 +30,14 @@ class EventBody extends StatelessWidget {
points: null, // Already shown in app bar
),
const SizedBox(height: 24),
+ Html(
+ data: details.description,
+ style: {
+ 'body': Style(
+ margin: Margins.zero,
+ ),
+ },
+ ),
Text(details.description, style: context.theme.textTheme.body2Regular),
if (details.registrationUrl != null || details.programUrl != null) const SizedBox(height: 16),
if (details.registrationUrl != null) ...[
Huh, so it's NOT just a formatted file. All whitespace changes have been stripped out, and you only see the changes that are relevant for the review. Neat!
Many tools also support ignoring whitespace. GitLab let's you disable Show whitespace changes in the merge request diff viewer. VSCode has the diffEditor.ignoreTrimWhitespace setting. So, if you want to make this the default in your tools, chances are there's an option for only showing relevant changes.
A bit of a sloppy post, but I hope this is useful to someone. Happy code reviewing!
2025-05-20 08:00:00
This applies to work tasks just as much as it applies to hobbies. No matter what you do, always create some sort of breadcrumb that you or someone else can pick up down the line.
If you build a feature into your app, you've generated an output, and therefore value. But what if you bang your head against the wall and don't make any progress? Write about it. Write about your challenges, document what you've learned and share it with your peers. Not reaching a set goal doesn't mean failure. It's an opportunity to create value in a way you didn't anticipate.
If you're out on a run and a thought pops into your head, record a memo on your phone, or better yet: keep a tiny notebook with you at all times. Thoughts slip in and out of our heads at a very rapid pace. Capturing thoughts, even if you don't share them with anyone else, is a great way to generate value out of thin air.
If you're into crafty hobbies like woodworking, painting or baking, you likely know how important it is to finish a project. No matter how good or bad the outcome is, every finished project is an artifact that you can look back at later and see the progress you've made.
Output always means value, even if it's not immediately apparent. Just keep on laying down those breadcrumbs.
2025-03-25 08:00:00
There are a couple of interfaces that container orchestration systems (like Kubernetes) implement to expose certain behavior to their container workloads. I will only be talking about Kubernetes in this post since it's the orchestrator I'm most comfortable with, but some interfaces are also implemented in other orchestrators (like HashiCorp Nomad) too, which makes the interfaces cross-platform.
Storage behavior used to be built into Kubernetes. The container storage interface (CSI) defines a unified interface to manage storage volumes, regardless of the orchestrator (as long as they implement the CSI). This makes it way easier for third-party storage providers to expose data to Kubernetes. If a storage provider implements this interface, orchestrators can use it to provision volumes to containers. Notable storage providers are:
A full list of CSI drivers can be found here.
The Container Runtime Interface (CRI) is an API that allows Kubernetes to use different container runtimes without needing to recompile the entire Kubernetes codebase. Before CRI, Kubernetes had a direct integration with Docker, making it difficult to use alternative container runtimes.
CRI defines the API between Kubernetes components (specifically kubelet) and container runtimes. This abstraction allows Kubernetes to support multiple container runtimes simultaneously, giving users the flexibility to choose the runtime that best fits their needs. Some popular container runtimes that implement the CRI include:
With CRI, switching between different runtimes becomes more straightforward, allowing operators to optimize for security, performance, or compatibility based on their specific requirements.
The Container Network Interface (CNI) defines a standard for configuring network interfaces for Linux containers. Similar to CSI and CRI, the CNI was created to decouple Kubernetes from specific networking implementations, allowing for a pluggable architecture.
CNI plugins are responsible for allocating IP addresses to pods and ensuring proper network connectivity between pods, nodes, and external networks. They implement features like network policies, load balancing, and network security. Some popular CNI plugins include:
Each CNI plugin has its strengths and is suitable for different use cases. For example, Calico excels at enforcing network policies, Cilium is optimized for performance and observability, while Flannel is valued for its simplicity.
One thing I've always admired about Kubernetes is its pluggable architecture. These standardized interfaces (CSI, CRI, and CNI) showcase how well-designed the system really is. Instead of building everything into the core, the Kubernetes team made the smart decision to create extension points that allow the community to innovate without touching the core codebase.
The great news? You don't have to swap out all these components or even understand them deeply to use Kubernetes effectively. While the array of options might seem daunting at first glance, most Kubernetes distributions (like EKS, GKE, AKS, or Rancher) come with sane defaults that work well out of the box. They've already made sensible choices about which storage, runtime, and networking components to include.
This pluggability is what makes Kubernetes so powerful for those who need it. Need a specific storage solution? Plug in a CSI driver. Want a more secure container runtime? Swap in a different CRI implementation. But for everyone else, the defaults will serve you just fine.
The beauty of this approach is that it gives you room to grow. Start with the defaults, and when you have specific requirements, the extension points are there waiting for you. That's the real magic of Kubernetes – it works great out of the box but doesn't limit your options as your needs evolve.
2025-02-27 08:00:00
So far, whenever I wanted to recycle a prompt from another context in Claude (though this also applies to ChatGPT and some other LLMs), I went back in my conversation history, copied the prompt, pasted it in a new chat and adjusted the context. But I recently discovered that Claude Projects can be misused as "prompt templates", which makes it way easier to handle repetitive tasks.
In Projects, you can set a system prompt that will be applied to all conversations in the project. I guess it's supposed to be used for relevant information about whatever you want to work on, but I like to think about a project more as a prompt template, rather than a project. For example, here's a project prompt that I use to brainstorm project ideas:
Ask me one question at a time so we can develop a thorough, step-by-step spec for this idea. Each question should build on my previous answers, and our end goal is to have a detailed specification I can hand off to a developer. Let’s do this iteratively and dig into every relevant detail. Remember, only one question at a time.
(Stolen from this great blog post)
While you could copy and paste this from a text file into every new conversation, Claude's projects make it super easy to save this as a template.
I guess this is an obvious feature for some people, but to me, it was a huge help once I found this out.
Got any other neat tricks for working with LLMs? I'd love to hear them!
2024-12-29 08:00:00
It's super exciting looking back at 2024. So much has happened! I haven't been very active on this blog lately, mainly because I've been super busy in other areas of life.
The biggest change for me this year is one that I can cross off of my impossible list: We bought a house! I've been wanting to write post about this for a few weeks, and now that things are settling in, I might have the time to do that. In short: We moved from Brunswick (Germany) back to a more rural town just outside Brunswick. It's closer to my girlfriends workplace, closer to my family and overall way cheaper than properties in Brunswick. We're super happy about the house and have yet to find any major annoyances. The neighbors are nice, and the community is incredibly wholesome.
As for other personal projects, there hasn’t been as much traction as there used to be. My interests have partially shifted to hobbies that don’t involve a computer, which I’m grateful for. I still love building software projects – especially now that it’s become so easy to get started with a project using an AI brainstorming companion – I just do it less often. I picked up running as a hobby (more on that later), gather with friends to play Dungeons & Dragons and work on stuff in my new basement.
These are the goals I set myself for 2024:
Build a side project that generated at least 100€ of value
That’s a bust. As mentioned, I haven’t really spent a lot of time building side projects. And the ones I did build, I consider tools rather than an income stream.
Get a scuba diving license
I’m a certified PADI Open Water Diver! You can see some impressions here and here.
Do a 10 km run (I really need to start moving again)
I ran three 10k runs this year. The first in May, then in June and finally, in September, I improved my 2018 personal best by a few minutes!
Sell my car
Check. More infos here.
Write at least 50 blog posts
I didn’t reach this goal, but I’m also not disappointed by it. The frequency of my posts varies, and this year it was just lower than before.
Here are some new goals for this year:
The results for last years predictions:
Bitcoin will at last reach a value of 100,000$, following the halving likely happening in 2024
Bitcoin did reach 100,000$, though not following the halving event. Still, I’d call this a pass!
SpaceX will use a Starship prototype to launch Starlink satellites into orbit
Nope, they didn’t. But they made incredible leaps.
Tesla cars a still not fully self driving (reference)
They claim to launch it in Europe earlier next year. It’s currently in closed testing. Still, I wouldn’t give it a pass.
Google will replace their main search with an AI chat bot (see Bard)
Not sure if I’d call Gemini a full replacement, but it does have a wrapper around their traditional search engine. The product is shit compared to Anthropic and OpenAI, but I would call this a pass, since you can use Gemini instead of Google Search.
And that's a wrap. I hope you all had a wonderful Christmas (if celebrated), and are as excited as I am for the new year!
2024-09-24 08:00:00
I just had the pleasure (cough) to connect an MSSQL database to a Laravel application at work. Because the process was super tedious, I wanted to quickly jot this down so I will never have to go through this again.
We're building a Laravel application with DDEV. DDEV essentially moves all development tools into Docker containers and adds some nice features like local database management.
Laravel comes with the boilerplate to use MSSQL out of the box. In your app, just set the database config to use sqlsrv:
php
'connections' => [
'sqlsrv' => [
'driver' => 'sqlsrv',
'url' => env('DB_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '1433'),
'database' => env('DB_DATABASE', 'laravel'),
'username' => env('DB_USERNAME', 'root'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => env('DB_CHARSET', 'utf8'),
'prefix' => '',
'prefix_indexes' => true,
// 'encrypt' => env('DB_ENCRYPT', 'yes'),
// 'trust_server_certificate' => env('DB_TRUST_SERVER_CERTIFICATE', 'false'),
],
],
You will see errors when starting your app, because you need to install the corresponding drivers first. Instead of adding them through Composer (a widely adopted package manager for PHP), you have to install the ODBC drivers through the system package manager, because Microsoft doesn't maintain a PHP package. Furthermore, you also have to install the driver repository because Microsoft doesn't even maintain packages for the major Linux distributions. In our setup with DDEV, this has to be done by amending the Dockerfile used for the application container. Create a file at .ddev/web-build/Dockerfile and add the following contents:
`dockerfile
ARG BASEIMAGE FROM $BASEIMAGE
RUN npm install --global forever RUN echo "Built on $(date)" > /build-date.txt
RUN curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg RUN curl https://packages.microsoft.com/config/debian/12/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
RUN apt-get update RUN apt-get --allow-downgrades -y install libssl-dev RUN apt-get -y update && yes | ACCEPTEULA=Y apt-get -y install php8.3-dev php-pear unixodbc-dev htop RUN ACCEPTEULA=Y apt-get -y install msodbcsql18 mssql-tools18 RUN sudo pecl channel-update pecl.php.net RUN sudo pecl install sqlsrv RUN sudo pecl install pdo_sqlsrv
RUN sudo printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.3/mods-available/sqlsrv.ini RUN sudo printf "; priority=30\nextension=pdosqlsrv.so\n" > /etc/php/8.3/mods-available/pdosqlsrv.ini RUN sudo phpenmod -v 8.3 -s cli sqlsrv pdosqlsrv RUN sudo phpenmod -v 8.3 -s fpm sqlsrv pdosqlsrv RUN sudo phpenmod -v 8.3 -s apache2 sqlsrv pdo_sqlsrv
RUN sudo printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.3/mods-available/sqlsrv.ini RUN sudo printf "; priority=30\nextension=pdosqlsrv.so\n" > /etc/php/8.3/mods-available/pdosqlsrv.ini RUN sudo phpenmod -v 8.3 -s cli sqlsrv pdosqlsrv RUN sudo phpenmod -v 8.3 -s fpm sqlsrv pdosqlsrv RUN sudo phpenmod -v 8.3 -s apache2 sqlsrv pdo_sqlsrv
RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
`
If you're reading this in the future and Microsoft may have released a new version of the ODBC drivers, you may have to follow the new installation instructions from their documentation. It took me a while to realize that I couldn't install version 17 of the driver because I was using the installation instructions for version 18. They are apparently incompatible with each other.
I hope that you'll never have to touch the shithole that is MSSQL, but if you do, I hope that this guide will be of value to you.
