This is referring to that the ActivityPub
implementation Pleroma (https://pleroma.social/)
is using JSONB practically for everything
in a very simple schema.
https://bidule.menf.in/notice/42923
Alice
@alice@bidule.menf.in
Oooh I love postgresql's jsonb type !
I accidently set the background image
for my pleroma account and didn't find
a way to delete it in the interface.
So I searched a bit in the database and
quickly found that the column users.info
contained it (quite easy).
At first, I didn't know about jsonb,
so I thought it was a string and I was
in for a painful REGEXP_REPLACE to
remove the "background" property of
the object. Then the psql interpreter
complained about my trying to use
REGEXP_REPLACE on a jsonb value, I read
about it and realised my UPDATE would be
as simple as :
UPDATE users SET info = info -
'background' WHERE id = 1;
(that's right, my id is 1, that's what
you get for opening your own instance
?
May 10, 2018, 18:59 · 1 · 0
--
Marcin