Show newer

MastoAdmin SQL queries to get followers/following by remote domains 

tip because at least on our version the Domain summary will *count* the number of following relations, but with has no way to list who is following who.

Postgres queries:

"Their followers here":
```
SELECT user_follows.username, user_follows.domain, user_following.username as follows, user_following.domain as follows_domain FROM follows INNER JOIN accounts AS user_follows ON user_follows.id=follows.account_id INNER JOIN accounts AS user_following ON user_following.id=follows.target_account_id WHERE user_following.domain='gts-dev.pixie.town';
```

"Our followers there":
```
SELECT user_follows.username, user_follows.domain, user_following.username as follows, user_following.domain as follows_domain FROM follows INNER JOIN accounts AS user_follows ON user_follows.id=follows.account_id INNER JOIN accounts AS user_following ON user_following.id=follows.target_account_id WHERE user_follows.domain='gts-dev.pixie.town';
```

in other news im considering designing my own 2s quadcopter lipo charger 🤔 🤔

like this emax one is decent, but it only has 2 ports, and the other 2 ports are for 1s so i never use them. so a nice 4 port multi-charger with a similar design would be great, probably usb type-c too

I had big issues introducing profile fields to the existing design, just nothing looked quite right. So after lots of pondering and experimenting I tried out this layout on a whim (it's similar to mastodon 3.x profiles) and actually quite like what I ended up at

Show thread

i've mostly vagueposted about it before because it's a quick tool I wanted to build for myself, with no time for prolonged support/additional features

but I made a medication tracker that fits better with my personal (adhd) needs, namely no set schedule, but still getting reminders to take the next dose after a certain interval.

After evaluating existing options f-droid.org/en/packages/dev.co came closest, but when used in 'take as needed' mode, there's no notification/interval options at all, and my general rhythm isn't consistent enough for anything pre-scheduled.

code in git.pixie.town/f0x/remind-my-m, react-native was quite nice to use actually. it's easy to sideload an apk to android stuff but for iOS that's left as an exercise to the reader

all the solar panels are freezing, if you're cold they're cold let them in

basically that with the standard plunger design, you need the space in the back for the fully extended plunger arm, so that's why the cheap nerf blasters use that same arm to pull back, instead of a sliding grip

Show thread
Show older
Pixietown

Small server part of the pixie.town infrastructure. Registration is closed.