You like deploying infrastructure, probably in a cloud environment, but you don’t want to push a bunch of buttons in their web interface, so you use Terraform to declaratively define the things you want, and it goes and builds them for you. Super useful for when you need to build resources often, to detect and correct config drift, and get started down the path of Infrastructure as Code.

I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything.

DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';

I think the Kindle Scribe has a lit screen, if e-ink is what you’re after.

I love my ReMarkable 2! I use it everyday for handwritten notes and for e-reading. It doesn’t support the major stores, but it loads epubs just fine. I’m also self-hosting rmfakecloud cause I’m that kind of nerd. You mentioned night use, so definitely be aware it does not have any lighting built in.

Hugo calls these sorts of things “frontends” and has a list here: https://gohugo.io/tools/frontends/

I haven’t had great luck with any of them personally.

I wouldn’t want to host anything on Windows unless you have to, or you want to learn more about Active Directory / Exchange / etc to help with a day job (assuming your day job is sysadmin / IT). Even then I’d do that inside Windows VMs on a Linux / ESXi host.

I personally wouldn’t (and don’t) host authoritative servers externally to the internet. I do split-horizon DNS, so that my internal BIND server handles my LAN, but I have outside DNS handled by someone that has an ACME (Let’s Encrypt) module, so that I can do wildcart certs.

One thing to look into as you spin up services at home would be some sort of VPN like Tailscale, WireGuard, or even something like Cloudflare Tunnel so that you’re not exposing services directly to the internet if you don’t absolutely have to. I believe some of these projects/products let you specify DNS servers so that when your phone (for example) is connected to the VPN, it uses your home DNS servers instead of public ones.

Your very own self-hosting legend is about to unfold! A world of dreams and adventures with self-hosting awaits!

Here’s a map from University of Alaska Geophysical Institute: https://www.gi.alaska.edu/modules/custom/aurora-forecast/images/idl_graphics/north_america/NorthAmerica_6.png

I’ve actually done this for a Microsoft owned IP before. Someone was Wordpress-scanning a particularly fragile application of one of my clients (which was not Wordpress) which was causing it to fall over. The scan stopped within an hour of sending the abuse email.

Edit to add: I used to work in a NOC for a tier 1 ISP. We had an “abuse department” (a couple people) that investigated these and opened tickets with the NOC. I’ve emailed customers and disconnected circuits as a result of abuse emails, so I wouldn’t say they’re totally useless, but I’m sure it depends on the company involved.

It’s free as in “paying zero money”. It’s still distributed via leanpub. Requires an email address to get to the download page, it doesn’t verify it in any way other than being a valid email format. Links are to DRM-free epub and PDF.

I’ve got a 1972 VW Super Beetle that I’ll never get rid of. It’s not really a desirable version or year of the Beetle, but my dad, grandpa, and I restored it when I was 9. My grandpa died in 2020 and he worked on cars his whole life. It’s cool to have a physical thing that he made possible using a lifetime of skills. Plus, my kid is getting old enough to work on it with me, and I think it’s awesome to have 4 generations of my family wrenching on it.

Lemmy 0.18 has resolved most of these for me. As the big instances update, hopefully this gets more stable for you!

The US military spends 2 trillion a year. I’d much rather see those resources go into rescue operations than the opposite. Poor people in a boat should absolutely get access to the same resources, and the crime here is not that billionaires did, but that the migrants didn’t.

Conservatives don’t seem to have trouble with boob jobs, etc. I think this is an instance of using religion as an excuse when it’s convenient.

And WebKit is itself a fork of KHTML.

Just checked my own Lemmy postgres database, it’s a 12 round Bcrypt 2b hash.

On one hand, this is super cool, but on the other, it gives orcas and robots the chance to team up, and I’m not here for that.

You’re in OK?! I just moved from OK to CO last summer. Hope your family and lab gear are doing okay after the storms.

The real gold was the friends we made along the way.

If anyone else has made it this far and are thinking “ah balls, I’m using ingress-nginx”, here’s the ingress annotation for you!

nginx.ingress.kubernetes.io/configuration-snippet: |
            if ($http_accept = "application/activity+json") {
              set $proxy_upstream_name "lemmy-lemmy-8536";
            }
            if ($http_accept = "application/ld+json; profile=\"https://www.w3.org/ns/activitystreams\"") {
              set $proxy_upstream_name "lemmy-lemmy-8536";
            }
            if ($request_method = POST) {
              set $proxy_upstream_name "lemmy-lemmy-8536";
            }

Here’s a cronjob to clean up the useless activity table every day:

apiVersion: batch/v1beta1
kind: CronJob
metadata:
  name: postgresql-cleanup
  namespace: lemmy
spec:
  schedule: "0 0 * * *"
  jobTemplate:
    spec:
      template:
        spec:
          containers:
          - name: postgres-cleanup
            image: postgres:alpine
            command: ["psql", "--host=postgresql", "--dbname=postgres", "--username=postgres", "--command=DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';"]
            env:
            - name: PGPASSWORD
              valueFrom:
                secretKeyRef:
                  name: postgresql
                  key: postgres-password
          backoffLimit: 0
          ttlSecondsAfterFinished: 3600