- Add other reports
NewsStats should include some other kinds of reports (stats on used clients,
on postings hosts/servers, ...)
+ - Add tools for database management
+ NewsStats should offer tools e.g. to inject postings into the 'raw' database,
+ or to split databases.
* Individual improvements
+ NewsStats.pm
- General tests and optimisations
+ feedlog.pl
+ - Gracefully handle interruptions to database connection, at least log
+ lost postings (Bug #30).
+ - Buffer output that cannot be written to database (Bug #31).
- Add / enhance / test error handling
- General tests and optimisations
+ gatherstats.pl
- - Fix database updates when re-running (Bug #18)
- Change REPLACE to DELETE with subsequent INSERT INTO (erase wrong data,
- i.e. non-existent groups)
- - Enhance TLH checks to allow for more than one TLH
- - Make gatherstats aware of hierarchy lists (Bug #17)
- A current (!) list of existing groups (checkgroups or INN active) should
- be honored, with optional modifications. Non-existing groups should be
- (logged and) dropped, existing groups with no postings should be set to 0.
- Hierarchy elements (*.ALL) must be taken into account.
- Perhaps invalid group names should also be checked (but what characters
- should be considered "invalid"?)
- GroupInfo (see above) could be an alternate solution.
+ - Use hierarchy information (see GroupInfo above)
- Add gathering of other stats (clients, hosts, ...)
- better modularisation (code reuse for other reports!)
- Add / enhance / test error handling
- General tests and optimisations
+ groupstats.pl
- - output: fix formatting - GetMaxLength does not work for special queries
- like -l or -b
- - beautify output (formats / captions)
- - -a: improve code - it doesn't make that much sense to get first/last
- month from database just to query that same database with a time period
- that equals no time period ... this part of the WHERE clause should be
- dropped instead
- - change precedence handling of -m/-p/-a: drop -m if -p or -a are present,
- drop -p if -a is present
- - save report(s) to a file (Bug #27)
- better modularisation (code reuse for other reports!)
- Add / enhance / test error handling
- General tests and optimisations