334 reputation
113
bio website
location
age
visits member for 3 years, 4 months
seen Aug 18 at 23:04

Hellow world;

I'm hopeless romantic;

I am error;


Jul
2
awarded  Curious
Jun
10
asked What's the proper way to merge two projects in source control software
May
23
awarded  Popular Question
Apr
16
comment How should I implement code review in this situation?
Even if you don't have a server to set up a repo it sounds like you are both working in the same network. Set up a repo on each other's computers and commit to it. Too many options to list but the after running several years without a repository I can say that it is a god send. Even if it is on your local computer it's better than anything
Apr
17
awarded  Popular Question
Feb
25
awarded  Caucus
Jan
10
awarded  Critic
Nov
26
comment Programming Challenges for a beginner
Just including another helpful link that has open course ware including the MIT one you pointed out: edx.org
Nov
26
accepted Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
I like your edit ^_^ A new way to do it.
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
@KirkBroadhurst I'm sorry about that, My diagramming skills are lacking.
Nov
13
comment New grad; To overcome complete lack of experience, should I ditch a creative pet project in lieu of one that would demonstrate more applicable skills?
my example: there're two projects I want to work on. One project I've known about for years but never had that willpower to do it. But my new interest is much stronger and programming this new project is coincidentally useful since I can use part of the skeleton and with minor altercations I can expand on it. So I would say, do what you are willing to do. If you want to showcase any of the other characteristics you wanted to do, work those in at the end. You said you wanted to make an edu game, I am sure if you find joy in this you can expand on it and find ways to data modeling and mobile dev
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
@KirkBroadhurst In the many to many table there would be no PK, the guid column would just be a reference to the other tables, Right? At least, that's how I usually do M2M, I could be wrong.
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
@FrustratedWithFormsDesigner Thanks! I didn't know that SE existed. ^_^
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
@KirkBroadhurst It is M2M, One image might have multiple locations, and a location can house multiple images.
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
Lots to think about. I can answer number 4 with the most confidence in that yes it is m-m. One picture might be located in two different locations. (Back up, original, "customer's" computer) and a location (aka most probably a folder) can harbor many pictures. #5 would solve that problem easily. As for my question #1 indicates that if I combined the fk then cascading would delete things that I wouldn't want deleted, but wouldn't that be the point of using GUID. I guess I wanted to solve having four tables vs one and it seems that either I use GUID or put a type (#5) on my original table.
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
Woops, you pointed out another mistake I made in my communication. I do intend intend to have multiple locations for each attribute in each table. (Back-ups, derivative copies, etc...) So I really do mean many-to-many As for why I don't use an AttributeType is a good question. Thanks for asking, I will have to think about this. For some reason I instinctively want to compartmentalize each type.
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
Does this mean there is no issue binding multiple tables to one column.
Nov
13
revised Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
added 354 characters in body
Nov
13
comment Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
@AndrewFinnell Thanks, I just made the diagram as fast as I could, I didn't actually check the vartype too much. Although, I think you mean instead of an INT I would need a Varchar??