Skip to content

Instantly share code, notes, and snippets.

@wont-work
wont-work / star.sql
Created January 31, 2024 17:20
the cursed sql to convert all heart reactions to star reactions in misskey
BEGIN;
UPDATE note_reaction
SET reaction='⭐'
WHERE reaction='❤';
UPDATE note
SET reactions = jsonb_set(reactions, '{⭐}', ((reactions->>'❤')::int + coalesce((reactions->>'⭐')::int, 0))::text::jsonb)
WHERE (reactions->>'❤')::int >= 0;

Lemmy 101

A (hopefully not as complicated as the others) introduction to Lemmy

Short link for easy sharing: w.on-t.work/lemmy101

How do I sign up?

Notice: Spam campaigns targeting Lemmy providers are already happening, so quite a few of them are moving to requiring

@wont-work
wont-work / lemmy.user.css
Last active December 19, 2023 07:49
Userstyle "lemmy for the old.reddit.com refugee"
/* ==UserStyle==
@name lemmy for the old.reddit.com refugee
@namespace github.com/ShittyKopper
@version 1.0.1
@description tweaks
@author @ShittyKopper@lemmy.blahaj.zone
@updateURL https://gist.githubusercontent.com/ShittyKopper/7c812a68b815fa6f93501e0596c2cdee/raw/lemmy.user.css
==/UserStyle== */
@-moz-document domain("beehaw.org"),
regexp("https?://lemmy.*")