Ah got you (I think). This would be solved with a join right? I don't write joins anymore because I use LINQ but in LINQ it would be:

tblProducts.Where(c=> c.tblTypes.Round = true);

(If I'm wrong again not surprised, it's probably me not you)

There are only 5 levels of classification so I'm just going to graph the thing manually...

Confused. Can you show the actual schema?

And also, is there a hierarchy?

it looks to me like a very standard thing like

Rusty is right. It essentially captures up to 5 levels of classification for a product. There are some chains 3 nodes long some 4 some 5. I think they correspond to 5 windows in a UI but I haven't seen it. I could see building it one window at a time given either end but don't see how to get all the leafs for a given node that isn't the parent node for the leaf. Short of graphing it out in a spreadsheet...

so if you apply for a programming job they aren't going to call your current employer and say "we are thinking of hiring James what do you think about him?" do they? or do they only call past employers... or do they not call anyone cause they will put you through their own testing gauntlet?

There is usually a spot asking if they can contact your current employer or not on the application. If not ask them not to if you are looking on the down low...

Perhaps look at this:

http://karwin.blogspot.com/2010/03/r...re-tables.html

There's a lot of variations on ancestory / descendent tables like that, but that particular formulation looks like what you are dealing with.

There's also an article on moving branches from the same author:

https://www.percona.com/blog/2011/02...closure-table/

I'm using react for everything so I use a lot of jsx object styling, but when I write CSS classes I've just been using camelcase.

I don't see the point in hyphenating CSS classes when literally 99% of the rest of my code uses camelcase and it just seems like a better way for me to do it.

Am I an idiot?

Thanks Dave, but those articles aren't what I have. They assume a path looks like a-a, a-b, a-c, a-d, where my paths are more like links in a linked list' a-b, b-c, c-d. I can't tell that from a-h, h-i, i-d. My guess is the UI populates a box with options as soon as the previous box is filled in.

I do use kebab-case for my CSS, but i can't defend it other than to say i'm following convention. Sometimes it's marginally useful to have the visual distinction between the two domains, but honestly I can't think of a solid argument against what you're doing.

There's no such thing as CSS classes 😄dashes in html is a convention that I don't see changing for whatever reason.

Yeah most of that stuff is just convention. Some languages have settled on camel case, some snake case, and some kebab case. Afaik there's very little difference by any practical measure. But note that if you go against convention with code other people will see be it looking over your GitHub or on a whiteboard, you might be judged harshly for it.

As you probably know, programmers can be extremely dogmatic

I have a contributor to my project that writes code completely different than me and I just cringe and accept his PRs and hope I don't judge. It passes lint at least.

That's how the terrorists win or you get a co-creator when his weird code totally replaces your code in some module or other.

Theoretically, you could try to mimick CSS classes with CSS pre-compilers. I've never had the need to get into the CSS pre-compilers. I believe the main one is called LESS.

I swear I read an article once about touching up contributors' PRs while maintaining their commit history (so they still get credit for doing it) for things like code style...

Found it! https://blog.spreedly.com/2014/06/24...dered-harmful/

Maybe you'll find that useful.

I just read that quickly but I think I have a fundamental problem with it. Everyone should be responsible (both good and bad) for their work and only their work. This guys approach violates that because he's re-writing history.

Maybe I just don't really get the problem he's solving, because it seems like he could just check out the branch of the PR and make his clean-up changes as a commit on top of that.

Then again, I've never really cared much about the "super clean commit history" because in practice I don't find it that useful and I think it takes more effort to maintain then benefit it gives. In most repos I'm active in we're using pull requests for 99% of changes and so the pull request history is actually the 'clean' history of big issues that were changed.

If I want to create a simple 2d scrolling shooter kind of in the same vein as galaga, where would be a good place to begin?

Unity seems overly complex for what I want.

Surely Gullanian's Construct3 can't be a bad place to begin. Though I'd prob use Unity or even UE4 just for the benfit of learning a bit about them myself.

I'm pretty sure there's a way to do that in raw SQL, but it'll be more efficient to do that in a procedural language. Basically, take the arg of the root you want, then iterate down until you have everything and return an array.

They store the full path somewhere else in the db...

Basically, what you have is something called an adjacency list.

I have this table:



And to get the path, you need this query (fix accordingly):

Which outputs this:



If you have to go five levels deep, you can see where that is going....

Since you already have path enumeration with something like this:

You'll have to split the path with a "like" query, split the string on ",", spin through all of those numbers, coerce to int, etc (adjust this to arrays if you are using it).

Basically, it would be a crazy query even if you have recursive CTEs available. If you don't have recursive CTE's, you'd have to split the string into a subselect, then self-join on the table 5 times the same as shown above. This will be an eye-glazer, which I think nullifies the point of using the extra table.

In effect, the first query, although rather lame, would be much easier to do than combining path enumeration, but all if this is much much easier (and more efficient) to do with a procedure.

I did some searches on adjacency lists and path enumerations, but didn't find a lot of good information on them. They are accurate, but pretty scattered, but those are the official terms you want to look for.

Thanks dave!

lol

Gamemaker AINEC