Single person instance hoster here! I love that I know what service I’m interacting with, I control what that instance does and chooses who to federated with, and I’m unlikely to get defederated due to some other idiots bad comments or brigading.
Single person instance hoster here! I love that I know what service I’m interacting with, I control what that instance does and chooses who to federated with, and I’m unlikely to get defederated due to some other idiots bad comments or brigading.
Before the upsert, do a select where the result is optional. Then if_some() it was an update, if_none() it was an insert.
Looks like the on_conflict is on the ap_url, so I would use that as the key you’re trying to pull in the select.
Box + peanut butter is top
This is also similar reasoning and why I went with a mikrotik router. All the functionality I need, none of the bullshit, solid performance for price. Only downside is the setup isn’t trivial, but if you’re comfortable on the command line, it’s a breeze.
Just like the old public email lists or Google groups or something, I just wish discord was searchable and indexable so badly
I’ve been getting into Fava, it has a plugin called fava-envelopes that mimics the envelope style budgeting of my one true love, YNAB4, but with the strength of double entry accounting as well. All docker composable as well.
I bought one, it was called the CWWK AIO-T6. Six bay, n5105 based in a nas form factor. Absolutely excellent, runs unraid well. Unfortunately it doesn’t look like CWWK sells it anymore… I got it for £329 with I think 16gb of ram and a 1tb nvme ssd on AliExpress.
I’m assuming Google takeout will allow you to export them since Google now backs them up for you, but I haven’t tried.
Absolutely same here, though it’s also ruined my ability to use gnome or KDE or really anything else too…
Sure, but the server calculates the hot/active every 15 minutes regardless of whether or not you browse it. It’s calculated on a timed job so it’s always fresh and ready for everyone.
Isn’t a semi-significant amount of the per instance load in the database interactions though? I don’t know if that’s still true after some of the optimizations in 0.18, but by having your own instance, even 1 person instance, you no longer load the database of another instance with calculating hot/active/whatever for things you want to see, and you don’t load it when you do pulls.
I mean, it’ll probably be obvious, however they end up doing it. Just look for all the trackers and cookies 😂
This was absolutely amazing. I was having some trouble with the build process using the docker compose from Lemmy itself, but this just instantly worked. Thank you!
Man, what a shit situation for the mods. Either open or you get removed and it opens anyway.
I’ve been surprisingly happy with the diablo 4 campaign. The amount of food voice acting, grittiness, solid side quests, it’s been nice. Though I am missing that bit of d2 and d3 where you can just plow through hordes of enemies
Not to mention facebook the company (now meta) has been struggling too, losing ~75% of its market cap in the last few years… finally.
The meaninglessness is still there. What I suspect is the biggest difference is the headspace surrounding it. If there’s not inherent meaning to life, then that frees you to create your own with your own goals and desires and whatnot. If there’s no inherent meaning, then any meaning we as humans come up with for ourselves is the meaning. For some people, that’s religion. For some, it’s taking care of their loved ones. For a few of my friends, it’s to play as many video games as possible. For others, it’s to work as much as possible. The beauty of it is that they’re all right, the meaning of their life is what they make of it. You are what you repeatedly do.