954577 - Use SQLite to save history/logs

Status: RESOLVED WONTFIX

(Chat Core :: General, defect)

Description

[Instantbot]

*** Original post on bio 1144 by Karel Jára <jara.karel AT gmail.com> at 2011-11-05 10:16:00 UTC ***

I don't know if this should go under bug 953505 (bio 54) but I rather report a new bug.

The thing is that the structure of logs how it looks now is really horrible from the perspective of a developer, if I am able to say something to that. Logs in hundreds of TXTs?

The solution would, in my opinion, be to store history in one single SQLite files, as it is actually e.g. in Firefox.

Comment 1

[Benedikt Pfeifer]

*** Original post on bio 1144 at 2011-11-05 11:44:27 UTC ***

(In reply to comment #0)

> The thing is that the structure of logs how it looks now is really horrible
> from the perspective of a developer, if I am able to say something to that.
> Logs in hundreds of TXTs?

This is a legacy of libpurple and we indeed want to replace the logs as soon as possible with a lossless format that allows to recreate complete conversations (as you see them during chat).
We already moved the logging framework to our code and need to change the actual logger to use a different format.

Comment 2

[Patrick Cloke [:clokep]]

*** Original post on bio 1144 at 2012-01-16 20:26:04 UTC ***

The logs are now stored in a JSON format. (Note that I'm not sure we could really save the logs into SQLite, as there's an awful lot of information when you sit in a bunch of IRC channels, etc.)  There are plans to index the JSON files for fast searching.

I'm going to resolve this as WONTFIX.