• 3 Posts
  • 50 Comments
Joined 1Y ago
cake
Cake day: Apr 19, 2023

help-circle
rss


I’ll vouch for airvpn. I’ve been using it for probably six years now with no issues. When using wireguard I can download Linux isos at 500mbps.










Oh right I completely missed that. I should go to bed. I wasn’t aware radarr had that functionality.


It’s still not clear to me why you’d need nvenc for radarr.


I don’t have exact instructions off the top of my head but you need to install the nvidia container runtime and set the container’s runtime to nvidia. I can’t think of a reason why radarr would need nvenc though; jellyfin, plex or tdarr sure.


Hey they changed the thumbnail. It used to be a dude shouting “I hate you!” at a PC.



I remember that comments made in a post after you first visited were highlighted.










I will try dodi’s version. I’m not interested in playing fps’s on my steam deck. I tried playing borderlands with a controller and it was an awful experience.






Why are categories basically useless in qbittorrent?
I've only got a couple of categories, one for sonarr, prowlarr (for some reason), and Games. They each have their save path set and thus I would expect any torrent added under the Games category would be saved in the path set for that category. But they're not, they're dumped in the default save path making that folder a hot mess. What's the deal? Why are categories so terrible?
fedilink

Is this why there’s that speedrun to have sex with that one woman?


Why the hell did that person record in portrait? Turn your phone sideways you fool!


I played most of Cat Quest 2 only to reach the difficulty cliff that is Lioner. For the most part the game was quite easy then bam! multi-phase boss that’s immune to one of the game’s two damage types. Multi-phase bosses and total immunity to damage types are bullshit. The quest that involves killing Lioner is a level 80 quest and I first tried it at level 92 and failed. I grinded up to level 97 but I haven’t had the… passion? to fight him again. I’m seriously considering using something like Cheat Engine to lock my health at max. And apparently there’s a second difficulty spike.

I played a couple of hours Borderlands GOTY Enhanced and I’m sure the XP gain has been changed. In the OG Borderlands I’d get to Nine Toes around level 5, maybe level 6 if I grind a little bit but in GOTY I was level 7 when fighting him with no grinding at all. The graphics don’t seem to have changed much although it’s been a while.

I tried playing Baldur’s Gate 3 but I just could not get into it. It’s kind of odd though because I was able to get much further into DOS2 (I got bored early in the third act). It didn’t help that my GPU fans were going full brrrr the entire time.

I played a little bit of Holocure after watching Kronii Ouro play it but what she played and what I played seemed to be completely different games gameplay-wise, reverse bullet hell isn’t really my jam.

I bought Dwarf Journey and Shakedown Hawaii for a trip I’m taking this week so hopefully they’re good.


I find the fourth option somewhat amusing, as if they know the feature doesn’t work (I don’t think I’ve had to use it so I have no experience)




I downloaded the RUNE release from TorrentLeech and Windows Defender found a trojan so yeah I’ll believe it. I guess I’ll wait for a FitGirls repack.


I’ve found auditory ID quite reliable, photo ID is pretty good and questionnaire ID not very.


Merlin - It’s a birding app and can identify birds by picture or by their song.


I’ve tried using Hurricane Electric’s tunnels on pfsense but it just kills my internet connection and the only solution is to reboot


I can’t remember the last time I burned a DVD for anything, possibly 15 years.


Need help writing an SQL query
The title is indeed terrible but I have no idea what to put. I am working on a Bill of Materials app and I'm starting out with the database layout and the REST API to interact with the database. I currently have four tables but the query I want to write involves three of them CREATE TABLE `components` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `description` text DEFAULT NULL, `price` float unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name_UNIQUE` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `products` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `description` text DEFAULT NULL, `tax_code` varchar(8) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name_UNIQUE` (`name`), KEY `name_idx` (`tax_code`), CONSTRAINT `name` FOREIGN KEY (`tax_code`) REFERENCES `tax_codes` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `product_components` ( `product_id` int(10) unsigned NOT NULL, `component_id` int(10) unsigned NOT NULL, `count` int(10) unsigned NOT NULL, PRIMARY KEY (`product_id`,`component_id`), KEY `fk_component_id_idx` (`component_id`), CONSTRAINT `fk_component_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`), CONSTRAINT `fk_product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; Now what I want to do is list all the products and for each product calculate the cost of all the components that product needs. So if a product needs 4 doodads that cost $1 and 7 whatzits that cost $2 the cost of the product would be $18 (4*1 + 7*2). I know I'd need some JOINs but I have no idea what I'd need.
fedilink