Analysis of the most popular personal blogs on Hacker News in 2025, based on a tracking project that ranks domains by their performance on the platform.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
A guide to emulating window functions in MySQL 5.7 using local variables, highlighting the limitations and risks of this approach.
A technical guide on using SQL GROUP BY with window functions to retrieve the first or last value in a group, using a PostgreSQL event table example.
A technical deep dive into solving PostgreSQL disk space issues by optimizing a deduplication query, focusing on reducing sort key size.
A collection of lesser-known but powerful PostgreSQL features and tips shared by the developer community, from data types to performance tricks.
Explains how to use SQL window functions and percentiles in Postgres for more meaningful data analysis than simple averages.
![Sessionizing Log Data Using dplyr [Follow-up]](https://alldevblogs.blob.core.windows.net/thumbs/article-29f99ec93e7c-full-62a10501.webp)
A technical tutorial on sessionizing log data using the dplyr package in R, comparing it to a previous SQL-based approach.
A technical guide on using SQL window functions to group discrete time-series events into user sessions for data analysis.
A technical guide on using SQL window functions, specifically LAG, to calculate month-over-month revenue growth percentages for SaaS or recurring billing analysis.
A detailed list of technical advantages and features that make PostgreSQL a powerful and versatile database choice for developers.
