Leinonen

Code, Mindfulness & Minimalism

Building Safe SQL Queries in Go: A PostgreSQL Query Builder

By Peter Leinonen on September 24, 2025

Building Safe SQL Queries in Go: A PostgreSQL Query Builder

Stop relying on string concatenation for SQL queries in Go and embrace a safer, more maintainable approach with a type-safe query builder. This blog post outlines the pitfalls of string concatenation, such as SQL injection risks and maintainability challenges, and introduces a robust query builder solution. Learn how this tool enhances security by using parameterized queries, improves readability with a fluent interface, and ensures type safety. Enhance your Go applications with secure, efficient, and easily testable SQL query construction.

Read more

Custom Unmarshallers in Go: Parsing Data Your Way

By Peter Leinonen on September 21, 2025

Custom Unmarshallers in Go: Parsing Data Your Way

Discover how to leverage custom unmarshallers in Go to handle complex real-world data parsing challenges. This blog post explores the use of Go's json.Unmarshaler interface to transform inconsistent API data into clean, type-safe structures. Learn how to convert string values to enums, manage nested JSON objects, and implement validation directly in the unmarshalling process. With tips on performance, error handling, and testing, this guide helps you maintain clean and efficient code while managing messy external data formats. Perfect for developers looking to streamline data transformation in Go applications.

Read more

My Journey with the ZSA Voyager

By Peter Leinonen on August 15, 2025

My Journey with the ZSA Voyager

Dive into my transformative journey with the ZSA Voyager split keyboard, where initial skepticism turned into ergonomic triumph. Discover how embracing a columnar layout and a minimalist 40-key modification challenged my typing habits, leading to enhanced speed, accuracy, and reduced strain. Learn about the strategic layering system, the crucial role of practice, and the surprising benefits of tactile switches and blank keycaps. If you're considering a split keyboard adventure, find out why patience and perseverance can yield extraordinary rewards for your typing experience and productivity.

Read more

Why Developers Should Switch from Coffee to Matcha

By Peter Leinonen on August 13, 2025

Why Developers Should Switch from Coffee to Matcha

Switching from coffee to matcha can transform a developer's productivity routine. Unlike coffee's energy spikes and crashes, matcha provides a steady 4-6 hours of "calm alertness" thanks to L-theanine, enhancing focus and concentration. This powerful combination promotes a meditative state ideal for thoughtful coding, reduces distractions, and supports better decision-making. Beyond productivity, matcha is gentler on the stomach, rich in antioxidants, and can be part of a mindful ritual to start your day. Try matcha for sustained energy and improved health, and see how it elevates your coding sessions.

Read more