in reply to Efficient log format

Howdy!

How about using SQLite to hold the logs. One table with a suitable set of columns to hold the parts of a log record might be all you need.

yours,
Michael

Replies are listed 'Best First'.
Re^2: Efficient log format
by jeepj (Scribe) on Mar 19, 2008 at 08:38 UTC

    Thanks for the suggestion, it's a good one, but for a lot of reasons (software complexity, maintenance, company policy regarding third party software...) I want to keep the whole process based on Perl scripts and the PCOMM software from IBM.

[reply]
      Howdy!

      OK. I don't know PCOMM at all, but I was presuming that one would use DBI to interact with SQLite to post entries to the log. One could develop log reading tools in Perl, or use the command-line interface that comes with SQLite to examine the logs.

      What I meant by my suggestion was to use a real database instead of a flat file for the storage mechanism.

      yours,
      Michael
[reply]

In Section Seekers of Perl Wisdom