¿Is ModX the right tool for...?

Hi everyone.

I'm doing some research for a new project and need some advice. I'm a web designer and developer that has been using other CMSs for years: Drupal, Wordpress, XOOPS, ImpressCMS. I've become very skilled on some of them, but also very aware of its limitations, and despite what other fanboys says, there is no perfect CMS for all scenarios. For this particular project, I know neither of them are a perfect solution, so I'm looking elsewhere. I've heard wonders about ModX, so I'm here, looking for advice.

The site is actually pretty simple: a database of movie scenes for educational purposes. That is, we have two objects:

1 - Movie. Simple data, just the title and synopsis.
2 - Scene: location of the scene (start and ending time), notes, keywords (the scenes will be classified by keywords), and the video sequence for this scene (20, 30 seconds of video).

Any Movie object can be linked to many Scene objects, and any scene object should be linked to one, and just one, movie.

Not too complicated. I could do this on Drupal in a breeze... but Drupal would eat tons of memory for that, I know it. I'm storing hundreds, and I mean hundreds of scenes and movie clips. A search on "scenes of anger" should give me no less than 50 results. Keywords are critical for this project.


So, that's my question: what would be required to do this using ModX? Is it the right tool for this job?

Thanks in advance. Best regards.

You can accomplish this easily with modx...
All you have to do is create two custom tables with one2many relation and after you set those it will be a breeze. To do that you should learn some xpdo http://rtfm.modx.com/display/xPDO20/Home and some modx basics, of course http://rtfm.modx.com/display/revolution20/Home

It will take some time, but it shouldn't take too long and it will be worth it in the end - I can promise you that.