its mostly for my own troubleshooting. main views to use are nostr_events and nostr_users which can be joined by pubkey column (the base nostr table is very hard to use). basic query might be

`select u.name, e.*

from nostr_events e

join nostr_users u on e.pubkey = u.pubkey

where e.kind = 1

and e.content like '%randomstring%'

`

Reply to this note

Please Login to reply.

Discussion

Thanks, I’ll play around with it

Hey. I forked the client(❤️) and added parse for magnet links. Using webtorrent, for now the torrent client is declared in the new component that I created also modified basepost to support it(I started yesterday).

1 - Do you like the idea?

2 - help with the architecture?

3.- Is it the markdown component that works with the "media"?

4 -... 😀👍

you know i'm starting to, but don't have a full understanding. this person forked astral and suggested the same thing https://github.com/monlovesmango/astral/issues/74

and yes the parsing happens in the markdown component, trying to keep everything in there if I can

Y! :D