Wanted: Reactive Agent Frank
May 28th, 2008 by 
Phil
Agent Frank was super-useful as a personal proxy back in the day, but in the end it introduced too much of a delay into my daily browsing and I turned it off.
Now that Firefox’s history is powered by a SQLite database I was hoping to be able to query it for my history every x minutes, request the pages and store and index them locally.
The documentation of SQLite on MDC seems to be quite lightweight but what it does tell us is this:
“How to corrupt your database: Open the database from an external program while it is open in Mozilla”
Balls. Other ideas?
Tagged: xul | 
It’s just a file. Can’t you copy it and open the copy?
Posted by Aristotle Pagaltzis on May 28th, 2008 at 1:49 pmIf I do that whilst firefox is running I get a corrupt database.
Posted by Phil on May 28th, 2008 at 2:16 pmHmm. Maybe write some trivial Javascript that performs the queries within Firefox and then use JSSh to pull them out into an external process?
Posted by Aristotle Pagaltzis on May 29th, 2008 at 2:42 amYes, that did occur to me too, but is tragically more work than a cron job with a SQL statement in it ;)
Posted by Phil on May 29th, 2008 at 9:46 am