Hey guys,
I have another general question for you to help me in my search for setting up some tools at work! (I’m sure ya’ll are thrilled!)
So I’m trying to develop a solution that takes an object in Maya, collects it’s width, height, depth information and can store that information in a database under 6-12 sections/groups. In essence I’m looking to categorize specific parts that are used over and over again in production, under sections so that the database can be queried and tell what “section” or group the part falls under.
A bolt for instance is a common object in our scenes that is used over and over again. It will have specific height/width/depth information that will remain constant. I want to use this information to designate the bolt is a bolt in the Maya scene so that it is treated as such!
I need to be able to write information to a data base (width, height, depth, designator ID) and I need to be able to query the database to cross check the information to categorize. Eventually this database will be queried by a small 2-3 person team (perhaps at the same time), but will only be written/modified by myself.
What would be the simplest database solution to do this? SQL Lite? Perhaps just an XML file that will be parsed by DOM or SAX (probably SAX considering there will be close to 1000 entries in this database and I don’t know if 1000 simple entries would kill memory)? Originally I was going to use a .ini config file, but I don’t think that would be a very sustainable solution considering the large amounts of entries (simple or otherwise… a config file is used for preferences more-so anyways.)
Not asking you guys for specific code, or in-depth solutions, but just what solution would be the best to learn, research and implement (and why).
Many thanks and I greatly appreciate your time.