It seems phpbb does things like store every login attempt in its sql database, which maybe explains why I have a 1GB sqlite3 database. In this case, a text file might be more efficient.