Explores three new LINQ methods (Index, CountBy, AggregateBy) coming in C# 13 and .NET 9, with code examples for each.
Explores techniques to significantly improve MongoDB aggregation performance using parallel processing and sharding on distributed clusters.
A guide to Prometheus's aggregation functions like avg_over_time and sum_over_time for analyzing time series data, with pseudocode examples.
A guide to using pandas' groupby and aggregation functions for data analysis, covering basic to complex custom operations.
A technical guide comparing Django ORM GROUP BY queries with their SQL equivalents, aimed at developers comfortable with SQL.
A technical exploration of ksqlDB window start times, including creating streams, inserting test data, and querying windowed aggregations.
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 tutorial on using CASE statements in ksqlDB to pivot and aggregate event stream data, similar to SQL PIVOT operations.
Explores how to speed up MongoDB's $facet aggregation stage using parallel processing for faster data analysis.
Practical tips for optimizing Django database interactions, covering aggregation filters, namedtuples, and custom functions.
A guide to using PostgreSQL's array_agg function to efficiently aggregate and format data, avoiding manual application-level processing.
Explains the GROUPING SETS operator in SQL Server for flexible data aggregation, comparing it to UNION ALL and WITH CUBE approaches.
A comparison of early social aggregators FriendFeed and Socialthing, analyzing their strengths for tech conversations versus personal social updates.
