- today's pick · read the full storyAggregation pushdown below JOIN in the Cascades optimizer9/10ClickHouse/ClickHouse·feature·+3165-10Cost-based query optimizationQuery plan transformation rulesPartial aggregationJoin algorithms
- C-API-V2: Part 39/10duckdb/duckdb·feature·+36109-3627
- 21463 cursor compaction support for collections8/10apache/cassandra·feature·+8712-2082
- TimeSeries: stream the samples read in order for direct reads8/10ClickHouse/ClickHouse·performance·+134-0SQL query optimizationStreaming aggregationOrder-preserving data processingQuery plan optimization flags
- Adaptive codec selection for structural substreams8/10ClickHouse/ClickHouse·feature·+152-86Polymorphism via inheritance and virtual functionsStrategy design pattern for codec selectionUse of enums and type traits for codec pricingAdaptive algorithms for runtime codec selection
- [mlir][openacc] Avoid per-routine module walks in ACCRoutineToGPUFunc8/10llvm/llvm-project·performance·+60-17Symbol table manipulationModule-level transformationsOptimization of symbol renamingBatch processing of symbol uses
- vfs: load native addons from a mounted file system8/10nodejs/node·feature·+627-6Native addons integrationPlatform-specific file handlingAnonymous memory file descriptors (memfd)Temporary file management with automatic cleanup
- crypto: add Hybrid KEMs to Web Cryptography8/10nodejs/node·feature·+2300-35
- Add pagination of batch requests8/10microsoft/TypeScript·feature·+371-8PaginationCustom serializationGenerator functionsAPI client-server communication
- Perf: Improve perf of legacy Copilot CLI session listing & migration8/10microsoft/vscode·performance·+321-32Asynchronous programming with PromisesBatch processing and caching strategiesInterface design with optional methodsConditional logic for feature flags or session origin handling