Newbie confusion about the database docs

[eluser]Doug Lerner[/eluser]
[quote author="Colin Williams" date="1215667813"]Not a lot of time, no. Let's say you have two data objects which share a many-to-many relationship. At most you're designing and creating 3 tables. Something like post, category, and post_category to link them. Then in your model, you're just doing a JOIN query and then probably looping through the result and concatenating it into just an array of 'post' objects each with a 'category' property that is itself an array of 'category' objects. I don't think it's a lot of development overhead.

I like to have total control over my objects and their relationships so I typically avoid ORM-type frameworks. There are times ORM introduces more overhead than is necessary. If you would like to use something like ORM, head over to the wiki and have a peak at the few ORM-type libraries available.[/quote]

Well, it's a lot more development overhead than just creating the objects you want and storing them directly in an object-oriented database and letting the language take care of that for you.

I guess I have gotten so used to the particular server-side JavaScript I've been using I am resistant to spending time on the lower-level of the database handling, which has always been automatic to me. I'd much rather spend time on the higher-level coding logic than in dealing with all the details of how the data actually is handled in the tables.

Maybe I will go peak at the ORM stuff. Thanks for pointing that out.

doug