View Single Post
  #1  
Old 12-20-2009, 09:56 PM
cbk1994 cbk1994 is offline
the fake one
cbk1994's Avatar
Join Date: Mar 2003
Location: San Francisco
Posts: 10,718
cbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond reputecbk1994 has a reputation beyond repute
Send a message via AIM to cbk1994
Multiple SQLite Databases

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.
__________________
Reply With Quote