|Please download from the links above, as it is big.
This is a general purpose small visual database using HList and Tk.
It can be used as a rolodex, dossier, teacher's aid, personnel manager,
or inventory control.
My aim was to make a general purpose graphical front end for data.
Now it uses Storable, but I eventually will connect it to
BerkeleyDB or MySql and/or Postgresql.
It uses Storable to store the data, backups are made
everytime the program exits.
To set it up, create a 'pics' directory, with at least 1 pic
called admin.jpg and 1 called default.jpg.
Then put all your photos into pics, (accepts jpg, gif, and png).
The zip file includes these and some sample photo's to demonstrate
something like a teacher's class database. ( I used the Sport's Illustrated
models for my development work, but I've included some "copyright free"
photos for distribution :-)).
On first run, the pics are converted to jpg, resized for height,
and the thumbnails are created. The entry names are taken from the
photo names, but can be changed after setup. On subsequent runs,
the Storable db is read and loaded.
I tried to make it fast, and it is on my machine. I only create
1 "display widget combo" and just fill it in with selection data.
To avoid using the "quirky" up-down-left-right keys behavior of
HList, I let it be controlled by the mouse. The scrolling is smoother.
To scroll the HList horizontally, either use the scrollbar, or click
on the "name" entry box, or the <-- label above it. You should see
how it works.
It includes color coding of the entries, and you could sort by color code.
I will do that later, right now the sort is alphabetical, with the
admin always at the top.
It only allows you to create 1 new entry at a time, called NEW. So if
you add entries, change the name NEW to a unique name.
You can change photo and/or thumbnail by right clicking on the main photo.
You can do batch operations on the db with a perl script. I've included
a sample zdbmanual. Make sure you make backups before trying anything batch.
To examine the database, run ztkdb with an ARGV, like "ztkdb 1".
It's got alot of features, so play with the buttons. Let me know
any glitches you discover. I've only tested it on Linux.
UPDATED Mar-06-2004 : Fixed a nasty memory leak which left old Photo Objects uncollected.