RoR newbie - file/directory browser and mysql table questions

Question posted by: ateale (Member) on April 18th, 2008 09:24 AM

Hi Guys,

I am using ruby on rails trying to develop a basic cms/dam for our company.

The work we do is post production for television commercials. Each tv commercial we do broken down into 'shots' (or edit), and each shot usually goes through multiple versions/iterations. And lastly each of these shots incorporates elements from 2d and 3d artists - each having multiple versions.

What I want to do is find a way for artists/clients to be able to browse all these assets/versions via RoR in a browser.

So far I have been unable to find a way to create a 'file/directory' browser using rails.

Also, I am unsure of what way to setup the mysql tables to handle all this.
Do I just make one massive table?

If that doesn't make any sense I can elaborate more.

Any help would be fantastic!

Cheers

Adam

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

acoder

Site Moderator

10,173 Posts

July 4th, 2008
10:37 AM
#2

Re: RoR newbie - file/directory browser and mysql table questions

Quote:

Originally Posted by ateale

Also, I am unsure of what way to setup the mysql tables to handle all this.
Do I just make one massive table?

No, if you do that, you'll regret it! Look at a normalisation tutorial, e.g. this one, to give you an idea on how to set up your tables.

Not the answer you were looking for? Post your question . . .
174,847 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top Ruby / Rails Forum Contributors