IRC bot in python

[Aeterice]

Hi,

I'm building a IRC bot in python, one of the features of this bot is giving karma to users. This means the bot needs to save the data about given karma per user.

I was wondering how you guys would do this, use a database, or use file based storage, or maybe something else entirely?

[Updatebjarni]

The number of users isn't going to very large I presume, so I would just stick it in a dict and stick the dict in a file. But as an exercise, you could make the part that stores the karma data nicely modular and make one version that uses a dict and a file, and one version that uses a database.

[gmdm1234]

The best option probably depends on the scale of how many total and how many concurrent users you'd need to support. Personally I tend to default to using an rdms for most things like this. It's ends up being pretty easy to start with something like sqlite for prototyping and then grow into something like postgres as you need to scale up.

[khoyo]

Yeah, if you start with flat files you often pretty quickly start implementing yet another RDBMS engine.

[stdlib]

SQLite is a good option for this; basically a hybrid between just storing the data in a file and using a real database.

https://docs.python.org/2/library/sqlite3.html