It has scalability, yeah, but I'd need to index a lot of data. I still don't know if it's the best for my use because sometimes I have to work in small sections and other times I need the whole picture (join statements), and Mongo doesn't offer that flexibility.

Does that last sentence even make sense? :D

... ish.

Hierarchical data doesn't really fit in a database too well.

Yeah, and that's why I'm putting so much effort into choosing one.

@AnnonomusPenguin What even is the data?

Also:

It's sorting objects. Hmm... let me draw a picture

@hichris123 And now I have a long list to read haha

-furniture
 *desk
  =writing
   ^Specific models^
  =student
   ^Specific models^
  =computer
   ^Specific models^
-food
 =fruits
  ^Pear
  ^Apple
  ^Peach
 =veggies
 ^Carrot
 ^Lettuce

@hichris ^^^

I want to be able to go to "pear" and then see all of the related fruits (apple, peach) and see that another category is "veggies" that's related in the category of "food"

The issue is, I'm going to have a lot of top-level entities like "food" that will be created at runtime so I'm afraid MongoDB is going to get swamped.

Oh well, I'll figure it out.

@AnnonomusPenguin Hmm, could you just create a food table with type fruit and something pear?

@hichris123 Elaborate please...

So food table. Got that... but what do you mean by "type fruit"?

Create a column for the type of fruit?

@AnnonomusPenguin yeah.

So there would be a table food, with columns category and type, category being fruit, and type being pear.

[ SmokeDetector ] All-caps title: HOW DO I INREASE OVERALL IMAGE SIZE on graphicdesign.stackexchange.com

[ SmokeDetector ] All-caps title: ANDROID LISTVIEW OF MESSAGES on stackoverflow.com

[ SmokeDetector ] All-caps title: HOW TO EXPAND PHP WITH PYTHON on stackoverflow.com

[ SmokeDetector ] Bad keyword detected: does really work weight loss products? on drupal.stackexchange.com

[ SmokeDetector ] All-caps title: R9 290X ASUS DIRECT CUII OC - ANTI ALIASING on superuser.com

[ SmokeDetector ] Bad keyword detected, Phone number detected: +91-9950211818 vashikaran specialist in haryana on english.stackexchange.com

[ SmokeDetector ] All-caps title: COUNT IF CELL NOT BLANK VBA on stackoverflow.com

[ SmokeDetector ] All-caps title: FIIND ACCTS NOT CLOSED WITHIN THE SAME MM/YYYY on stackoverflow.com

[ SmokeDetector ] All-caps title: FIND ACCTS NOT CLOSED WITHIN THE SAME MM/YYYY on stackoverflow.com

[ SmokeDetector ] Offensive title detected: Como se dice “Shit happens” en castellano? on spanish.stackexchange.com

[ SmokeDetector ] All-caps title: LONG TERM DISABILITY(TAXES) on money.stackexchange.com

[ SmokeDetector ] Offensive title detected: ¿Cómo se dice “Shit happens” en castellano? on spanish.stackexchange.com

[ SmokeDetector ] All-caps title: FIND ACCTS NOT CLOSED WITHIN THE SAME MM/YYYY on stackoverflow.com

[ SmokeDetector ] All-caps title: HOW TO REL=NOFOLLOW TO SLIDER IMAGE on webmasters.stackexchange.com

[ SmokeDetector ] All-caps title: HOW TO REL=NOFOLLOW TO SLIDER IMAGE on webmasters.stackexchange.com

[ SmokeDetector ] All-caps title: LONG TERM DISABILITY(TAXES)( TO PAY OR NOT TO PAY?) on money.stackexchange.com

[ SmokeDetector ] All-caps title: STAR FLEET SHOULD CARRY HAND BAGS on scifi.stackexchange.com

[ SmokeDetector ] SmokeDetector aborted

@Undo ^ ?

uh oh

Welp, I dunno :P

The best guess I have is that it choked on some nasty characters.

[ SmokeDetector ] SmokeDetector started at rev d4e8dac (owned by Undo)

[ SmokeDetector ] SmokeDetector started at rev e552471 (owned by Undo)

@Undo So what's the difference between the query results & bad.txt?

Whatcha mean?

oh, I assembled bad.txt just by going through stuff Smokey's posted in here.

query results are all good posts

@Undo There's github.com/Charcoal-SE/SmokeDetector/blob/master/bayesian/…

@hichris123 That's the thing Anna gave us

@Undo Yes, but did you include that stuff in bad.txt?

I don't think so

ah, ok.

[ SmokeDetector ] All-caps title: TIME VALUE OF MONEY, INVESTING VS. SUSTAINABLE TECHNOLOGIES on math.stackexchange.com