FreeFilter in SQLite

FreeFilter is hard to adapt to sqlite. You have to change the DSN (which was a few minutes' adventure; the Python database interface doesn't use DSNs). You have to change the int auto_increments in the installation SQL to integer primary keys. You have to change the triply-escaped "s in the initial post's link to single quotes because it doesn't like the triply-escaped "s for some reason. You have to look for the $sth->rows() == 0s in subs.pl and change them to $sth->rows() < 1s because apparently sqlite returns real invalid results instead of valid, empty ones.

But hey, after that, it works.

Comments

comment

miss you, mark…. check out my rambling website. hope all is well.