I don't know what cave-in this art is referring to but I like the idea of a tank being scared.

I'm considering switching from Windows 10 to something either using KDE or the new Cosmic DE that System76 is working on. Right now I've got a 3060TI.

The main mod for this colony was Vanilla Factions Expanded Empire which greatly improves the Empire. I think I got my main pawn to Archcount.

One of my design goals was no rectangular rooms which I think I achieved. The rooms in the bottom left were intended to be guest rooms for royals so they'd be fairly copy and paste aside from colour scheme.

This is my one main complaint about Fedora Linux.

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?

I'd like to be somewhat vague because my job is somewhat niche. For my job I made custom products that are made up of subcomponents that cost me either by the foot, by the pair, or individually. So a particular product may include 5 feet of X, Y and Z, a pair of V and 1 of T and U. Then I add a bit for profit.

Right now I have a somewhat simple spreadsheet that has all my components and their costs listed which are then referenced on other sheets. The problem is adding or removing components is a real pain in the ass because I'd have to edit each and every sheet.

I'd like a better system where I can create a new product then from a drop down or something pick all the relevant components and enter how many of that component I need. Then create a quote that I can email to a client that lists the final cost of a bunch of products.

I'd prefer this to be a, open source web app but it can be a desktop application.

Come get your tanks!

Someone linked a site that lets you search all the Lemmy communities but I lost the link. IIRC it presented all the communities in a tile based layout.

On reddit if I wanted to refer to a subreddit I'd type /r/oneOrangeBraincell/ and that would get turned into a link. What's the lemmy equivalent?

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 (41 + 72). I know I'd need some JOINs but I have no idea what I'd need.