Zach "earboxer" DeCook @zachdecook@librem.one

Dear everyone, don't use #gmail. They don't play nice with other email providers: I've been unable to send anything to a gmail address in the last week, and there's seemingly nothing I or the would-be recipient can do to remedy this situation.

Okay, seems to be working... enough that I can go to bed

Maybe had a hard drive failure on the box which ran gemini.zachdecook.com, so that site may be getting its forever certificate sooner than planned as I quick configure an alternate server.

I've been working mostly on #FOSS for the last month. Read my #statusUpdate at gemini://gemini.zachdecook.com/capsule/2021-10-22-status.gmi

Does anybody know a good way to make screenrecording gifs on #mobileLinux? Kind of want to show off some stuff I've setup in #swmo.

Created a #Microsoft account today. So that, plus a recent log-in to #Amazon (not to purchase anything), makes me an active member of the #GAFAM. 😐😶🟡

The unsubscribe link (and reply email address) is hidden in the html portion of the email.

#linode is now sending me #spam marketing emails with no List-Unsubscribe header😡 The email appears to contain a #googleAnalytics pixel🤦‍♀️ It's from a no-reply address🤷‍♀️ (otherwise I might be complaining directly to them)

#regret

New #LEGO build: a plugin for my #olkb #planck keyboard-case to hold a #pinephone (or any smartphone).

I would say it works well, but TBH it needs a counterweight to be a usable lap-top device.

Actually, updating #nextcloud to #postgresql on #alpine was pretty easy
1. php occ db:convert-type pgsql nextcloud localhost nextcloud
2. (Disable some apps until that command worked)
3. ssh $OLD_SERVER pg_dump nextcloud | psql nextcloud
4. rsync data dir onto new server
5. Mess around with some config stuff
6. Update https://wiki.alpinelinux.org/wiki/Nextcloud wiki page to be slightly more up-to-date

Watched #freeGuy last night: the movie about an #NPC going off-script against a massive studio... maybe I should get (back?) into #gamedev. I don't play many single-player games, as coding is just more fun.

Migrating a #laravel site to #postgresql from mysql/mariadb

1. Run migrations to create db structure
2. Remove single quotes from the database (and newlines/control characters, because why not). This allows mysqldump files to be imported into postgresql.
3. mysqldump --compatible=postgres --no-create-info --skip-add-locks $DB | psql $DB
4. Fix increments `ALTER sequence song_id_seq RESTART 12345;` (current versions of laravel use old-fashioned postgres increments)

I thought a fun thing to do would be to switch my main VPS to #alpinelinux for more frequent updates (compared to ubuntu). (I run #nextcloud, a custom #laravel site, and some other simpler stuff) So far, I've started using #linode, and also have been learning that migrating from mysql/mariadb to #postgresql may have been too ambitious an idea.