Working with time in Postgres
A guide to using PostgreSQL's built-in time and date functions, including intervals and date_trunc, for efficient time-based data queries and reporting.
A guide to using PostgreSQL's built-in time and date functions, including intervals and date_trunc, for efficient time-based data queries and reporting.
An introduction to Progressive Web Apps (PWAs), explaining their purpose, value, and history.
A React tutorial on building an infinite scroll component, converting a functional component to a class and adding scroll event listeners.
Explains JavaScript callbacks: what they are, why they're important, and how to use them with practical examples.
Analyzes the true value of startup stock options versus cash compensation, questioning if the risk-reward for employees is justified.
Argues against using nested routes in RESTful API design, advocating for simpler, single-resource endpoints with query parameters.
A conceptual exploration of why Swift closures are named 'closures', explaining variable capturing with a swimming pool analogy.
Explores the origin of the term 'closure' in Swift, using synonyms and a swimming pool analogy to explain variable capturing.
A developer shares their experience migrating from Jekyll to Hugo due to slow build times, detailing the process and benefits.
Explains the CSS minmax() function for creating flexible grid layouts with minimum and maximum size constraints.
Discusses the challenges of using outdated Office 365 training materials and offers strategies for identifying relevant, up-to-date content.
Explores a C programming pattern using incomplete struct types to achieve generic-like behavior, improving type safety over void pointers.
Testing the limits of an R language detection package by finding English sentences it misclassifies and exploring algorithmic decision-making.
Explains CSS Custom Properties (CSS Variables), their dynamic capabilities, and practical use cases for cleaner, modular front-end code.
A guide on integrating the Needle iOS security testing tool into a Jenkins CI/CD pipeline for automated vulnerability detection.
A technical guide on implementing Azure Active Directory authentication in ASP.NET Core 2.0, covering setup and configuration changes.
Optimizing QWERTY keyboard layout to minimize thumb travel distance for Swype-style typing.
A conference organizer reflects on launching ScriptConf, a JavaScript event in Linz, and helping organize the developer conference #devone.
The article compares classes and functions in JavaScript, arguing that functional programming leads to simpler, more maintainable code.
Explores using Alpine Linux to create significantly smaller Docker images compared to standard Debian-based ones.