Re: [ts-7000] Storing messages/events

[Ross Wakelin <>]

Have a look at SQLite, small, fast SQL that can be embedded in your program

Ross

 

On 25/03/2010, Achim <> wrote:

 

Hi all,
to store temperatures and other measured values within an TS-7550, I use RRDtool - a really great database for time based data.
But I also have "events" which appear irregular, sometimes 10 a minute and then nothing for one or more day. Some of these events even appear not over years, so how to store and evaluate them?
The RRDtool data are displayed on a time based graph, very nice.
It would be perfect, if these events could be inserted into these graph, e.g. as hints, or bubbles and positioned at the correct time.

Events are thinks like:
- An engine starts/stops
- Somebody pushed a switch
- An error occurred
- A specific (maybe critical) state was entered

Of course, errors are already handled via Syslog, but this is more human readable format.
Currently I misuse RRDtool with a small step and a huge heartbeat to store 32 bits of integer and have a lot of trouble with this.
Do anybody know about a tool as powerful as RRDtool but for efficient storing asynchronous events?

Thanks a lot
Achim

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: =Email Delivery: Digest | m("yahoogroups.com?subject","ts-7000-fullfeatured");=Change Delivery Format: Fully Featured">Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | =Unsubscribe

__,_._,___