Unconventional PostgreSQL Optimizations
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
Explores the power of simplicity and minimalism in technology, design, and life, arguing for intentional subtraction over addition.
A technical guide on common pitfalls and best practices for implementing foreign key constraints in database design, using Django examples.
A guide to creating generic C# helper methods with enum constraints for reading Description attributes in .NET.
Tips for improving UIKit layout efficiency using AutoLayout constraints, aspect ratios, and proper view sizing techniques.
Explores how to use Bean Validation annotations to enforce invariants on Java 14+ record types, ensuring data integrity for immutable objects like DTOs.
Explores how to enforce data validation rules on Java 14+ record types using the Bean Validation API (Hibernate Validator).
A tutorial on implementing iOS Auto Layout programmatically, covering rotation support, constraints, and animation.
Strategies for performing safe, low-downtime database migrations in PostgreSQL, focusing on adding columns and creating indexes on large tables.
Reflections on the benefits of constraints and collaboration at an R programming 'unconference', where participants built packages in two days.
A design philosophy advocating for starting iOS app design with a watch-sized interface to identify core features and improve focus.