Quote:
Originally Posted by Sexgenoten
I assume you are going to use the foreign key options within the database?
I wouldnt make a field 'num of images' in the Gallery table. Just make a count on Gallery_images table. This way you will never have to manually update your Gallery table if the images set get bigger or smaller.
If you dont mind me asking, are you going to use mysql or postgresql, and why?
|
Hey, thanks for the suggestions.
Sorry, I kinda always do my rough outlines a little sloppy and don't always include everything I was thinking. I'll be using the foreign get for the gallery_id in the Gallery_images. I'm just in the thinking process of this, if you have any better suggest for that, I would appreciate it.
Yes, you are right about the 'num of images' I can use the count function in mysql but I'm wondering if it might just be better in the long run to have it there. I'll try to think if they're benefits of having it.
Yeah i don't mind you asking. I'm actually just using this to get back into programming. Its been a while for me so I'm trying to do a project that I can use for my sites and as portfolio work. It will be done using PHP and mysql. The rough programming is pretty much done, just have to fancy it up now. I'll be adding a function where you can upload .zips (kind of done already), use smarty for templating and caching. I'm also using imagemagick and a movie converter, but forget the name since its been a while since I have played with it. Once its done I'll had some Ajax to it wherever it would work.
I'll be honest, this is my first time checking out PostgreSQL and I actually like the functions that it carries. Its has a lot of things I would love to use, but right now I think I'll try to finish in Mysql and then switch over once the program is actually done if I feel it will benefit me or maybe I can use as portfolio work.
Are you doing a lot of programming projects?