Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://gleasonator.com/objects/fed14fc9-3bb2-4cf8-9991-0aada976f7a4">Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 08-Aug-2023 02:58:31 JST</a><a href="https://gleasonator.com/users/alex" title="alex@gleasonator.com"><img src="https://gnusocial.jp/avatar/1712-48-20220726020642.webp" width="48" height="48" alt="Alex Gleason" style="position: absolute; left: 0; top: 0;">Alex Gleason</a><div><a href="https://shitposter.club/objects/f807fb70-ad0f-4623-98af-998faebb0f00" rel="in-reply-to">in reply to</a><ul><li></ul></div></section><article><a href="https://shitposter.club/users/Moon">@Moon</a> That's what I'm trying to figure out. One of the devs replied to me here pointing out the code that's doing it: <a href="https://github.com/PrimalHQ/primal-caching-service/issues/8#issuecomment-1667925661">https://github.com/PrimalHQ/primal-caching-service/issues/8#issuecomment-1667925661</a><br><br>I think you could maybe segment particular events based on the first X characters of their hex ID. But I don't know how you query that.</article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/1919143#notice-3766927">In conversation</a><time datetime="2023-08-08T02:58:31+09:00" title="Tuesday, 08-Aug-2023 02:58:31 JST">about a year ago</time> <span>from <span><a href="https://gleasonator.com/objects/fed14fc9-3bb2-4cf8-9991-0aada976f7a4" rel="external" title="Sent from gleasonator.com via ActivityPub">gleasonator.com</a></span></span><a href="https://gleasonator.com/objects/fed14fc9-3bb2-4cf8-9991-0aada976f7a4">permalink</a><h4>Attachments</h4><ol><li><article><header><div>Domain not in remote thumbnail source whitelist: opengraph.githubassets.com</div><h5><a href="https://github.com/PrimalHQ/primal-caching-service/issues/8#issuecomment-1667925661">Question: Does this store events in SQLite? · Issue #8 · PrimalHQ/primal-caching-service</a></h5><div></div></header><div>I'm trying to understand this code. I see SQLite being used. Is that really the main data store? You're indexing almost the entirety of Nostr with SQLite? If so, how?</div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 08-Aug-2023 02:58:31 JSTAlex Gleason
in reply to
- Sexy Moon
@Moon That's what I'm trying to figure out. One of the devs replied to me here pointing out the code that's doing it: https://github.com/PrimalHQ/primal-caching-service/issues/8#issuecomment-1667925661

I think you could maybe segment particular events based on the first X characters of their hex ID. But I don't know how you query that.
In conversationabout a year ago from gleasonator.compermalink
Attachments
1. Domain not in remote thumbnail source whitelist: opengraph.githubassets.com
  Question: Does this store events in SQLite? · Issue #8 · PrimalHQ/primal-caching-service
  I'm trying to understand this code. I see SQLite being used. Is that really the main data store? You're indexing almost the entirety of Nostr with SQLite? If so, how?

Public

Embed Notice

HTML Code

Corresponding Notice