** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** - Page 1282 - Computer Technical Help

Two Plus Two Forums Other Topics Computer and Technical Help

** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD **

Post Reply Subscribe

...

Page 1282 of 1603

First

282 782 1082 1182 1232 1262 1272 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1292 1302 1332 1382 1482

Last

Page 1282 of 1603

First

282 782 1082 1182 1232 1262 1272 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1292 1302 1332 1382 1482

Last

03-03-2018 , 11:55 PM

#32026

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

ok thats better than "get me notes made on player X and see if player Y is one of them"?

Quote

$25m Guaranteed WPM on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

03-04-2018 , 01:23 AM

#32027

ChrisV

Carpal \'Tunnel

Join Date: Jul 2004 Posts: 40,336

Well that's going to be querying against 9 separate keys when you want to check if a player has notes on any of the people at their table. If you key on the player who made the note, it'll be one query against one key. Insofar as I understand how mongo works, seems like that should be better.

Quote

03-04-2018 , 02:22 AM

#32028

PJo336

THRILLHOUSE!

Join Date: Mar 2007 Posts: 22,158

Always query against indexes! The benefit of mongo is you can make random ass collections geared towards specific queries. People tend to not use it that way and treat it like a basic SQL relational db

Quote

03-04-2018 , 11:41 AM

#32029

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

tbh I don't even know what an index is. Other than the 2nd argument passed to [].filter & map

Quote

03-04-2018 , 03:49 PM

#32030

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

ok should it be:

each player only has one row and inside there is an array of notes on all players

or

each player has multiple rows and there's one note per player?

Quote

03-04-2018 , 04:37 PM

#32031

goofyballer

Carpal \'Tunnel

Join Date: Jun 2005 Posts: 70,719

What Chris is talking about = the first one. Thinking about things in terms of "rows" is weird to me in Mongo, though, isn't it more like "documents"?

(while logically they're the same thing, I feel like thinking about it in terms of "documents" instead of "rows" does better at framing the problem in my head in a way that highlights the internal differences/shortcomings of mongodb vs relational databases)

(but also I work with databases ~never)

Quote

03-04-2018 , 07:02 PM

#32032

kerowo

lolcat

Join Date: Nov 2005 Posts: 37,183

Each note has a subject and an author, you know the players at a table, seems pretty straightforward to see if it's faster to do a two stage filter; author then subject or have up to 45 canned author,subject filters.

Quote

03-04-2018 , 11:39 PM

#32033

Larry Legend

Celtic Pride

Join Date: Jul 2009 Posts: 42,243

Yea the row thing confuses me as well.

This is what you are saying right?

Code:

{
  Player1: [{ 
    Player2: "Is a huge nit",
    Player3: "Tilts for stacks",
    Player4: "lost 6 BIs to me and now tries to force hands against me"
  }],
  Player2: [{
    Player1: "LAGtard"
  }]
}

That seems like the obvious way to do it with Mongo. It seems like generally tho I wouldn't use Mongo for stuff that has to do with people and such, Postgres or MySQL just seem like such easier fits since the data is going to be relational and highly regular.

Quote

03-05-2018 , 12:29 AM

#32034

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

again I basically know the minimum about databases and more or less punt on this stuff. It sounds like I have 2 options (I'm using the Mongoose ORM btw)

A collection where my schema looks like this

Code:

{
userNameWhoOwnsTheNote,
notedUser,
note
}

which of course results in multiple rows/entries or

Code:

{
userName'sNotes,
noteDetails: Array of objects/assoc. arrays that are userNameBeingingNoted: note
}

is one better than the other? does it matter?

Quote

03-05-2018 , 03:21 AM

#32035

Larry Legend

Celtic Pride

Join Date: Jul 2009 Posts: 42,243

I don't know the correct answer.

I would lean toward the 2nd one and index the ids of the users and then index the ids of the userNameBeingNoted for each user. Seems faster than the first which involves collection scans to get the data?

Quote

03-05-2018 , 06:24 PM

#32036

Victor

Carpal \'Tunnel

Join Date: Jul 2003 Posts: 81,658

first one seems way better. but just use ids.

Quote

03-05-2018 , 08:05 PM

#32037

RustyBrooks

Carpal \'Tunnel

Join Date: Feb 2006 Posts: 24,646

Quote:

Originally Posted by Victor

first one seems way better. but just use ids.

Yeah, and there's no reason it would have to do a collection scan. You can index on multiple columns.

Quote

03-06-2018 , 11:32 AM

#32038

OmgGlutten!

Pooh-Bah

Join Date: Aug 2016 Posts: 5,273

I made the mistake of visiting Udemy now I keep getting those Youtube ads with the Asian guy in plastic glasses telling me "Python's really hot right now".

Quote

03-06-2018 , 11:43 AM

#32039

Wolfram

Carpal \'Tunnel

Join Date: Jan 2006 Posts: 15,066

I googled spell checker once in my life 3 years ago and 90% of the ads I get are for grammarly.

Quote

03-06-2018 , 08:45 PM

#32040

PJo336

THRILLHOUSE!

Join Date: Mar 2007 Posts: 22,158

Quote:

Originally Posted by OmgGlutten!

I made the mistake of visiting Udemy now I keep getting those Youtube ads with the Asian guy in plastic glasses telling me "Python's really hot right now".

Oddly mine are always for PHP, and I have never looked at anything remotely related to PHP on udemy

Quote

03-06-2018 , 08:52 PM

#32041

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

Downloaded 10 gb movie, needed to be in other director, instead of waiting xx minutes for win 10 to copy paste it, I thought "hmm wonder if just cp from git bash would work" and sure enough it looks like it does. wtf windows?

Quote

03-07-2018 , 03:05 PM

#32042

JustASpectator

veteran

Join Date: Mar 2005 Posts: 2,349

Quote:

Originally Posted by Grue

If all you needed was for the file to be moved to a different folder, and if you truly tried a Copy/Paste then it isn't as much wtf Windows as it is wtf Grue? Use Cut/Paste.

Quote

03-07-2018 , 05:00 PM

#32043

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

nah I needed copy but uh I guess linux symlinks it or something? Still confused.

Quote

03-07-2018 , 10:54 PM

#32044

Barrin6

Carpal \'Tunnel

Join Date: Dec 2005 Posts: 6,948

I think it might be a hard link.

Quote

03-07-2018 , 11:53 PM

#32045

RustyBrooks

Carpal \'Tunnel

Join Date: Feb 2006 Posts: 24,646

Using a hard link for a copy would be pretty bad behavior

Quote

03-08-2018 , 01:04 AM

#32046

fredd-bird

Carpal \'Tunnel

Join Date: Aug 2007 Posts: 19,359

Just saw this Hold 'Em web app built with Elixir + Elm and thought some might find it interesting:

https://teamgaslight.com/blog/elm-el...-stack-project

Quote

03-10-2018 , 04:36 PM

#32047

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

Awesome I found a breaking bug in Node LTS (broken in v8, works in v6) that makes development on my game impossible

Spoiler:

I have alerted the authorities wonder if they'll get back to me.

Quote

03-10-2018 , 10:05 PM

#32048

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

I saw some article on twitter about the webpack team finding some bug on huge angular deployments (or something angular-related) and the v8 team fixing it in 48 hours.

Quote

03-10-2018 , 10:32 PM

#32049

muttiah

Carpal \'Tunnel

Join Date: Aug 2004 Posts: 25,375

Anyone else feeling the pain of GDPR? We are in negotiation. Might need to remove userIds from everywhere in the system. Apparently it's not enough for the EU to remove the actual user identifiable data.