Should I use SQLite for automatically build a list of banned IPs of comment spammers?

Question

I am using a simple yet effective anti-spam system at a comments module which seems to be working flawlessly for more than a year now.

Since it is capable of recognizing automated comment spam attempts, I am thinking of extending this security module with an ability of adding the offender IPs to a blacklist automatically.

Do you think that I should use PHP's SQLite for this, or should I stick to MySQL (which I'm already using at the site)?

Is there a difference at all between the two database systems in this regard?

Answer 1

If you're going to extend something that already uses a DBMS, stick to that DBMS. SQLite is as good as MySQL for a project like this, but I wouldn't mix both DBMS in the same module, if it's what you're worrying about.