Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Saturday, 24 November 2007

Notes on Taggart

Taggart is the code name for my newest crazy idea for a tagging system.

Put up mysql server with the usual password. Created db kpa, user taggart, as per in script in /usr/local/src/KPhotoAlbum-src/kphotoalbum/script/KPhotoAlbum

Ran script transferring all data from index.xml into MySQL. Created test script for getting out data, it seems to work.

Karrigell seems to be the nicer way to embed python in HTML, installed.

Next step: get list of images from a given folder and present them in HTML together with their tags. This requires some access methods -- they will be written as needed. Also need to interface with dcraw to get thumbnails - -c option is perty fast, but it needs downscaling too, and convert is slow. Using a faster resizer like point speeds it up a bit. Obviously need to cache these.

Note: filename and dirId are separate in the media db.