Greetings, I'm a bit new to SQL and SQLite so pardon me if I ask silly questions but I have run into a bit of a wall while attempting to design a database for a C++ program I am attempting to write.
The needs of the database are to: represent an object oriented hierarchy of any number of objects, where each object may have custom properties of several different datatypes and permission bits. The table fields that I have so far are a primary integer key (ID), text representing the object's name, (NAME), and two fields "OWNER" and "PARENT" which are integers representing other objects in this table. The problem I am running into is the object hierarchy and custom properties. For example: If object #1 is a parent of object #2, and #1 has a property named "location" then #2 should also have that property (although the value and permissions may be different from the parent). I'm trying to see if I can do this some way I do not currently know how, because the only thing I can think of is some delimited BLOB and recalculate all the parent properties whenever the parent is changed which I imagine may significently slow down my database. Opinions? Regards, Michael Munson