creating my own gallery database program

[doctahjones]

i'm an IT guy and i love to dabble in web development and databasing (asp and mssql specifically)

i'm starting to spin up my website and started thinking about online galleries.

i started thinking that i haven't really seen (although i really haven't investigated and i'm sure there is) a online gallery 'program' for your own website that allows you to have logins for clients/familys/groups to see just their photos and put comments (private for you, or for their group, or for public) on them. in addition you'd have public photo galleries that would show the pictures you'd marked (like bridals, es, portraits, etc).

anyone already develop something like this, and/or would anyone have a use for it? i might be persuaded to implement it on someone else's website after i get it going on mine. i'm betting it's going to be about a 1-2 week project, depending on how much time i get to put towards it.

[Steelsun]

Sounds like a good idea.

The biggest problem I see with most gallery setups is the complication. Hard to implement and/or hard to keep using (uploading new galleries, bulk uploads, edits of comments, spam control, etc)

[doctahjones]

yeah i hear ya, and am actually a little worried about that stuff.

i'd be building admin pages so that the 'owner' of the gallery would be able to do their own comment approvals, and would have the option of getting email notifications when comments were made.

the other part that's scary is the batch uploads. i've actually never messed with this part, but i know it's possible since we do it through where i work. luckily i have a team of developers i can hit up for tips and tricks :)

i made alot of headway last night in setting up table structures and relations, etc...man i love developing...sometimes i wonder why i choose sys admin over development...can't do both, there's too much to know on either side.

[ngoduyviet]

There are quite a few open source gallery out there that's exactly as you described. Coppermine came to mind, although it was LAMP (Linux, Apache, MySQL, PHP) but the concept is similar if you want to download and play with it.

If you don't want to write your own database abstraction layer, there are a few really good MVCs (Model View Control) out there that helps with it. Unfortunately most are LAMP, but you can peek at it to get a good idea of what's there to use instead of writing your own. If you can google something similar for MS products, you can avoid a lot of security problems & shorten your dev time substantially.

[Hikin' Mike]

I'm using a database-driven website using MySQL and PHP. I designed the website/gallery, but a friend of mine did the MySQL/PHP stuff.