Signalcrest
← Back to feed
stackoverflowdata

Select one subset or another depending on condition in a single query

Conditional query solution

Steady

13

signal score

🔗 4

sources · postgres

Steady

7-day est. ~8

Why this scored 13

every term, weighted
Velocity+0.9 / 40 max

Engagement per hour, normalized against the fastest item on its own source

Acceleration+0.0 / 25 max

Whether that velocity is itself speeding up, as a per-hour rate

Cross-source spread+8.3 / 25 max

How many independent communities are talking about the same entity

Recency+5.4 / 10 max

Decays to zero over 14 days

Saturation penalty2.0 / 30 max

Subtracted once something is big and old — we rank what's next, not what's peaked

Composite12.6

Weights are hand-tuned, not learned — we're calibrating them against realized trends as history accumulates. On a topic's first sighting there's no previous reading to compare against, so acceleration starts from a neutral prior rather than a measurement. Full methodology

Outlook

low confidence · estimate, not a guarantee

7-day

~8

range 79

14-day

~8

range 69

30-day

~7

range 69

Signal history

7-day window (free)

— — projected trajectory (estimate, not a guarantee)

Entities

pythonpostgressqlalchemy
Embed a live signal badge
Signalcrest signal badge
[![Signalcrest signal](https://www.signalcrest.app/api/badge/so%3A79989464)](https://www.signalcrest.app/topic/so%3A79989464)

Drop this in a README or blog post — it updates automatically as the score moves.