Khakilist: Web Based Flat Text Database

Welcome. Here you can get the latest version of Khakilist written by me: Kjeld Borch Egevang.

Originally I made this script to maintain a list of DVD's. It is written in Perl and can be used to maintain any kind of simple list. Features are:

Uses CGI module
Add/delete/edit lists
Add/delete/edit records
Simple password protection
Nice ascending/descending sort of columns
Uses cookie to remember username
Database consists of tab separated lines
Locks database via flock
Positional references with $1, $2 etc. makes it possible to make nice links
Support for plug-ins

In the distribution are two examples of lists:

A DVD list. Automatically links to imdb.com.
An OoO list (out of office). Entries are automatically deleted when they are old

Install the files khakilist.cgi and *.dat in the server's cgi-bin directory. Then:

chmod 755 khakilist.cgi
mkdir data

You also have to install the CGI module for Perl (it's probably already installed).

Download version 2.2 here: khakilist.2.2.zip
Download version 2.3 here: khakilist.2.3.zip
Download version 2.4 here: khakilist.2.4.zip
Download version 2.5 here: khakilist.2.5.tar.gz

If you like my script, please rate it!

E-mail:

You can try the script here. Please don't abuse this service. The master passwords are: <none>, x22, x23.

master.dat

The first line of the master.dat file consists of 5 (tab separated) fields: Title, 3 passwords and e-mail address. The meaning of the passwords are:

The first one allows listing all lists
The second one also allows adding new lists
The third one even allows editing/deletion of lists

You'll have to modify these passwords with an editor. You can leave any of them blank, if you want to disable password protection. The passwords used in the distribution are <none>, x22, x23.

*.dat

Whenever you create a list the title, passwords, e-mail address and description of the fields are saved in a <name>.dat file. It consists of tab separated lines.

data/*.txt

The actual data in the lists are saved in data/<name>.txt. The file consists of tab separated lines.

Apparently modern Apache servers do not allow Perl scripts to write files in the /var/www/cgi-bin directory. If, however, you change the ScriptAlias setting in /etc/httpd/conf.httpd to another directory and put khakilist here, it will solve the problem.

Latest change: 2009-03-27

Find great lingerie in the shop Butikki.