Photo Database Need Help
Posted: Sat Feb 28, 2004 2:51 pm
Well I have to say my biggest learning curve has been mysql. Mostly because all that data normalization stuff does not intrigue me to much.
I have been messing about with building a MySQL Database for photos. I tried using the binary method for storing images into a database (that failed). Please note I am not asking about this method I am specifying a path in my db
What I would like to be able to do is build a table that has:
a category for images so I was thinking category_id int not null auto_increment primary key, a category_description text not null, here is where I am having problems, thumbnail_path varchar(255) not null, and photo_path varchar(255) I would have to build another table for the images themselves my problem is how they relate I am not really understanding that part.
so I build that table category_id int not null auto_increment now what would go after that would it be thumbnail_id or photo_id, or what. Am I just completely lost with this whole concept
any help is always appreciated
I have been messing about with building a MySQL Database for photos. I tried using the binary method for storing images into a database (that failed). Please note I am not asking about this method I am specifying a path in my db
What I would like to be able to do is build a table that has:
a category for images so I was thinking category_id int not null auto_increment primary key, a category_description text not null, here is where I am having problems, thumbnail_path varchar(255) not null, and photo_path varchar(255) I would have to build another table for the images themselves my problem is how they relate I am not really understanding that part.
so I build that table category_id int not null auto_increment now what would go after that would it be thumbnail_id or photo_id, or what. Am I just completely lost with this whole concept
any help is always appreciated