[Teammetrics-discuss] The Database Phase

Andreas Tille andreas at an3as.eu
Wed Jun 22 07:05:30 UTC 2011


On Sat, Jun 18, 2011 at 02:07:32AM +0530, Sukhbir Singh wrote:
> repository.update()

$ git pull
Updating 27becba..cc3f4b1
Fast-forward
 archives.sql |    4 +-
 liststat.py  |   79 ++++++++++++++++++++++++++++++++-------------------------
 2 files changed, 46 insertions(+), 37 deletions(-)
$ python liststat.py 
Please run this script with root privileges.

:-(

> + Table name has been changed to 'listarchives' instead of
> 'listarchive' (reflected in archives.sql).

OK

> + Pushing the information into the database works completely, except
> encoding errors and spam. We will tackle that soon, but tomorrow I am
> going to get rid of permissions problem first (it's annoying).

If it comes to encoding I can warn you:  Dealing with i18n stuff
consumes basically 50% of the time of the whole project.  I had some
frustrating experiences in the past ...
 
> I).
> 
> liststat=# SELECT name, COUNT(name) FROM listarchives GROUP BY name;
>      name      | count
> ---------------+-------
>  Andreas Tille |     5
>  Sukhbir Singh |     8
> (2 rows)
> 
> II).
> 
> liststat=# SELECT name, SUM(msg_raw_len) FROM listarchives GROUP BY name;
>      name      | sum
> ---------------+------
>  Andreas Tille | 8224
>  Sukhbir Singh | 7297
> (2 rows)

:-)
 
> So I think that saving the message body was a good idea; we will see
> how it stacks up :-)

As long as I will win this is fine. :-)

Sorry for my short notice - I'm a bit occupied currently.

Kind regards

      Andreas.

-- 
http://fam-tille.de



More information about the Teammetrics-discuss mailing list