Re: Collection Database Website
I'm looking forward to starting the Beta testing!
I'm looking forward to starting the Beta testing!
Collection Stash: A Collection Cataloging and Collectible Archiving Platform
- Thread starter Something Sexy
- Start date
Help Support Collector Freaks Forum:
jimjimmyjones85
Super Freak
- Joined
- Jul 15, 2009
- Messages
- 20,389
- Reaction score
- 127
Re: Collection Database Website
Agreed. I think this will be a great step forward.
I'm looking forward to starting the Beta testing!
Agreed. I think this will be a great step forward.
Something Sexy
Super Freak
Re: Collection Database Website
Ok, back from SDCC and back at it. I have a few things to clean up and fix and then we should be good to go. Updates coming this week or next week. I am gone this weekend unfortunately.
Ok, back from SDCC and back at it. I have a few things to clean up and fix and then we should be good to go. Updates coming this week or next week. I am gone this weekend unfortunately.
Re: Collection Database Website
Translation: He's nursing a hangover.
Translation: He's nursing a hangover.
Something Sexy
Super Freak
Re: Collection Database Website
Hahaha, yea SDCC is insane. I miss it but glad to be back and working.
Translation: He's nursing a hangover.
Hahaha, yea SDCC is insane. I miss it but glad to be back and working.
Something Sexy
Super Freak
Re: Collection Database Website
I have brought this up before and I talked with JJJ about it briefly. I am going back and forth on organization. Similar sites that allow you to organize things use categories in a tree form to organize their data. This is a tried and true method but I am not 100% a fan of it. It is a pain to maintain, can be confusing to user's to determine where they should put something, doesn't give me complete control over the data and sometimes things fit in many different categories.
Anyone else have thoughts on this?
I might have single or 2 tier high level categories to get an idea of what you are trying to add so I can then present the proper data fields. I was going to try getting around this completely but I think because certain collectible types are going to have different fields I cannot.
What I do not want to do is have a site that has an insane amount of categories that are 1 to n deep that just makes it a maze to figure out where something belongs.
I think with effective tags and searching with filters or sorting I can easily come up with an interface that will make searching for collectibles easier.
I have brought this up before and I talked with JJJ about it briefly. I am going back and forth on organization. Similar sites that allow you to organize things use categories in a tree form to organize their data. This is a tried and true method but I am not 100% a fan of it. It is a pain to maintain, can be confusing to user's to determine where they should put something, doesn't give me complete control over the data and sometimes things fit in many different categories.
Anyone else have thoughts on this?
I might have single or 2 tier high level categories to get an idea of what you are trying to add so I can then present the proper data fields. I was going to try getting around this completely but I think because certain collectible types are going to have different fields I cannot.
What I do not want to do is have a site that has an insane amount of categories that are 1 to n deep that just makes it a maze to figure out where something belongs.
I think with effective tags and searching with filters or sorting I can easily come up with an interface that will make searching for collectibles easier.
Re: Collection Database Website
Hmmmm...good question.
Obviously you want to have the site user friendly and manageable while maintaining control over the data being entered into the database.
All of which I'm sure isn't easy.
Hmmmm...good question.
Obviously you want to have the site user friendly and manageable while maintaining control over the data being entered into the database.
All of which I'm sure isn't easy.
Something Sexy
Super Freak
Re: Collection Database Website
Yea, it is difficult to determine. I am trying to get away from Sites that are like:
Category -> Category -> Category -> Category -> Category -> Category ->Category -> Category -> finally whatever you are adding.
I think it is just a mess and a pain to maintain and it makes it more difficult to move things around. I can see some of the benefits to it for more easily finding things, but that is about it to me. I personally think the cons out weight the benefits but that is just me so I am trying to get some other perspective on why this might be a good idea.
Yea, it is difficult to determine. I am trying to get away from Sites that are like:
Category -> Category -> Category -> Category -> Category -> Category ->Category -> Category -> finally whatever you are adding.
I think it is just a mess and a pain to maintain and it makes it more difficult to move things around. I can see some of the benefits to it for more easily finding things, but that is about it to me. I personally think the cons out weight the benefits but that is just me so I am trying to get some other perspective on why this might be a good idea.
gibby
Super Freak
Re: Collection Database Website
It's been awhile since I read through this thread. Are you still incorporating an admin approval step in order to add collectibles to the master?
It's been awhile since I read through this thread. Are you still incorporating an admin approval step in order to add collectibles to the master?
Something Sexy
Super Freak
Re: Collection Database Website
Yes, as of now it will require approval before it is accepted, which is one of the reasons why I want the add process to be as painless as possible. If we get a solid community in the end, I might open it up to not needing approval but in the beginning it will be approval only.
Yes, as of now it will require approval before it is accepted, which is one of the reasons why I want the add process to be as painless as possible. If we get a solid community in the end, I might open it up to not needing approval but in the beginning it will be approval only.
gibby
Super Freak
Re: Collection Database Website
I agree with that approach. Let everyone build up the database, then you can start locking it down.
To start, then I wouldn't do a tree. Either make it free form or try doing a star schema.
I agree with that approach. Let everyone build up the database, then you can start locking it down.
To start, then I wouldn't do a tree. Either make it free form or try doing a star schema.
Something Sexy
Super Freak
gibby
Super Freak
Re: Collection Database Website
You can set up your database as star schema, where you have one (or two) fact table(s) that are tied to multiple attribute tables. We use this at our company to drive our master data tables, where most of the attributes are required to create a fact. So in our case, a fact cannot exist without being defined in the attribute tables first.
May be an end game kind of thing, though, in this app since you really don't know every single combination yet. However, you could start this and leave most of the primary keys out of the equation. This would give the user select-ability without tying them down with the tree or snowflake schemas.
You can set up your database as star schema, where you have one (or two) fact table(s) that are tied to multiple attribute tables. We use this at our company to drive our master data tables, where most of the attributes are required to create a fact. So in our case, a fact cannot exist without being defined in the attribute tables first.
May be an end game kind of thing, though, in this app since you really don't know every single combination yet. However, you could start this and leave most of the primary keys out of the equation. This would give the user select-ability without tying them down with the tree or snowflake schemas.
Something Sexy
Super Freak
Re: Collection Database Website
Ah yea I know what you mean. One of my initial struggles with figure out the overall schema was a good balance between reading and updating. My core structure has to handle both pretty effectively but in the end I think a lot more reads will be done then updates.
Ah yea I know what you mean. One of my initial struggles with figure out the overall schema was a good balance between reading and updating. My core structure has to handle both pretty effectively but in the end I think a lot more reads will be done then updates.
gibby
Super Freak
Re: Collection Database Website
Yeah, exactly! Almost two separate apps in one...heck, you could even have two separate screens...one for data entry, the other for selection drill-downs. Once the db is established, shut down the data entry screen. Ok, enough of my blabber mouth. Sorry.
Can't wait to test it out! Kudos to you for taking the time to build something like this!
Yeah, exactly! Almost two separate apps in one...heck, you could even have two separate screens...one for data entry, the other for selection drill-downs. Once the db is established, shut down the data entry screen. Ok, enough of my blabber mouth. Sorry.
Can't wait to test it out! Kudos to you for taking the time to build something like this!
Something Sexy
Super Freak
Re: Collection Database Website
Haha thanks! We will see how it goes. I am sure I will regret my decision at some point.
Haha thanks! We will see how it goes. I am sure I will regret my decision at some point.
Something Sexy
Super Freak
Re: Collection Database Website
Ok, I think I figured out how to solution, functional, my category issue. Now I just need to implement it.
Ok, I think I figured out how to solution, functional, my category issue. Now I just need to implement it.
Similar threads
Latest posts
-
JND/Kojun Works - 1/6 Harry Potter Line- Latest: Earth 616 Collector
-
-
Hot Toys MMS 692 + 693 BATMAN (1989) 1/6 scale Batman 2.0
- Latest: FizzledCustoms
-
-
-
-