English 中文(简体)
Should I use SQLite for automatically build a list of banned IPs of comment spammers?
原标题:

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?

最佳回答

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.

问题回答

暂无回答




相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签