KPhotoAlbum, by Jesper Pedersen, is the photo/video cataloging and organising program that was packaged with KDE desktop on Debian/Ubuntu Linux distributions for many years. But there were a few things that annoyed me and a few requirements that it didn't fulfill. So I made a few customizations to the code for my own use.

• Use wildcard searching on some fields such as filename
• When entering a field value, show not only matching field names, but subfields for those names where they exist, eg start typing “flower” and it will bring up “flower→rose” “flower→daisy” etc
• Add extra parameter, along with date/time/filename, for each photo for grouping photos, in particular an “observation number” parameter
• When searching for and importing new photos, if photos have the same date&time, enter them into the database ordered by filename to try and keep their sequential order (eg rapid fire shutter release of a moving subject).

If any referenced page no longer exists, try looking for its URL on http://archive.org.