Conversation

Notices

1. nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:09:07 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
   • Izuru Yakumo (八雲 出流) repeated this.
   • nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:11:05 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';
   • nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:11:47 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
   • rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:12:56 JST rat

     in reply to
     @nyanide ok
     nyanide :nyancat_rainbow::nyancat_body::nyancat_face: likes this.
   • rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:13:11 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.
   • nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:13:32 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
   • rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:24:06 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.
   • rat (rat@brain.worm.pink)'s status on Thursday, 06-Feb-2025 13:44:53 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.
   • nyanide :nyancat_rainbow::nyancat_body::nyancat_face: (nyanide@lab.nyanide.com)'s status on Thursday, 06-Feb-2025 13:45:19 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