in reply to Mocking time with SQLite
Based on the 'LD_PRELOAD' example shown at the 'faketime' page, it certainly appears to be a plausible solution. I can't see how you'd use it from within a Perl script, but launching the script with
LD_PRELOAD=/usr/local/lib/libfaketime.so.1 FAKETIME="-15d" ./my_sqlite_script
should do it. (Thanks for the link, BTW; I'm actually going to download it and try it myself - it would solve a couple of minor testing situations for me. :)
Education is not the filling of a pail, but the lighting of a fire.
-- W. B. Yeats