i still think social media with linear timelines should have like a "incase you missed it" mixed in that is solely based on how infrequently an account posts

[Guest]

@gabboman add this to wafrn

[gabboman@app.wafrn.net]

Interesting

[Guest]

Bluesky has a feed called Quiet Posters which is specifically posts from accounts you follow that post infrequently. And if you have that feature where the app mixes in posts from your feeds into your Following, the experience is almost exactly like that

[gabboman@app.wafrn.net]

The problem is im afraid of a complex sql query like that one haha

[julian@activitypub.space]

gabboman@app.wafrn.net do two separate queries and combine them afterwards. Join the dark side and thank me later.

[gabboman@app.wafrn.net]

I do so many queries and join them on the frontend itself. I could investigate… but right now im in a bugfixing/essentials phase again before adding cool new features

[thepinkhacker@app.wafrn.net]

have you tried offloading the whole database to the client?

[gabboman@app.wafrn.net]

Hmmm 400gb

[julian@activitypub.space]

Heat me out — each user gets a small shard of the database stored in LocalStorage and it is eventually consistent.

[thepinkhacker@app.wafrn.net]

Huffman coding - Wikipedia

(en.wikipedia.org)

This should probably get it down to like 12 KiBs

[julian@activitypub.space]

probably less. Most memes are just derivatives of each other right.