Alex Gleason on Nostr: It outperformed Postgres querying large time-based datasets. Eg "trending hashtags in ...
It outperformed Postgres querying large time-based datasets. Eg "trending hashtags in the past year".
Key-value stores will give you more performance of course, but you are essentially building a custom datastore.
SQLite is great for being an all-in-one embedded solution, and I'm gonna love it until I witness the performance being bad firsthand.
Published at
2023-08-22 16:11:48Event JSON
{
"id": "515d1a5b975fefe9b07d9837d4815781aa2c8180444fa9c67c76e2fee5fe48b8",
"pubkey": "79c2cae114ea28a981e7559b4fe7854a473521a8d22a66bbab9fa248eb820ff6",
"created_at": 1692720708,
"kind": 1,
"tags": [
[
"p",
"ee11a5dff40c19a555f41fe42b48f00e618c91225622ae37b6c2bb67b76c4e49",
"wss://relay.mostr.pub"
],
[
"e",
"645c035c0c26c23371e2f29263b5c43685f7edd287ae2abd5bf0660a95489efc",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://gleasonator.com/objects/171d2aff-31ce-4246-ba72-85ce261ce5ad",
"activitypub"
]
],
"content": "It outperformed Postgres querying large time-based datasets. Eg \"trending hashtags in the past year\". \n\nKey-value stores will give you more performance of course, but you are essentially building a custom datastore.\n\nSQLite is great for being an all-in-one embedded solution, and I'm gonna love it until I witness the performance being bad firsthand.",
"sig": "43f3f85851f64803721d8f0eb27921766f389a58b112a0a4bee6091b9db71cfa9ebfbc491f88d7dba2b24dbbdef5488d640b59430b1a5df046d1b9575800e48a"
}
