trans dating stats (-) Show more
here's a very interesting thread about trans dating stats that i don't want to outright boost for some reason maybe because it's depressing as fuck but i am so not surprised and i hate cis people for how they treat us most of the fucking time but anyway here it is one more proof to the pile that we are mostly despised
Scandales politiques autours des Prides (France) Show more
Bordeaux : la Mairie décale la Pride d'un jour pour laisser des fachos LGBTIphobes cracher leur haine (LMPT).
Lyon : annulation de la marche pour cause de pluie et... de présence d'un Pink Bloc, politique et radical.
Tours : le service d'ordre géré par Centre LGBTI et sous directives de la préfecture, empêche pancartes trop politiques, slogans antifas, anti-gouvernementaux, anti-flics, etc.
TOUT VA BIEN
My personal journey from MIT to GPL
big SQL query Show more
I just wrote an SQL query to find which accounts use the most storage space:
select * from (
select accounts.username, accounts.domain, sum(media_attachments.file_file_size) as media_size
inner join accounts on (media_attachments.account_id=accounts.id)
group by accounts.id order by media_size desc
) as t
where t.media_size is not null
to run it: "su postgres", then "psql mastodon_production", then type it in the shell
on follow requests i'd like to let people "public-follow" me. for when i want them to be allowed to follow me and see my public toots, but never send them private toots. (and silence + that would be the most stealthy way to nearly-block someone, as they don't get any way to tell without comparing toots with another of your followers)
singular they Show more
Prescriptivists: Singular they is weird, I refuse to use it.
Also, English: The negation of "am I" is "aren't I"
Python/Rust/Debian enthusiast. Trekkie.
GPG key: 0E082B40E4376B1E.
@_ZN3val on Twitter and @progval on Github
oc.todon.fr is an actively-moderated mostly French-speaking Mastodon instance. oc.todon.fr est une instance Mastodon principalement francophone et avec une modération active.