Osma A on Nostr: Carlos Guerreiro That's far more fixed-function and more code than a simple data ...
Carlos Guerreiro (npub12ld…d8ag) That's far more fixed-function and more code than a simple data collection python script and a datasette frontend, though.
I worked around the problem with a trigger function simulating an aggregated materialized view. What used to time out now executes well below 1 second per query.
Published at
2023-11-30 15:39:03Event JSON
{
"id": "38ecf99bb4d32160c9fb3bc3b93e23516e551aed86c18004c57a7c6575855a83",
"pubkey": "c5e911ba68147d9efc284a4a7069358904dff0d4a5e93d6df545dd97d64e1fd3",
"created_at": 1701358743,
"kind": 1,
"tags": [
[
"p",
"57dace5579fd19afd4917681a71954d6853152f7272a4647f95bb5b5b4b082a2",
"wss://relay.mostr.pub"
],
[
"e",
"59320d6e23ae6a5c474b6e3f62894769e9ed5d1cb2a4f2922531117b6c791216",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://mas.to/users/osma/statuses/111500246583455623",
"activitypub"
]
],
"content": "nostr:npub12ldvu4tel5v6l4y3w6q6wx2566znz5hhyu4yv3letw6mtd9ss23qrhd8ag \nThat's far more fixed-function and more code than a simple data collection python script and a datasette frontend, though.\n\nI worked around the problem with a trigger function simulating an aggregated materialized view. What used to time out now executes well below 1 second per query.",
"sig": "87aa5dbc7f68b8a942894a426c826c61c1697e1ca4bf9d23edcb9ba5baf3a4da81c403c15e93379df53d690741be2a087ab9ea68d42f032d83d4d9a34e4feaa8"
}
