dharmik on Nostr: Paolo Amoroso SQLite is so fast, they compete with fopen. For some use cases, you can ...
Paolo Amoroso (nprofile…u6pm)SQLite is so fast, they compete with fopen. For some use cases, you can use SQLite instead of a filesystem, that can be 35% faster.
i’d love a deep dive into this.
Published at
2025-01-02 13:11:20Event JSON
{
"id": "c9e05cddc4a836778258e8d1c7e45bc7ef9314dde0d08015c933b73c4f0d6a70",
"pubkey": "24d53b5b7fdb0dad7d0082b11763b21324af150e6daa8d0c0bb9b150a1e54568",
"created_at": 1735823480,
"kind": 1,
"tags": [
[
"p",
"d515918d32bc4dd40240fe70cdc87a50fcf2676abe40bd9797c4189a4d3bffd3",
"wss://relay.mostr.pub"
],
[
"e",
"2c1d36b0f6ec7b8d17de545e7560608f2340860ec395aab6a655138bb64b9860",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://linuxusers.in/dharmik/p/1735823480.210046",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpq652errfjh3xagqjqlecvmjr62r70yem2heqtm9uhcsvf5nfmllfsshu6pm\nSQLite is so fast, they compete with fopen. For some use cases, you can use SQLite instead of a filesystem, that can be 35% faster.\ni’d love a deep dive into this.\n",
"sig": "9202ecfa608972a5ddd16744b594e2314e7fdd363098a28da8003c68786767bb42b602afa92843c339572c634f9a4b8479e2d64915fec96b891dfaaeaa9157d9"
}
