Simon, > Date: Thu, 20 Feb 2014 14:04:59 +0000 > From: Simon Slavin > > On 20 Feb 2014, at 1:56pm, Patrick Proniewski <pat...@patpro.net> wrote: > >> Thanks for you reply. In fact I would like the script to remain portable. >> I'm running all this on Mac OS X 10.6.8 (sqlite3 3.6.12) but I plan to share >> it and use it on FreeBSD too. And developing a extension is probably out of >> my reach :) > > I don't think the thing you want to do can be done easily within SQLite. I > would expect to see it done in whatever programming language you're using. > > One approach would be to save two columns when you extract from EXIF. One > has exactly the text from the EXIF column. Another would be to save the > factor as a REAL number. Do some string processing to get the bit before the > '/' and the bit after it, and divide one by the other. > > You might be able to do the same calculation inside SQLite but it'll be > horrid to look at. Something like > > SELECT > expTime,substr(expTime,1,instr(expTime,'/'))/substr(expTime,instr(expTime,'/')+1) > AS etAsReal FROM photos
I'm going to rework my database to include proper "already calculated" columns, but using bash to do the math would have been a little bit unpleasant (not enough streamlined for my liking). Fortunately exiftool has an option to extract raw value for EXIF tags, and I've found a way to read them exactly as I need, "one-pot". thanks, Patrick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
