[gribbli]

Hi guys,

I have been using Calibre ever since I got the Kindle 3 at launch and with some rare free time on my hands I decided to use the pair as the basis for some other technologies I am experimenting with.

So yesterday I knocked together a quick web app for use on the kindle browser, which allows me to view and search my calibre book collection and select books to have emailed to the the device.

All works pretty well, my only concern is resolving the filename in order to ensure successful sending of the book. At the moment I am using a join of the books and data table in from the sqlite db, where path/name is exact but the file format column is uppercase. I am running on linux:mint so case sensitivity is a potential issue. So my question is, is there anywhere that holds the full filename+exact extension that I have overlooked, or even just more reliable data for ensuring the matching?

@Mods: If I have posted this in the wrong place by all means kick me in the right direction.

Cheers,
gribbli