By Peter Leinonen on September 24, 2025
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 moreBy Peter Leinonen on September 21, 2025
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 moreBy Peter Leinonen on August 15, 2025
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 moreBy Peter Leinonen on August 13, 2025
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