Alex on Nostr: #Ditto admins: another big database migration: ...
#Ditto admins: another big database migration:
https://gitlab.com/soapbox-pub/ditto/-/merge_requests/453This one uses a jsonb column to index tags, which works way better that what we did previously and saves a lot of space.
gleasonator.dev, ditto.pub, and henhouse.social have all been updated.
Published at
2024-08-13 14:30:50Event JSON
{
"id": "d21da53dce42a78bc3e2550fb58bed9586f671ae09dd46f59d14e82f7d6ea7cc",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1723559450,
"kind": 1,
"tags": [
[
"t",
"ditto"
],
[
"r",
"https://gitlab.com/soapbox-pub/ditto/-/merge_requests/453"
],
[
"zap",
"781a1527055f74c1f70230f10384609b34548f8ab6a0a6caa74025827f9fdae5",
"wss://gleasonator.dev/relay",
"5"
],
[
"zap",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"wss://gleasonator.dev/relay",
"95"
]
],
"content": "#Ditto admins: another big database migration: https://gitlab.com/soapbox-pub/ditto/-/merge_requests/453\n\nThis one uses a jsonb column to index tags, which works way better that what we did previously and saves a lot of space.\n\ngleasonator.dev, ditto.pub, and henhouse.social have all been updated.",
"sig": "b809841cff52a213429c85e339b68d53558b4cbb6369ebc29ba913d2dbff7f6cd70c4e849f69e19ee3f758241c5be116bef61441d14a1f286bb008c71f297baf"
}