Building a Wiki through MYSQL

March 12, 2007 7:29 AM

Which Wiki systems lend theirselves to allowing me to easily do an initial setup with MYSQL inserts to create the Wiki pages?

I need to set up a Wiki system spanning each day in history from January 1, 1960 to December 31, 2006 and have a page for each day (i.e. about 17,000 pages). Each page will have image tags to a unique image for that date that I am including (yep, thousands of unique images). So it makes sense for me to write a program which generates a slew of MYSQL inserts. This would do an initial setup for the Wiki system. Once in this Wiki format, visitors could add material and edit content.

On a lesser note, I'm wary about how to handle the images, as there's 6 a day (i.e. 100,000 of them). I'm not really sure about the implications of putting 100,000 GIF images in a single directory. I guess the Wiki systems don't split images into subdirectories, and I have no intent to start monkeying with Wiki source code.

Anyhow, has anyone had any experience building a Wiki database with simple MYSQL inserts? Which Wikis did you work with? Was it easy?

posted by hodyoaten to computers & internet (4 comments total)

Not sure if this is helpful, but there's a great table which lists all of the wikis side by side and gives you a detailed view of what features are available. You can find it here.
posted by pazazygeek at 8:09 AM on March 12, 2007

Um, Mediawiki 1) runs on MySQL, and 2) supports images. Find out how they do it.
posted by cmiller at 9:35 AM on March 12, 2007

I can help you with the images.
posted by boo_radley at 12:24 PM on March 12, 2007

In fact, if you've got your text data outside of mysql, you can modify that script to input articles pretty easily as well.
posted by boo_radley at 12:26 PM on March 12, 2007