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.
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.
That was my experience using robo advisors too, like betterment. I had so many buy and sells I had to mail my return in on paper, it sucked.
I have such high hopes for London, their cycling infrastructure has been getting better I er the years, but then I go to Paris and just cry at what is possible
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.
I played necro this pre season, tried all the builds. Is there a rogue build that is relatively tanky but still the stupid high DPS we expect to see from rogues?
Absolutely same here, though it’s also ruined my ability to use gnome or KDE or really anything else too…
Oh no, someone got the good item, time to nerf drop rates again!
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.
Absolutely rolling a rogue. Playing a necro currently, and it’s fine, but I don’t love the build choices. I’m prob gonna go rogue, maybe a barb, they both look crazy fun.
I would love to roll a sorcerer but they need some major rework before I’m willing to jump in there.
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.
Are you in the US? It tends to be different there than elsewhere. In the UK here, it’s much more accepted to buy flats and live in them long term. In the US, it’s looked down on because people hate sharing walls, hate the monthly maintenance fee you have to pay the building, and hate the resale value and challenge with resale in general.
Apartments can be an okay purchase but tend not to be an investment like houses have traditionally been.
It’s not been purged, I can see a whole ton of posts. Besides, I’d be shocked if @TheDude@sh.itjust.works would purge anything.
I rolled necro but I’ve played with some druids, and they fucked. Level 53. Maybe it’s not the strongest class or something but it looked sweet and killed stuff.
Cleaning up affixes and deleting a lot of them. Changing loot so less drops of higher quality. New tier of legendary affixes that can’t be imbued onto other gear. Legendary and uniques are tradable. All affixes go into codex. Codex affixes can be leveled up. Rework of the upgrading system to 12 tiers with new mats. Uber Andy. Level 200 Uber bosses. Lots of skill reworks they haven’t spoiled yet. Mid may release.