On Sunday I improved the story page caches to refill in the background and be durable across deploys, so during yesterday's Monday morning peak traffic, the app ticked along averaging 4 rps. Most of those do not write to the db.
SQLite is way more than performant enough for our needs.
Peter Bhat Harkins
npub12n…2u94e
2026-07-28 14:45:03 UTC
in reply to nevent1q…zadw
Author Public Key
npub12nzu70elj8k5jqc46cgdd9q7qd40xzky2rvtwglm6sx3kd7cu8vsk2u94eSeen on
wss://relay.ditto.pubPublished at
2026-07-28 14:45:03 UTCEvent JSON
{
"id": "1a866f1482c12a0231ab16d53d9279855f55ae9843c3bec8a48e755a5303e89f",
"pubkey": "54c5cf3f3f91ed490315d610d6941e036af30ac450d8b723fbd40d1b37d8e1d9",
"created_at": 1785249903,
"kind": 1,
"tags": [
[
"e",
"f6c2ffb3627a182c1a2a2e4f9fd57388b2c0c26307c1d83e366b8e3b7474b7be",
"wss://relay.ditto.pub",
"reply"
],
[
"proxy",
"https://ruby.social/users/pushcx/statuses/116998137658838278",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "On Sunday I improved the story page caches to refill in the background and be durable across deploys, so during yesterday's Monday morning peak traffic, the app ticked along averaging 4 rps. Most of those do not write to the db.\n\nSQLite is way more than performant enough for our needs.",
"sig": "7f5ca56796c42aa069b911917bf5318c43c90e1e980033bc24111e577ac96856a01d20802f7313a3fd193ca23b2c0cbc695afc05f1e2a33d157362e1aaf1c4f8"
}