Alex Gleason on Nostr: Fun fact, SQLite is faster than an in-memory database with 1000 events for _certain_ ...
Fun fact, SQLite is faster than an in-memory database with 1000 events for _certain_ queries.
Published at
2024-03-26 18:44:13Event JSON
{
"id": "5fd5092ca95df8801d520272cc804b024e3ea2d7efedd149b01826ebeaba72ae",
"pubkey": "79c2cae114ea28a981e7559b4fe7854a473521a8d22a66bbab9fa248eb820ff6",
"created_at": 1711475053,
"kind": 1,
"tags": [
[
"zap",
"79c2cae114ea28a981e7559b4fe7854a473521a8d22a66bbab9fa248eb820ff6",
"wss://relay.mostr.pub",
"0.915"
],
[
"zap",
"6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9",
"wss://relay.mostr.pub",
"0.085"
],
[
"proxy",
"https://gleasonator.com/objects/d5300606-5391-4895-abba-48612f8bdbe5",
"activitypub"
]
],
"content": "Fun fact, SQLite is faster than an in-memory database with 1000 events for _certain_ queries.\n\nhttps://media.gleasonator.com/c2d9c2d8e7cae3912ab5a63b22ecc9080f3c4d2360fd05214cc34cfebc2846c1.png",
"sig": "32d75afdab1322a5ce31694e1f07f3d4eb4774e6d64f7e64080d3e1ba384aefdfff692f50e46f7c1d2133f164aab2168c82f854e8005929e6091892a666fef46"
}