# Temporal data

Data whose values, availability, or validity depend on time, commonly represented as time series, event sequences, or timestamped records.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## IBM releases SOTA Granite Time Series PatchTST-FM-r2 model with commercial-friendly license

DevFeed: [IBM releases SOTA Granite Time Series PatchTST-FM-r2 model with commercial-friendly license](<https://devfeed.tech/articles/ibm-releases-sota-granite-time-series-patchtst-fm-r2-model-with-commercial-friendly-license-7266.md>)

Original publisher: [Read original article](<https://huggingface.co/blog/ibm-research/ibm-releases-sota-granite-time-series>)

Author: Roman Vaculin; Wesley M Gifford; Jiri Navratil; Chandra Reddy; Ayhan Sebin

Published: 2026-09-09T15:36:24Z

Content type: release

Language: en

Sources: [Hugging Face - Blog](<https://devfeed.tech/sources/hugging-face-blog.md>)

Topics: [foundation-models](<https://devfeed.tech/topics/foundation-models.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [releases](<https://devfeed.tech/topics/releases.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>), [Open Source Models & Datasets](<https://devfeed.tech/topics/open-source-models-datasets.md>), [Inference](<https://devfeed.tech/topics/inference.md>)

Tags: [apache](<https://devfeed.tech/tags/apache.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [foundation-models](<https://devfeed.tech/tags/foundation-models.md>), [ibm](<https://devfeed.tech/tags/ibm.md>), [inference](<https://devfeed.tech/tags/inference.md>), [model-architecture](<https://devfeed.tech/tags/model-architecture.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [releases](<https://devfeed.tech/tags/releases.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [zero-shot](<https://devfeed.tech/tags/zero-shot.md>)

### AI overview

IBM released Granite Time Series PatchTST-FM-r2, a roughly 385M-parameter time-series foundation model for zero-shot forecasting. The article covers its architecture, probabilistic forecasting, missing-value imputation, benchmark results, licensing, and available reproducibility resources.

### Source excerpt

Time-series foundation models are changing the way forecasting systems are built. Instead of training and maintaining a separate model for every dataset, users can use a pretrained model and generate forecasts zero-shot. IBM has released Granite Time Series PatchTST-FM-r2, the latest model in the Granite TSFM family (github, blog).

## An AI tool for prioritizing candidate biomarkers from wearable sensor data

DevFeed: [An AI tool for prioritizing candidate biomarkers from wearable sensor data](<https://devfeed.tech/articles/an-ai-tool-for-prioritizing-candidate-biomarkers-from-wearable-sensor-data-6749.md>)

Original publisher: [Read original article](<https://research.google/blog/an-ai-tool-for-prioritizing-candidate-biomarkers-from-wearable-sensor-data/>)

Published: 2026-08-21T17:02:24Z

Content type: article

Language: en

Sources: [The latest research from Google](<https://devfeed.tech/sources/the-latest-research-from-google.md>)

Topics: [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [Generative AI](<https://devfeed.tech/topics/generative-ai.md>), [data](<https://devfeed.tech/topics/data.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Training AI Models](<https://devfeed.tech/topics/training-ai-models.md>), [Model Development](<https://devfeed.tech/topics/model-development.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [data](<https://devfeed.tech/tags/data.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [generative-ai](<https://devfeed.tech/tags/generative-ai.md>), [health-bioscience](<https://devfeed.tech/tags/health-bioscience.md>), [memory](<https://devfeed.tech/tags/memory.md>), [reasoning](<https://devfeed.tech/tags/reasoning.md>), [research](<https://devfeed.tech/tags/research.md>), [series](<https://devfeed.tech/tags/series.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [training](<https://devfeed.tech/tags/training.md>), [validation](<https://devfeed.tech/tags/validation.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

The Biomarker Discovery Framework is a supervised multi-agent system for prioritizing biomarker candidates from wearable-sensor data. It combines hypothesis generation, statistical analysis, model training, adversarial validation, and literature-grounded reasoning in a traceable six-phase workflow. Across three cohorts, it recovered known clinical signals, found convergent biomarkers across independent datasets, and improved downstream prediction when demographic features were included.

### Source excerpt

Generative AI

## Postgres 19: How Our Advice Has Changed Since We Wrote It

DevFeed: [Postgres 19: How Our Advice Has Changed Since We Wrote It](<https://devfeed.tech/articles/postgres-19-how-our-advice-has-changed-since-we-wrote-it-14482.md>)

Original publisher: [Read original article](<https://www.crunchydata.com/blog/postgres-19-how-our-advice-has-changed-since-we-wrote-it>)

Author: Christopher Winslett

Published: 2026-08-18T19:00:00Z

Content type: article

Language: en

Sources: [CrunchyData Blog](<https://devfeed.tech/sources/crunchydata-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [JIT](<https://devfeed.tech/topics/jit.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Linux](<https://devfeed.tech/topics/linux.md>)

Tags: [advice](<https://devfeed.tech/tags/advice.md>), [async](<https://devfeed.tech/tags/async.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [index](<https://devfeed.tech/tags/index.md>), [jit](<https://devfeed.tech/tags/jit.md>), [latency](<https://devfeed.tech/tags/latency.md>), [linux](<https://devfeed.tech/tags/linux.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgres-19](<https://devfeed.tech/tags/postgres-19.md>), [production-postgres](<https://devfeed.tech/tags/production-postgres.md>), [release](<https://devfeed.tech/tags/release.md>), [storage](<https://devfeed.tech/tags/storage.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

### AI overview

This article revisits earlier Crunchy Data guidance on loading, storage, indexes, and partitioning for the upcoming Postgres 19 release. It explains which changes in Postgres 18 and 19 affect that advice, including asynchronous I/O, parallel maintenance, BRIN and skip-scan behavior, partition operations, and JIT being disabled by default. The details are based on current betas and may change before general availability.

### Source excerpt

Revisiting Crunchy posts on COPY, TOAST, BRIN, covering indexes, and partitioning: what we said then, which Postgres versions changed the story, and what we recommend on Postgres 19.

## From User Sequences to Scaling Laws: A Multi-Stage Architecture for Meta's Ads Ranking

DevFeed: [From User Sequences to Scaling Laws: A Multi-Stage Architecture for Meta's Ads Ranking](<https://devfeed.tech/articles/from-user-sequences-to-scaling-laws-a-multi-stage-architecture-for-meta-s-ads-ranking-128.md>)

Original publisher: [Read original article](<https://engineering.fb.com/2026/08/05/ml-applications/from-user-sequences-to-scaling-laws-a-multi-stage-architecture-for-metas-ads-ranking/>)

Author: Steven De Gryze; Parshva Doshi; Sean O'Byrne; Arnold Overwijk; Dinesh Ramasamy; Lee Xiong

Published: 2026-08-05T19:20:20Z

Content type: article

Language: en

Sources: [Engineering at Meta](<https://devfeed.tech/sources/engineering-at-meta.md>), [Meta ML Applications](<https://devfeed.tech/sources/meta-ml-applications.md>)

Topics: [recommendation systems](<https://devfeed.tech/topics/recommendation-systems.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>)

Tags: [ads](<https://devfeed.tech/tags/ads.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [data-infrastructure](<https://devfeed.tech/tags/data-infrastructure.md>), [meta](<https://devfeed.tech/tags/meta.md>), [ml-applications](<https://devfeed.tech/tags/ml-applications.md>), [production-engineering](<https://devfeed.tech/tags/production-engineering.md>), [recommendation-systems](<https://devfeed.tech/tags/recommendation-systems.md>), [scaling-laws](<https://devfeed.tech/tags/scaling-laws.md>), [tokenization](<https://devfeed.tech/tags/tokenization.md>)

### AI overview

Meta describes a multi-stage sequence-model architecture for ads ranking that separates offline user modeling from lightweight online ranking. It also uses dense tokenization and target-aware attention to learn feature interactions, with reported conversion and ad-click lifts across Instagram and Facebook.

### Source excerpt

Every day, Meta's recommendation platforms handle billions of user interactions, generating rich temporal signals that capture individual preferences and intent across products, ads, and content. In our 2024 post on sequence learning for ads recommendations, we showed how modeling the order and timing of user actions (rather than relying on static, manually engineered sparse features) [...] Read More... The post From User Sequences to Scaling Laws: A Multi-Stage Architecture for Meta's Ads Ranking appeared first on Engineering at Meta.

## Personalizing Airbnb search by learning from the guest journey

DevFeed: [Personalizing Airbnb search by learning from the guest journey](<https://devfeed.tech/articles/personalizing-airbnb-search-by-learning-from-the-guest-journey-1219.md>)

Original publisher: [Read original article](<https://medium.com/airbnb-engineering/personalizing-airbnb-search-by-learning-from-the-guest-journey-bcefd1915624?source=rss----53c7c27702d5---4>)

Author: Daochen Zha

Published: 2026-07-21T17:01:04Z

Content type: article

Language: en

Sources: [The Airbnb Tech Blog - Medium](<https://devfeed.tech/sources/the-airbnb-tech-blog-medium.md>)

Topics: [Transformer](<https://devfeed.tech/topics/transformer.md>), [recommendation systems](<https://devfeed.tech/topics/recommendation-systems.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Data Science](<https://devfeed.tech/topics/data-science.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [blog](<https://devfeed.tech/tags/blog.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [model](<https://devfeed.tech/tags/model.md>), [recommendation-system](<https://devfeed.tech/tags/recommendation-system.md>), [research](<https://devfeed.tech/tags/research.md>), [scale](<https://devfeed.tech/tags/scale.md>), [search](<https://devfeed.tech/tags/search.md>), [technology](<https://devfeed.tech/tags/technology.md>), [training](<https://devfeed.tech/tags/training.md>)

### AI overview

Airbnb describes a Transformer-based sequence model for personalizing search by encoding years of guest behavior, including listing views, bookings, reviews, and cancellations. The system learns richer representations of guest preferences to improve listing relevance and booking conversion while addressing very long, noisy event sequences and the cost of training on hundreds of millions of search-label pairs.

### Source excerpt

How we built a Transformer-based sequence model that encodes years of guest behavior to surface the right listings at the right time. By: Daochen Zha, Chun How Tan, Xin Liu, Bin Xu, Han Zhao, Xiaowei Liu, Jun Shi, Tracy Yu, Hui Gao, Huiji Gao, Liwei He, Michael Kinoti, Stephanie Moyerman, and Sanjeev Katariya Introduction Planning a trip on Airbnb rarely happens in a single session. A guest searching for a place to stay in San Francisco might browse dozens of listings over several days, leaving behind a trail of views. Typically, over a period of years, that same guest will have accumulated many previous bookings, reviews, and the occasional cancellation. Taken together, these events reveal a great deal about what that guest values in a stay. For years, Airbnb's search ranking captured this through hand-crafted features: aggregated statistics such as total past bookings or average listing price. These worked well, but as the feature count grew into the hundreds, the approach became harder to scale and increasingly limited in expressiveness. In this blog post, we describe how we built a sequence modeling system that encodes the full guest journey using a Transformer, learning richer representations of guest preferences to deliver more personalized search results. An example of a guest journey, which is typically long, exploratory, and complex.Challenges Event sequences per guest present three core challenges. First, they are dominated by listing views, which account for the vast majority of all events -- some guests accumulate hundreds of thousands of them -- making raw sequences computationally intractable to model directly. The distribution of event types, with the majority being listing views. Second, unlike social media platforms, which optimize for engagement, Airbnb optimizes for booking conversion. Bookings are rare, compared to events, and deliberate, whereas a listing view could reflect genuine intent or simply idle browsing. Building a model that generalizes

## Devavrat Shah's research and Ikigai Labs use tabular data for real-time forecasting and decision-making

DevFeed: [Devavrat Shah's research and Ikigai Labs use tabular data for real-time forecasting and decision-making](<https://devfeed.tech/articles/helping-ai-models-to-meet-the-real-world-37954.md>)

Original publisher: [Read original article](<https://news.mit.edu/2026/helping-ai-models-meet-real-world-0714>)

Author: David Chandler | Laboratory for Information and Decision Systems

Published: 2026-07-14T20:25:00Z

Content type: article

Language: en

Sources: [MIT AI News](<https://devfeed.tech/sources/mit-ai-news.md>)

Topics: [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [decision-making](<https://devfeed.tech/topics/decision-making.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>), [AI Models](<https://devfeed.tech/topics/ai-models.md>), [data](<https://devfeed.tech/topics/data.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>), [Computer science](<https://devfeed.tech/topics/computer-science.md>), [Electrical engineering and computer science (EECS)](<https://devfeed.tech/topics/electrical-engineering-and-computer-science-eecs.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-and-decision-making](<https://devfeed.tech/tags/ai-and-decision-making.md>), [ai-in-business-planning](<https://devfeed.tech/tags/ai-in-business-planning.md>), [ai-models](<https://devfeed.tech/tags/ai-models.md>), [algorithms](<https://devfeed.tech/tags/algorithms.md>), [artificial-intelligence](<https://devfeed.tech/tags/artificial-intelligence.md>), [business-and-management](<https://devfeed.tech/tags/business-and-management.md>), [business-modeling](<https://devfeed.tech/tags/business-modeling.md>), [celonis-context-model](<https://devfeed.tech/tags/celonis-context-model.md>), [computer-science-and-technology](<https://devfeed.tech/tags/computer-science-and-technology.md>), [data](<https://devfeed.tech/tags/data.md>), [data-systems](<https://devfeed.tech/tags/data-systems.md>), [decision-making](<https://devfeed.tech/tags/decision-making.md>), [devavrat-shah](<https://devfeed.tech/tags/devavrat-shah.md>), [electrical-engineering-and-computer-science-eecs](<https://devfeed.tech/tags/electrical-engineering-and-computer-science-eecs.md>), [faculty](<https://devfeed.tech/tags/faculty.md>), [forecasting](<https://devfeed.tech/tags/forecasting.md>), [idss](<https://devfeed.tech/tags/idss.md>), [ikigailabs](<https://devfeed.tech/tags/ikigailabs.md>), [laboratory-for-information-and-decision-systems-lids](<https://devfeed.tech/tags/laboratory-for-information-and-decision-systems-lids.md>), [mit-eecs](<https://devfeed.tech/tags/mit-eecs.md>), [mit-idss](<https://devfeed.tech/tags/mit-idss.md>), [mit-intellectual-property](<https://devfeed.tech/tags/mit-intellectual-property.md>), [mit-lids](<https://devfeed.tech/tags/mit-lids.md>), [mit-schwarzman-college-of-computing](<https://devfeed.tech/tags/mit-schwarzman-college-of-computing.md>), [predictions](<https://devfeed.tech/tags/predictions.md>), [profile](<https://devfeed.tech/tags/profile.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [research](<https://devfeed.tech/tags/research.md>), [school-of-engineering](<https://devfeed.tech/tags/school-of-engineering.md>), [startups](<https://devfeed.tech/tags/startups.md>), [structured](<https://devfeed.tech/tags/structured.md>), [tabular-data](<https://devfeed.tech/tags/tabular-data.md>), [time-series-data](<https://devfeed.tech/tags/time-series-data.md>)

### AI overview

MIT Professor Devavrat Shah's research led to a foundation model for tabular and time-series enterprise data. Developed with Ikigai Labs, the system continuously tests predictions against real outcomes to support large-scale forecasting and decision-making.

### Source excerpt

Through research and entrepreneurship, Professor Devavrat Shah is helping to design methods that can handle constant decision-making using limited computational resources.

## ClickHouse vs Prometheus for High Cardinality, Part 2: Cardinality in ClickHouse

DevFeed: [ClickHouse vs Prometheus for High Cardinality, Part 2: Cardinality in ClickHouse](<https://devfeed.tech/articles/clickhouse-vs-prometheus-for-high-cardinality-part-2-cardinality-in-clickhouse-5160.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-vs-promethous-high-cardinality-part-2-cardinality-in-clickhouse>)

Author: Rory Crispin; Dale McDiarmid

Published: 2026-05-15T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Prometheus](<https://devfeed.tech/topics/prometheus.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [data](<https://devfeed.tech/topics/data.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [databases](<https://devfeed.tech/tags/databases.md>), [logs](<https://devfeed.tech/tags/logs.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [observability](<https://devfeed.tech/tags/observability.md>), [prometheus](<https://devfeed.tech/tags/prometheus.md>), [systems](<https://devfeed.tech/tags/systems.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

This article examines how ClickHouse and other column-oriented databases handle high-cardinality observability data differently from Prometheus and other series-oriented time-series databases. It explains that ClickHouse shifts much of the cost from ingestion to query time and models telemetry as wide, timestamped events with dimensions, attributes, and measurements that can be aggregated later. The article also notes that ClickHouse is not a drop-in replacement for Prometheus and requires a different approach to telemetry, instrumentation, and aggregation.

### Source excerpt

In this blog, we explore why high cardinality behaves fundamentally differently in column-oriented databases like ClickHouse, and why the costs appear in very different places than in traditional series-based systems like Prometheus.

## Using group theory to explore the space of positional encodings for attention

DevFeed: [Using group theory to explore the space of positional encodings for attention](<https://devfeed.tech/articles/using-group-theory-to-explore-the-space-of-positional-encodings-for-attention-20221.md>)

Original publisher: [Read original article](<https://blog.janestreet.com/using-group-theory-to-explore-positional-encodings-attention/>)

Author: Alok Puranik

Published: 2026-04-22T00:00:00Z

Content type: article

Language: en

Sources: [Jane Street](<https://devfeed.tech/sources/jane-street.md>)

Topics: [Language models](<https://devfeed.tech/topics/language-models.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [blog-post](<https://devfeed.tech/tags/blog-post.md>), [language-models](<https://devfeed.tech/tags/language-models.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [ml](<https://devfeed.tech/tags/ml.md>)

### AI overview

The article examines positional encodings for attention using group theory. It argues that formalizing desirable properties leaves only a few valid families, most of which are already used in real systems, while also identifying a technically valid but apparently unexplored class.

### Source excerpt

Attention is a computational primitive at the core of modern language models, allowing internal representations to reference and influence each other. It's how these models handle sequential data in the first place.

## The generative recommender behind Shopify's commerce engine

DevFeed: [The generative recommender behind Shopify's commerce engine](<https://devfeed.tech/articles/the-generative-recommender-behind-shopify-s-commerce-engine-1401.md>)

Original publisher: [Read original article](<https://shopify.engineering/generative-recommendations>)

Author: Yang Liu

Published: 2026-02-25T16:04:54Z

Content type: article

Language: en

Sources: [Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering.md>), [Shopify Engineering - Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering-shopify-engineering.md>)

Topics: [Shopify](<https://devfeed.tech/topics/shopify.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [model-deployment](<https://devfeed.tech/topics/model-deployment.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Feature Engineering](<https://devfeed.tech/topics/feature-engineering.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [feature-engineering](<https://devfeed.tech/tags/feature-engineering.md>), [generative](<https://devfeed.tech/tags/generative.md>), [latency](<https://devfeed.tech/tags/latency.md>), [model](<https://devfeed.tech/tags/model.md>), [production](<https://devfeed.tech/tags/production.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [scale](<https://devfeed.tech/tags/scale.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [train](<https://devfeed.tech/tags/train.md>), [training](<https://devfeed.tech/tags/training.md>)

### AI overview

Shopify describes a generative recommender that treats buyer journeys as raw event sequences. An autoregressive, causally masked model predicts next products or ads while meeting real-time production constraints at Shopify's scale.

### Source excerpt

Treating buyer journeys as sequences instead of simplified signals, and building a model fast enough to serve at scale.

## ClickHouse achieves AWS Financial Services Competency

DevFeed: [ClickHouse achieves AWS Financial Services Competency](<https://devfeed.tech/articles/clickhouse-achieves-aws-financial-services-competency-4975.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/aws-financial-services-competency>)

Author: Aditya Chidurala

Published: 2025-12-12T00:00:00Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Security, Privacy and Abuse Prevention](<https://devfeed.tech/topics/security-privacy-and-abuse-prevention.md>), [AI, ML & Data Engineering](<https://devfeed.tech/topics/ai-ml-data-engineering.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [aws](<https://devfeed.tech/tags/aws.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [financial-services](<https://devfeed.tech/tags/financial-services.md>), [fraud](<https://devfeed.tech/tags/fraud.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [partners](<https://devfeed.tech/tags/partners.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

ClickHouse announces its AWS Financial Services Competency and describes how financial organizations use its analytics platform for high-volume, low-latency workloads.

### Source excerpt

ClickHouse has achieved AWS Financial Services Competency, joining a select group of AWS Partners recognized for deep expertise in serving financial services organizations.

## Building Real-Time AI: Highlights from the AWS MCP Hackathon in San Francisco

DevFeed: [Building Real-Time AI: Highlights from the AWS MCP Hackathon in San Francisco](<https://devfeed.tech/articles/building-real-time-ai-highlights-from-the-aws-mcp-hackathon-in-san-francisco-4978.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/aws-mcp-hackathon-san-francisco>)

Author: Zoe Steinkamp

Published: 2025-11-20T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [AI Bots](<https://devfeed.tech/topics/ai-bots.md>), [Kafka](<https://devfeed.tech/topics/kafka.md>), [incident](<https://devfeed.tech/topics/incident.md>), [Orchestration](<https://devfeed.tech/topics/orchestration.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bedrock](<https://devfeed.tech/tags/bedrock.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [hackathon](<https://devfeed.tech/tags/hackathon.md>), [incident](<https://devfeed.tech/tags/incident.md>), [kafka](<https://devfeed.tech/tags/kafka.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [observability](<https://devfeed.tech/tags/observability.md>), [orchestration](<https://devfeed.tech/tags/orchestration.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

A ClickHouse recap of three AWS MCP Hackathon projects that use live and streaming data for ad bidding, incident response, and glucose monitoring.

### Source excerpt

How teams used ClickHouse to power agents with streaming data, sub-second analytics, and production-ready dashboards at the AWS MCP Hackathon.

## Calendar and Time-Zone Complexities in Software

DevFeed: [Calendar and Time-Zone Complexities in Software](<https://devfeed.tech/articles/dates-aren-t-what-they-used-to-be-30746.md>)

Original publisher: [Read original article](<http://blog.vanillajava.blog/2024/12/pre.html>)

Author: Peter Lawrey (noreply@blogger.com)

Published: 2024-12-20T14:20:00Z

Content type: opinion

Language: en

Sources: [Vanilla Java](<https://devfeed.tech/sources/vanilla-java.md>)

Topics: [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>)

Tags: [exercise](<https://devfeed.tech/tags/exercise.md>), [info](<https://devfeed.tech/tags/info.md>), [pitfalls](<https://devfeed.tech/tags/pitfalls.md>), [time](<https://devfeed.tech/tags/time.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

This commentary explains why date and time handling is complex in software. It discusses time zones, calendar systems, cultural conventions, and historical changes that can cause incorrect date arithmetic and other defects.

### Source excerpt

I find time fascinating and surprisingly complex. Time zones and calendars change from place to place over time. There are a number of interesting websites on the subject. Time is one of those concepts that appears deceptively simple on the surface yet becomes increasingly intricate the more we examine it. As software developers, we often face scenarios where we must handle dates and times and their myriad associated rules--time zones, calendar systems, cultural conventions, and historical irregularities. Working with time can lead us into subtle pitfalls that affect everything from straightforward user interfaces to global financial systems. Time is an illusion. Lunchtime doubly so. -- Douglas Adams The Hitchhiker's Guide to the Galaxy The Surprising Complexity Behind Time Time is not uniform. Humans have invented calendar systems and measurement techniques, each influenced by politics, religion, and culture. As a result, how we record and interpret dates has repeatedly changed over the centuries. These shifts mean that historical dates do not map cleanly onto modern calendars. The Julian and Gregorian calendars, the French Revolutionary calendar, and the attempts by certain countries to gradually or abruptly adjust to the Gregorian standard all introduce tricky discontinuities. We also have complex local customs, such as the Korean age-counting system, or unique historical anomalies like Sweden's February 30th in 1712. Understanding these anomalies is crucial when dealing with historical data sets, genealogical records, financial time series that stretch back centuries, or any domain that involves retrospective data analysis. From a technical perspective, these complexities translate into potential defects. Off-by-one errors, incorrect conversions, or failure to account for historical shifts can lead to incorrect date arithmetic. Even if you never work with centuries-old data, these quirks are cautionary tales: time is never as straightforward as it first appears. H

## How Supergood unlocked their Postgres developer productivity

DevFeed: [How Supergood unlocked their Postgres developer productivity](<https://devfeed.tech/articles/how-supergood-unlocked-their-postgres-developer-productivity-5368.md>)

Original publisher: [Read original article](<https://neon.com/blog/how-supergood-unlocked-their-postgres-developer-productivity>)

Author: Carlota Soto

Published: 2024-02-20T18:01:16Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [case-studies](<https://devfeed.tech/tags/case-studies.md>), [database](<https://devfeed.tech/tags/database.md>), [developer-productivity](<https://devfeed.tech/tags/developer-productivity.md>), [observability](<https://devfeed.tech/tags/observability.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [redis](<https://devfeed.tech/tags/redis.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

A case study of Supergood's use of Neon and database branching to improve Postgres development productivity while processing API metrics and time-series data.

### Source excerpt

"Neon allows us to develop much faster than we've even been used to. In traditional setups, you're just trying to get the data that is representative of real customers--but now, when we build a feature, we're actually testing it on real data in a matter of minutes. We can get feat...

## Real-world Insights: Anomaly Detection in Internet Traffic

DevFeed: [Real-world Insights: Anomaly Detection in Internet Traffic](<https://devfeed.tech/articles/real-world-insights-anomaly-detection-in-internet-traffic-28043.md>)

Original publisher: [Read original article](<https://tech.trivago.com/post/2024-02-13-real-world-insights-anomaly-detection-in-internet-traffic/>)

Author: Peter Brejcak Senior Data Scientist

Published: 2024-02-13T00:00:00Z

Content type: article

Language: en

Sources: [Trivago](<https://devfeed.tech/sources/trivago.md>)

Topics: [Internet Traffic](<https://devfeed.tech/topics/internet-traffic.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Data Science](<https://devfeed.tech/topics/data-science.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [anomaly-detection](<https://devfeed.tech/tags/anomaly-detection.md>), [data-science](<https://devfeed.tech/tags/data-science.md>), [internet-traffic](<https://devfeed.tech/tags/internet-traffic.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [quality](<https://devfeed.tech/tags/quality.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [user-experience](<https://devfeed.tech/tags/user-experience.md>)

### AI overview

This article explains how trivago approaches anomaly detection in partner-level internet traffic. It focuses on practical business implementation, emphasizing that abrupt changes in time series may result from dynamic input parameters and expected traffic shifts rather than genuine anomalies.

### Source excerpt

Anomaly detection for time series is like finding unusual events in a sequence of data over time. It helps identify outliers or deviations from the expected pattern, signaling potential issues or anomalies in the dataset. This is the theory, but how does it translate into practical implementation for real business needs?

## Pre-processing temporal data made easier with TensorFlow Decision Forests and Temporian

DevFeed: [Pre-processing temporal data made easier with TensorFlow Decision Forests and Temporian](<https://devfeed.tech/articles/pre-processing-temporal-data-made-easier-with-tensorflow-decision-forests-and-temporian-7387.md>)

Original publisher: [Read original article](<https://blog.tensorflow.org/2023/09/forecasting-with-tensorflow-decision-forests-and-temporian.html>)

Author: TensorFlow Blog (noreply@blogger.com)

Published: 2023-09-11T20:14:00Z

Content type: article

Language: en

Sources: [The TensorFlow Blog](<https://devfeed.tech/sources/the-tensorflow-blog.md>)

Topics: [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Temporian](<https://devfeed.tech/topics/temporian.md>), [TensorFlow Decision Forests](<https://devfeed.tech/topics/tensorflow-decision-forests.md>), [Feature Engineering](<https://devfeed.tech/topics/feature-engineering.md>), [Python](<https://devfeed.tech/topics/python.md>), [datasets](<https://devfeed.tech/topics/datasets.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [data](<https://devfeed.tech/tags/data.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [feature-engineering](<https://devfeed.tech/tags/feature-engineering.md>), [logs](<https://devfeed.tech/tags/logs.md>), [machine-learning](<https://devfeed.tech/tags/machine-learning.md>), [python](<https://devfeed.tech/tags/python.md>), [sales](<https://devfeed.tech/tags/sales.md>), [temporal-data](<https://devfeed.tech/tags/temporal-data.md>), [temporian](<https://devfeed.tech/tags/temporian.md>), [tensorflow-decision-forests](<https://devfeed.tech/tags/tensorflow-decision-forests.md>), [time-sequences](<https://devfeed.tech/tags/time-sequences.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [user-event](<https://devfeed.tech/tags/user-event.md>)

### AI overview

This article demonstrates preprocessing temporal sales data with Temporian and forecasting weekly sales with TensorFlow Decision Forests. It explains event sets, aggregation, moving sums, indexing, and the trade-off between transactional detail and uniformly sampled time series.

### Source excerpt

Posted by Google: Mathieu Guillame-Bert, Richard Stotz, Robert Crowe, Luiz GUStavo Martins (Gus), Ashley Oldacre, Kris Tonthat, Glenn Cameron, and Tryolabs: Ian Spektor, Braulio Rios, Guillermo Etchebarne, Diego Marvid, Lucas Micol, Gonzalo Marín, Alan Descoins, Agustina Pizarro, Lucía Aguilar, Martin Alcala Rubi Temporal data is omnipresent in applied machine learning applications. Data often changes over time or is only available or valuable at a certain point in time. For example, market prices and weather conditions change constantly. Temporal data is also often highly discriminative in decision-making tasks. For example, the rate of change and interval between two consecutive heartbeats provides valuable insights into a person's physical health, and temporal patterns of network logs are used to detect configuration issues and intrusions. Hence, it is essential to incorporate temporal data and temporal information in ML applications. INFO: Temporian is a new open-source Python library for preprocessing and feature engineering temporal data for machine learning applications. It is developed in collaboration between Google and Tryolabs. Check the sister blog post for more details. This blog post demonstrates how to train a forecasting model on transactional data. Specifically, we will show how to forecast the total weekly sales from individual sales records. For the modeling part, we will use TensorFlow Decision Forests as they are well suited to handle temporal data. To feed the transaction data to our model, and to compute temporal specific features, we will use Temporian, a newly released library designed for ingesting and aggregating transactional data from multiple non-synchronized sources. Time series are the most commonly used representation for temporal data. They consist of uniformly sampled values, which can be useful for representing aggregate signals. However, time series are sometimes not sufficient to represent the richness of available data. Instead

## Announcing OpenTSDB 2.4.0: Rollup and Pre-Aggregation Storage, Histograms, Sketches, and More

DevFeed: [Announcing OpenTSDB 2.4.0: Rollup and Pre-Aggregation Storage, Histograms, Sketches, and More](<https://devfeed.tech/articles/announcing-opentsdb-2-4-0-rollup-and-pre-aggregation-storage-histograms-sketches-and-more-20496.md>)

Original publisher: [Read original article](<https://yahooeng.tumblr.com/post/181461332311>)

Author: amberwilsonla-blog

Published: 2018-12-27T17:01:17Z

Content type: release

Language: en

Sources: [Yahoo](<https://devfeed.tech/sources/yahoo.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>), [Hadoop](<https://devfeed.tech/topics/hadoop.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>)

Tags: [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [databases](<https://devfeed.tech/tags/databases.md>), [hadoop](<https://devfeed.tech/tags/hadoop.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [release](<https://devfeed.tech/tags/release.md>), [salesforce](<https://devfeed.tech/tags/salesforce.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [workflows](<https://devfeed.tech/tags/workflows.md>), [yahoo-engineering](<https://devfeed.tech/tags/yahoo-engineering.md>)

### AI overview

OpenTSDB 2.4.0 is released with rollup and pre-aggregation storage for time series data, along with histograms and sketches. The release focuses on retaining lower-resolution data for longer periods, reducing query workloads, and supporting more accurate percentile analysis across multiple series.

### Source excerpt

yahoodevelopers: By Chris Larsen, Architect OpenTSDB is one of the first dedicated open source time series databases built on top of Apache HBase and the Hadoop Distributed File System. Today, we are proud to share that version 2.4.0 is now available and has many new features developed in-house and with contributions from the open source community. This release would not have been possible without support from our monitoring team, the Hadoop and HBase developers, as well as contributors from other companies like Salesforce, Alibaba, JD.com, Arista and more. Thank you to everyone who contributed to this release! A few of the exciting new features include: Rollup and Pre-Aggregation Storage As time series data grows, storing the original measurements becomes expensive. Particularly in the case of monitoring workflows, users rarely care about last years' high fidelity data. It's more efficient to store lower resolution "rollups" for longer periods, discarding the original high-resolution data. OpenTSDB now supports storing and querying such data so that the raw data can expire from HBase or Bigtable, and the rollups can stick around longer. Querying for long time ranges will read from the lower resolution data, fetching fewer data points and speeding up queries. Likewise, when a user wants to query tens of thousands of time series grouped by, for example, data centers, the TSD will have to fetch and process a significant amount of data, making queries painfully slow. To improve query speed, pre-aggregated data can be stored and queried to fetch much less data at query time, while still retaining the raw data. We have an Apache Storm pipeline that computes these rollups and pre-aggregates, and we intend to open source that code in 2019. For more details, please visit http://opentsdb.net/docs/build/html/user_guide/rollups.html. Histograms and Sketches When monitoring or performing data analysis, users often like to explore percentiles of their measurements, such as the 9

## Redis on Raspberry Pi for Embedded and IoT Applications

DevFeed: [Redis on Raspberry Pi for Embedded and IoT Applications](<https://devfeed.tech/articles/redis-on-the-raspberry-pi-adventures-in-unaligned-lands-20602.md>)

Original publisher: [Read original article](<http://antirez.com/news/111>)

Published: 2017-02-24T09:52:30Z

Content type: opinion

Language: en

Sources: [Antirez](<https://devfeed.tech/sources/antirez.md>)

Topics: [Raspberry Pi](<https://devfeed.tech/topics/raspberry-pi.md>), [Redis](<https://devfeed.tech/topics/redis.md>), [Internet of things](<https://devfeed.tech/topics/iot.md>), [Arm](<https://devfeed.tech/topics/arm.md>), [Linux](<https://devfeed.tech/topics/linux.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Data structures](<https://devfeed.tech/topics/data-structures.md>), [Debian](<https://devfeed.tech/topics/debian.md>)

Tags: [arm](<https://devfeed.tech/tags/arm.md>), [data-type](<https://devfeed.tech/tags/data-type.md>), [debian](<https://devfeed.tech/tags/debian.md>), [iot](<https://devfeed.tech/tags/iot.md>), [linux](<https://devfeed.tech/tags/linux.md>), [raspberry-pi](<https://devfeed.tech/tags/raspberry-pi.md>), [redis](<https://devfeed.tech/tags/redis.md>), [streams](<https://devfeed.tech/tags/streams.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

The article discusses adapting Redis to run on Raspberry Pi and its potential use in embedded and IoT devices. It highlights Redis Streams for storing sensor data and time series, along with Redis's small memory footprint and suitability for small ARM devices.

### Source excerpt

After 10 million of units sold, and practically an endless set of different applications and auxiliary devices, like sensors and displays, I think it's deserved to say that the Raspberry Pi is not just a success, it also became one of the preferred platforms for programmers to experiment in the embedded space. Probably with things like the Pi zero, it is also becoming the platform in order to create hardware products, without incurring all the risks and costs of designing, building, and writing software for vertical devices. Well, I love to think that also Redis is a platform that programmers like to use when to hack, experiment, build new things. Moreover devices that can be used for embedded / IoT applications, often have the problem of temporarily or permanently storing data, for example received by sensors, on the device, to perform on-device computations or to send them to remote servers. Redis is adding a "Stream" data type that is specifically suited for streams of data and time series storage, at this point the specification is near complete and work to implement it will start in the next weeks. Redis existing data structures, and the new streams, together with the small memory footprint, the decent performances it can provide even while running on small hardware (and resulting low energy usage), looked like a good match for Raspberry Pi potential applications, and in general for small ARM devices. The missing piece was the obvious one: to run well on the Pi. One of the many cool things about the Pi is that its development environment does not look like the embedded development environments of a few years ago... It just runs Linux, with all the Debian-alike tooling you expect to find. Basically adapting Redis to work on the Pi was not a huge task. The most fundamental mismatch a Linux system program and the Pi could have, is a performance / footprint mismatch, but this a non issue because of the Redis design itself: an empty instance consumes a total of 1MB of

## Apache Cassandra in a Microservices Enterprise Platform

DevFeed: [Apache Cassandra in a Microservices Enterprise Platform](<https://devfeed.tech/articles/apache-cassandra-in-a-microservices-enterprise-platform-31994.md>)

Original publisher: [Read original article](<https://tech.finn.no2015/04/28/Apache-Cassandra-in-a-Microservices-Enterprise-Platform/>)

Author: mick

Published: 2015-04-28T14:00:00Z

Content type: article

Language: en

Sources: [Finn.no](<https://devfeed.tech/sources/finn-no.md>)

Topics: [Apache Cassandra](<https://devfeed.tech/topics/cassandra.md>), [Microservice](<https://devfeed.tech/topics/microservice.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>)

Tags: [apis](<https://devfeed.tech/tags/apis.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [cassandra](<https://devfeed.tech/tags/cassandra.md>), [coupling](<https://devfeed.tech/tags/coupling.md>), [enterprise](<https://devfeed.tech/tags/enterprise.md>), [event-driven](<https://devfeed.tech/tags/event-driven.md>), [microservices](<https://devfeed.tech/tags/microservices.md>), [rest](<https://devfeed.tech/tags/rest.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

The article discusses Apache Cassandra as a persistence layer for microservices platforms, particularly for systems that need scalability and time-series data models. It also outlines microservices practices involving isolated runtime APIs, reduced coupling, REST, and producer-defined schemas for event-driven designs.

### Source excerpt

In this article we'll explore how Apache Cassandra, the world's most popular wide column store and 8th most popular database overall, will only grow as a cornerstone technology in a microservices platform. With a little theory to microservices, to some examples of microservices and underlying required infrastructure, we'll show that any solution both capable of scaling and dealing with time-series data-models is going to need to depend upon Apache Cassandra as a persistence layer, despite having a polyglot persistence model at large. microservices Microservices is a term that's come out of ThoughtWorks' Martin Fowler and James Lewis. It's a bit of a buzzword, basically a fresh revival of the parts of service orientated architecture that you should be focusing on and getting right. A lot of it hopefully is obvious to you already. If you've been doing service orientated architecture or even generally just unix programming properly over the years it might well be frustrating just how buzz "microservices" has become. But it's worth keeping in mind how much garbage we've collected and how many aspects of service orientated architecture that we've gotten badly wrong over the years. Younger programmers certainly deserve the clarity that ThoughtWorks is giving us here. Microservices, following the tips and guidelines from Sam Newman, can basically be broken down into four groups. interfaces Ensure that you standardise the systems architecture at large and especially the gaps or what we know as the APIs between services. Standardise upon practices and protocols that minimise coupling. Move from tightly coupled systems with many compile time dependencies and distributed published client libraries, to clearly defined and isolated runtime APIs. Take advantage of REST, especially level 3 in richardson's maturity model, for the synchronous domain driven designed parts of your system. When it comes to event driven design use producer defined schemas, like that offered by Apache Th

## Real-Time Counts with Stitch

DevFeed: [Real-Time Counts with Stitch](<https://devfeed.tech/articles/real-time-counts-with-stitch-2122.md>)

Original publisher: [Read original article](<https://developers.soundcloud.com/blog//real-time-counts-with-stitch>)

Published: 2014-07-03T00:00:00Z

Content type: article

Language: en

Sources: [SoundCloud Backstage Blog](<https://devfeed.tech/sources/soundcloud-backstage-blog.md>)

Topics: [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [web applications](<https://devfeed.tech/topics/web-applications.md>), [incident](<https://devfeed.tech/topics/incident.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [batch](<https://devfeed.tech/tags/batch.md>), [cassandra](<https://devfeed.tech/tags/cassandra.md>), [data](<https://devfeed.tech/tags/data.md>), [hadoop](<https://devfeed.tech/tags/hadoop.md>), [race-condition](<https://devfeed.tech/tags/race-condition.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

SoundCloud describes Stitch, a Cassandra-backed system for real-time count time series. It combines stream processing with batch MapReduce/Hadoop processing and evolves toward a Lambda Architecture-style design to address non-idempotent counter updates.

### Source excerpt

Here at SoundCloud, in order to provide counts and a time series of counts in real time, we created something called Stitch. Stitch was...

## MySQL for Statistics - Old Faithful

DevFeed: [MySQL for Statistics - Old Faithful](<https://devfeed.tech/articles/mysql-for-statistics-old-faithful-2089.md>)

Original publisher: [Read original article](<https://developers.soundcloud.com/blog//mysql-stats-old-faithful>)

Published: 2011-07-05T00:00:00Z

Content type: article

Language: en

Sources: [SoundCloud Backstage Blog](<https://devfeed.tech/sources/soundcloud-backstage-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>)

Tags: [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [events](<https://devfeed.tech/tags/events.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [persistence](<https://devfeed.tech/tags/persistence.md>), [statistics](<https://devfeed.tech/tags/statistics.md>), [storage](<https://devfeed.tech/tags/storage.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

The article describes using MySQL with InnoDB for statistics persistence after MongoDB disk thrashing. It examines read-optimized storage, indexed play logs, aggregation requirements, time ranges, and query I/O behavior at multi-billion-row scale.

### Source excerpt

MySQL turns out to be a good Swiss Army Knife for persistence, if used wisely. Understanding disk access patterns driven by your storage...