Skip to main content
@alex I just got an idea...what if #Soapbox could incorporate trends by picking a #Mastodon instance (preferably the closest peer) as its trend "anchor" and mirroring the trends it recieves from that instance?
#mastodon #soapbox @Alex Gleason
Alex Gleason
Alex Gleason  
•
It could, but we should just implement trends. 🙂
e
e  
•
planning on it :monkaGun:
e
e  
•
timescaledb, a postgres ext, has continuous aggregates if you want to try it yourself

https://docs.timescale.com/timescaledb/latest/overview/core-concepts/continuous-aggregates/
Alex Gleason
Alex Gleason  
•
Better than Redis, but I can tell you adding that extension is going to ruin someone's day.
e
e  
•
it's part of the postgres contrib package so most installs have it
⇧