If there’s anyone out there with a good deal of Data Base creation knowledge me and a couple of actual programmers are trying to figure out a pretty complex puzzle.
We’re interacting with what will be a database of many millions of pictures each connected to tons of info.
That’s where the fun starts… because we want to do some pretty cool filters, searches, displays.
Maybe a little Ajax action going on… we’re dealing with PHP and MySQL
So if you’re interested let me know and we’ll chat about it and I’ll give you actual specifics.
On a seperate note I have another DB question for another smaller project. (RoR and MySQL)
- If you’re really into it… I am a full time professional photographer and I’m more than willing to trade for your efforts.
- (Money could even be an option… but I don’t have the cash that a really good DB guy would usually get)
July 7, 2008 at 9:49 pm |
I’m the webmaster of my college radio station…I used it as an excuse to learn php and mysql. I also manage all of the sql databases and did my senior design project using mysql databases and network anomaly detection. I’m interested in whatever you got going, let me know.
AIM: eadaionx
July 7, 2008 at 11:08 pm |
Mitch: I don’t use AIM but you can contact me through my email jarvie (at) jarviedigital.com
July 8, 2008 at 9:00 pm |
Hi, my name’s Val. I’m a rising sophomore at Princeton University, you can find my 6 months out of date resume at http://www.princeton.edu/~vkarpov/resume.pdf . Currently I’m working as lead developer for a startup in Philadelphia, but the development is slowly winding down so I’m starting to get more free time. But basically, I have a ton of experience with SQL, the startup I’m working with involves me designing and managing a 30+ table MySQL database and interacting with it through PHP and Python with Javascript on the front end. I’ve also done a few side projects with MySQL, such as a plugin for NASA’s WorldWind software for plotting the location of visitors to your website on a 3D model of the Earth based on their IP addresses and a course selection web tool for Princeton University. I’m interested to discuss what you’re considering, shoot me an email at vkarpov (at) princeton.edu.
July 15, 2008 at 3:36 am |
Hey, you know who I am. Anyway, just thought I’d drop you a line and see if you’re still in need of my help. A good way to set up a database for this sort of thing might be to take a look at to see how they set up their database.
Another thing to take a look at is image repository sites like which has images, and images have tags, you can search on these meta tags, etc. People can edit tags create new tags, add, remove, etc etc. A more professional webpage that is not interactive is . Similar concept except they beg for money.
As for the database, I would suggest something like this
table images
int `index` auto_increment primary key ”gives you ~4billion indexs
text `path` ”path to file
varchar(40) `hash` ”md5 has of file for unicity (thus you dont get double uploads)
text `tags` ”holds the tags
int `poster` ”holds user id of poster
int `date` ”date image is submitted
int `status` ”a status variable? flagged? approved? deleted? archived? etc.
”add what ever you want.. etc.
table tags
int `index` auto_increment primary key
varchar(120) `tag`
int `count` ”counts instances of tags, (this table is for quick access of amounts w/o massive searching
table comments
int `index` auto_increment primary key
int `image` ”images index that the comment belongs to
text `comment`
table logs, query_cache, preview_images, etc (lots can be done to speed up the queries at the expense of memory and harddrive space)
For those of you who are quite versed in sql, please feel free to correct me. I’m sure there is something I could be doing better (like using blobs instead of text fields)!
Hope this helps
Joseph
July 15, 2008 at 3:36 am |
please excuse my missing closing tag on that last link.