What about cat food tuna?
Cats like tuna though
Can you give me an example json object?
Whats the structure of the json you want to change and what values do you want changed and filtered?
SELECT state, args->'params'->'inbox' FROM oban_jobs WHERE queue = 'federation_outgoing' AND args->'params'->>'inbox' IN ['list', 'of', 'values']
replace the lidt with whatever valies you want. the double arrow I added converts json to text and that might be your problem since it was comparing a json value to a list of strings.
That is assuming that the value you want to filter on is the inbox value in a json object structured like this:
{
"params":{
"inbox”:"filter on this”
}
}
ok I looked it up and it's postgreSQL. What specific values are you looking for, and what's the key you want?
That doesn't look like any sql I've ever seen but it looks like you might be missing commas/quotations around the value of your IN phrase. Try 'IN (["instance", "index"])'?
Again I've never even seen that syntax before so I can't do more than guess.
SELECT * FROM table WHERE json LIKE `%"field":"value"%`; and pray the json doesn't have any spaces.
The only solution is violence.
She's funny though.
Woman is the nigger of the world afterall.
He'll defederate individuals from poast just to make it harder for them to talk to their mutuals, so yeah I wouldn't expect him to run your instance honestly.
>giving your girlfriend your dullest knife
smh ngmi
They're so mentally unstable and their core worldview is so delusional that even polite disagreement upsets them deeply. He probably went through your timeline so he could assure himself that you were an evil nazi bigot terrible person and that was why you were slightly critical of him.
He probably went through your timeline looking for things to get mad about.
Yes hussy hates women with a burning passion.
He said something like "if you have doubts about how I handle user data you should leave."
Not sarcastic I guess but he wasn't telling josh to leave as much as trying to shut down the conversation because he was mad josh made a good point.
He makes a big post about how you should host your own instance for the health of the fedi and how he offers hosting services if you need help doing it every time his site gets an influx of users, and we all know he doesn't give a shit about the health of the fedi given how much he defederates over hurt feelings and criticism.