Alex Gleason on Nostr: The main limitation of SQLite is that it locks up when you try to write too much to ...
The main limitation of SQLite is that it locks up when you try to write too much to it at once. This makes it "not a great use-case for social media". Not even due to your posts, but because of all the likes and emoji reactions you guys do. I still haven't hit any of those limits in my own experience. But writing to multiple database files could help it a lot, I bet.
Published at
2023-08-07 17:57:03Event JSON
{
"id": "2865a4ad90129cbcf4adcd02f7411f7215f00d961825504168110fb80df2da84",
"pubkey": "79c2cae114ea28a981e7559b4fe7854a473521a8d22a66bbab9fa248eb820ff6",
"created_at": 1691431023,
"kind": 1,
"tags": [
[
"p",
"79c2cae114ea28a981e7559b4fe7854a473521a8d22a66bbab9fa248eb820ff6",
"wss://relay.mostr.pub"
],
[
"e",
"9fb672af90b30fb2b9109d40fd1c760e9ce16d57f6483f5c7aa4bc1d94520dce",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://gleasonator.com/objects/10f494bb-0284-4872-a553-fff91891f8dc",
"activitypub"
]
],
"content": "The main limitation of SQLite is that it locks up when you try to write too much to it at once. This makes it \"not a great use-case for social media\". Not even due to your posts, but because of all the likes and emoji reactions you guys do. I still haven't hit any of those limits in my own experience. But writing to multiple database files could help it a lot, I bet.",
"sig": "229c31b72e8bf3b799619913e9444b6c5743006a65692d7cb0d8943f6481b1988a6ee4224f4d41bd0eccf349fbfaa769f719a1a0c4b6b51aa291dee41e73cecf"
}
