Logging

[HubbeKing]

The current thought is to use a database to store logs, having the log for each channel in a separate table.

The columns in the table would then be nick, timestamp, type, and message.

MySQL or some actual proper database would be preferable, if we can get a server going and maintained for that.

We can use sqlite, but scalability becomes a problem, and we start having to split logs per year or even month (still unsure as to how well sqlite scales, my guess is not well)

Moving the user aliases into this same database for easy stat-creation would also be good.

[HubbeKing]

ekimekim of the IRC has recommended elasticsearch, as it was designed specifically for freeform text search.

[HubbeKing]

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/getting-started.html
http://elasticsearch-py.readthedocs.org/en/master/

[HubbeKing]

Actually, keeping user aliases as they are sounds good enough. They're kept in the bot.dataStore dict, and log searches and stat generation would be bot modules, so they'd have access to that.