Conversation

Notices

1. Embed this notice
   nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:09:08 JST nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
   a lot of raw activitypub note objects all with fediblock tags and all seperated by newlines would be very useful right now
   • Embed this notice
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:11:07 JST nyanide :nyancat_rainbow::nyancat_body::nyancat_face:

     in reply to

     yes this is an invitation to give me data from your database!!!!!!!!!!!!

     if you're a pleromer admin you can do this in psql while in pleroma db

     pleroma# \o /tmp/poop.txt pleroma# select data from objects where data->>'type'='Note' and data->'tag'->0->>'type'='Hashtag' and data->'tag'->0->>'name'='#fediblock';
   • Embed this notice
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:11:48 JST nyanide :nyancat_rainbow::nyancat_body::nyancat_face:

     in reply to
     that'll slap the results of the query into poop.txt which you can send to MEEEEEEEEE
     
     if you so desire
   • Embed this notice
     rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:12:28 JST rat

     in reply to
     @nyanide ok
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: likes this.
   • Embed this notice
     rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:13:01 JST rat

     in reply to

     • rat
     @nyanide im kinda scared though the podman container is volatile im scared to touch it
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: likes this.
   • Embed this notice
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:13:34 JST nyanide :nyancat_rainbow::nyancat_body::nyancat_face:

     in reply to

     • rat
     @rat you just need to access the pleroma db not touch pleroma itself
   • Embed this notice
     rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:23:30 JST rat

     in reply to
     @nyanide well the db is in a container so idk if i can use psql shell without like running it inside the container :flambert: and the db container might die aftetr i run this shit it did something like that before im kind of a retard :ratstar:
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: likes this.
   • Embed this notice
     rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:44:35 JST rat

     in reply to

     • rat
     @nyanide ok i just ran it i got 1051 rows
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: likes this.
   • Embed this notice
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:45:20 JST nyanide :nyancat_rainbow::nyancat_body::nyancat_face:

     in reply to

     • rat
     @rat do you have the thing outputted to a file? thats what the first command does
     
     if you do give that grubby file to me
   • Embed this notice
     rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:45:38 JST rat

     in reply to
     @nyanide yeah i did the \o