ikeji on Nostr: a% echo "SELECT content FROM event " | sqlite3 /tmp/nostr.db | jq .content | ruby -e ...
a% echo "SELECT content FROM event " | sqlite3 /tmp/nostr.db | jq .content | ruby -e 'ARGF.each do |e| p Regexp.last_match[1] if e =~ /h(ttps?:\/\/[a-z.\/_0-9]+)/ end' | sort | uniq -c | sort -nr
36588 "ttps://nostr.build/i/nostr.build_84654219840c78104b3ca4603b60fc733fff11882b954dc8d17f8d380fccdcbb.jpg"
28254 "ttps://nostr.build/i/nostr.build_93143e29aba1774db6148a4fe36f05da2cac1628db84f39afeb6d9208b69ab64.jpg"
22581 "ttps://i.postimg.cc/"
4 "ttps://github.com/"
3 "ttps://note.com/erechorse/n/n122bfbef9c92"
2 "ttps://verifiedhuman.net"
2 "ttps://test.ikeji.ma/nostrwiki/"
2 "ttps://stacker.news/r/h3y6e"
おい
36588 "ttps://nostr.build/i/nostr.build_84654219840c78104b3ca4603b60fc733fff11882b954dc8d17f8d380fccdcbb.jpg"
28254 "ttps://nostr.build/i/nostr.build_93143e29aba1774db6148a4fe36f05da2cac1628db84f39afeb6d9208b69ab64.jpg"
22581 "ttps://i.postimg.cc/"
4 "ttps://github.com/"
3 "ttps://note.com/erechorse/n/n122bfbef9c92"
2 "ttps://verifiedhuman.net"
2 "ttps://test.ikeji.ma/nostrwiki/"
2 "ttps://stacker.news/r/h3y6e"
おい