Limitations on the size of the database file
In order to time down the size of the database files the database should be able to split into several files. The mechanism assumes creating new database file for every year/quarter/month depending on the choice of the user.
Proposed database file name format:
username{date}___accountype.db
where
- username = username, i.e. user login (not NULL). The username string is also the primary key used to address the database file.
- accountype = {0,1}, where 0 is standard account and 1 is testing account (not NULL).
- date:
-
if not specified = the database file contains all messages. E.g. wkclse___0.db -> backward compatible with old Datovka. -
if _yyyy = database includes messages from only one year. E.g. wkclse_2014___0.db contains all messages from the year 2014. -
_inv for messages without correct delivery time = special database. E.g. wkclse_inv___0.db contains all messages without delivery time. (E.g. messages that have been rejected by the system or freshly sent messages.)
DONE: Split into several database files based on years was implemented in the version 4.4.0 as issue #184 (closed)
These possibilities are still open:
-
if _yyyyQx = database includes messages from only one year quarter. E.g. wkclse___0_2014Q1.db contains messages from January to March 2014. - quarters = {Q1, Q2, Q3, Q4}
-
if _yyyymm = database includes messages from only one month. E.g. wkclse___0_201411.db contains messages from November 2014. - month = {01, 02, ..., 12}
The database settings is set per account. It is going to be saved into configuration file. The messages are processed according the delivery time.