Multiple SQLite Databases

[cbk1994]

It would be awesome to have multiple SQLite databases. An example:

On Era, we use (or will use) SQLite for all logging, including player chat, item drops, trades, staff powers, etc.

We would eventually want to make a daily backup by script (which is possible with the coming NPC-server update) of the "main" database. This "main" database stores data such as the items players have, support center tickets, and bank accounts. The database would probably never get over 5-10 MB in size. We would then want to have a "logging" database, which holds all of our logs. This database could easily get to be 500+ MB, making it impractical to backup routinely.

Right now, our database on Era is approximately 400 MB, most of which is constituted by chat logs for the past 2 months. This makes it nearly impossible for us to back up the database at all. With multiple databases, we could easily contradict this problem.